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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |