Trigger a Power Automate Flow from Excel with Office Scripts or VBA | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post & find the code to copy ★
https://exceloffthegrid.com/power-aut...
★ Link to HTML encoding references on W3Schools ★
https://www.w3schools.com/tags/ref_ur...
★ About this video ★
Office Scripts can be very useful, but they are limited by being bound within one workbook. What if we could instead use a Power Automate flow to give us full cross-application functionality? Well, there is no official solution, but here is how to run a Power Automate flow within Excel or VBA.
0:00 Introduction
0:52 Setting up the Power Automate flow
4:11 Editing the URL for parameters
7:28 Running Power Automate from an Office Script
9:38 Running Power Automate from VBA
10:38 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel