I have replicated your example but using ask PowerApps input parameter instead of Json code directly. Do you have experience passing Json code from powerapps to powerautomate. Hi Damien, please is posible your help on this?. I have prepared my two arrays as follows: I also supply my Action with several other data fields, including invoice number, date, vat rate amongst others, all of which can be supplied dynamically if you require. I have prepared two arrays, one for the customer data and another containing the multiple line order details. I have the blue invoice template stored on my OneDrive and will take a copy of this file each time my Power Automate runs, saving a new copy with dynamic name, allowing multiple invoices to be saved. I apologies to the seasoned programmers for any obvious mistakes in my code but what I have achieved is a working proof of concept ready for UAT. I downloaded the Blue Invoice for my proof of concept.īefore I get started, I will admit that in the past 24 hours, I have had to learn TypeScript from scratch. If you haven’t discovered Excel Templates it is worth a look. Not only will it complete the customer details, name, address, invoice number, date etc, it will dynamically complete the rows that make up the item order. I’ve build a TypeScript routine in Office Scripts that will intuitively accept dynamic data via Power Automate, including arrays and it dynamically fills out an Excel Template Invoice.

However, are you aware of Office Scripts in Excel On the Web which is currently in preview (March 2021)? Via Tables in Excel you can add and update rows in Excel but it can be quite complex to achieve anything more. You will have probably used the Populate a Microsoft Word Template (Premium) action in Power Automate before but will be saddened to learn that Excel doesn’t offer the same functionality.

Microsoft office invoice generator