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