Populate Excel Templates e.g. Invoices automatically with Power Automate

In this video I am joined by Damien Bird who shares a fantastic technique to use Power Automate to automatically populate an Excel invoice using Excel scripts.
You can find Damien online at
blog - damobird365.bi...
RUclips - / @damobird365
Twitter - / damobird365
LinkedIn - / damobird365

[@utasdemir]

Thank you so much to share it. I was absolutely looking for it.

[@SiyamandRashid]

Thank you for the video, I have a question please: you used the filter to get all the orders for customer no. 3, can we make it more complicated and get orders for a particular customer for a certain date, in case the customer number 3 has orders in another day it should be populated to another invoice, I hope you got my point

[@alexanderalangghya6139]

Hello Damien, thank you for the great video and explanation but I was wondering can you help me with this error "Office Scripts cannot infer the data type of this variable. Please declare a type for the variable." in the line 43 ? Its asking me to declare the variable type of ObjSales but in the video I didn't see the line which declares Obj Sales.

[@cottagekeeper]

As a newbie this seems extremely stressful and overwhelming. Questions: Why doesn't it automatically number the clients and the invoice? How do you get this to print multiple pages? How does one without 20 years experience in data technology learn how to do this quickly? I'm a huge Airtable fan, easily jumped in and created all the tables I needed, the only problem is everyone that needs multiple page invoice/contracts has to purchase another app to make multiple pages. Wish Microsoft would consider the business owner that is just starting out and doesn't have the time or money to pay thousands of dollars to a developer to create a workflow that is easy to use.

[@adebayoogunmoriyele5497]

Nice video. I would like to have the script and study. How can I get it?

[@damienbird6632]

Hi, I've since released a few more Excel Script concept videos here ruclips.net/p/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM and I've got my Script Code here github.com/DamoBird365/PowerAutomate if you want a look.

[@user-xo3bb4cv4p]

i think creating the template is one of the most important aspects of all this and you basically skipped all the meaningful parts. A video on that step with more details and examples would be helpful

[@MrJackTrades]

Will this work for Google Sheets too?

[@rajamahendrareddyvangala114]

Great Video Damien! Is it possible to create our own excel templates?

[@DamoBird365]

Hey Raja, absolutely. If you need any help, feel free to drop me a DM via social media or catch me on the forum powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

[@josephnasr3385]

@@DamoBird365 There's something strange though, how did you get a CustomerArray in the Run Script Action? Did you declare it in the script's Main function as an array like: CustomerArray : Customer[]