The Microsoft Excel Office Scripts Team has created a very clear webinar that introduces Excel Office scripts and also gives a very insightful code demo. The demo shows how to integrate your Office Script with a Power Automate Flow passing a parameter into and out of the Excel Office Script.
You need to register to see the webinar at this URL:
https://msft.it/6046bYD9o
In the GitHub repo, for this video,
https://github.com/MrAnalyticals/OfficeScripts/blob/main/MSFT%20Webinar/ReadMe.md
I have, also, posted the QnA for the webinar. To further expand your knowledge about Office Scripts Microsoft has also provided a detailed Tutorial here:
https://docs.microsoft.com/en-gb/office/dev/scripts/tutorials/excel-power-automate-trigger
For those knowledgeable about Azure and Azure Functions one of the things that is not very well known, about Office Scripts, is that it can replace the Azure Functions service. That is, you can have your code run as part of a Flow triggered by an event. This is exactly what Azure Functions does.
Hope you enjoy this video. Check out my business website too.
Download
0 formats
No download links available.
New Microsoft Webinar Using Excel Office Scripts with Power Automate | NatokHD