Uses a Sendgrid dynamic template to email the invoice to the recipient and track delivery.Saves the document to a custom SharePoint list that holds metadata about the document and makes it easy to find documents again.In it’s live implementation this flow also: Microsoft Power Automate can provide a good solution for automatically generating invoices or other business documents. Invoke-RestMethod -Method Post -Uri $FlowUri -Body $PostBody Conclusion In this example it was fired using curl from Linux like this: #!/bin/bashĬurl -v -d -H 'Content-Type: application/json' $hostīut it could just as easily be executed from PowerShell like this: $FlowUri = '.' This flow is triggered via a HTTP request with a JSON payload. I named the file as per the above step but changed the extension to. Step 4 – Convert the Word Invoice to PDF using the path from the previous step.For the Filename I used “INV_” + Invoice Number from JSON File + “.docx”:.Now your Word document has been populated you can save it somewhere that is appropriate for your environment (I used “Create file – OneDrive for Business).Then you can select the array from your JSON file. Click on the little box highlighted in red which switches the input to accept an entire array.When you reach the line items block it will first appear like this:.Go through each field and add them to the document, apart from the repeating fields.Flow will read the document and present a list of fields to be added to the document.Select the previously saved template file.Step 2 – Add the “Populate a Microsoft Word Template” action.When the flow editor appears click the “Generate from Sample” button within the HTTP Request flow part and paste in a sample of your JSON data and then flow will automatically generate the JSON schema which you will be able to use in the rest of the flow.Trigger the flow “When a HTTP request is received”.The flow is really easy to build and in this example there are only five steps: Save it somewhere you will be able to access it from Flow, such as OneDrive or SharePoint. Now that you have finished editing the Word document.

Invoice template in word document