Populate Document Tables with Power Automate and JSON

Populate Document Tables with Power Automate and JSON

In a previous blog, we covered how you can populate a Word document template using Power Automate.  In addition to populating plain text fields in a doc, you can also Use Power Automate and JSON to populate Document Tables using the Repeating Section Content Control. Keep reading to see how.

What is Power Automate?

Formally known as Microsoft Flow, Power Automate is Microsoft's code-less tool designed to automate your business's repetitive and manual tasks.  With Power Automate, you can:

  • Automate business processes.
  • Pass data between nearly every application in the Microsoft Stack.
  • Connect to any publicly available API.
  • Automatically send reminders and create events for your business.
  • And much more!

Click here for countless examples of how Power Automate can fit your business needs.

Using 'Repeating Section Content Controls'

If you want to create a static table in Word and fill it with data, all you have to do is insert a new table in your doc, and add Plain Text Content Controls in each cell:

Then, you can populate those controls from Power Automate.

If you don't know the number of rows ahead of time, you can use the Repeating Section Content Control.  Highlight 1 full row of cells, then insert the Repeating Section Content Control:

All that is needed now is to populate this input with some JSON data! Consider the following JSON Array example:

[

{

"Account": "ABC Construction",

"Primary Contact": "Mike Green",

"Annual Revenue": "$10,000.00",

"Status": "Active",

"Owner": "Sarah Blue"

},

{ "Account": "Corey's Company",

"Primary Contact": "Corey Williams",

"Annual Revenue": "$8,500.00",

"Status": "Active",

"Owner": "John Red"

},

Continue Reading on www.beringer.net

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons