I am grateful to be asked to present a proof of concept at the Monthly Office Add Ins Microsoft Dev call on 12th May 2021. Thank you for the opportunity.
Using SharePoint Lists as a data source, Power Automate, and Excel Scripts, I will demonstrate how I populate an Excel Template Invoice used for Invoicing purposes. Existing Cloud Flow actions are limited to data manipulations on tables and rows created within an excel file, Excel Scripts open up a myriad of opportunities for bespoke data manipulation.
Please find below a list of useful links and hopefully, if things go to plan, this page will add some extra value during the live demonstration. Watch this space.
View my original blog post about this feature here or maybe you want to populate a word document without using premium features?
Previous monthly calls can be watched here.