I'm guessing you want to add that list of SQL data into a Word table?
You should add a repeating table to Word then. You can do this by adding a two-row table to your document and set the headers (first row) statically.
For the second row, you need to wrap it inside a Repeating Section Content Control (thought the Developer tab): just select the entire row and click on the Repeating Section Content Control button:
By clicking Properties, you can set a Title to that Repeating Section, making it easier to identify from within Power Automate:
To fill in your table cells, you need to select each cell individually and assign a Content Control to it (e.g. Plain Text):
For each cell's Content Control, you can edit the properties as well, just as the Repeating Section, to make it easy to identify:
You can add values to your Content Controls inside your flow:
Or - in your case - build the JSON from the outcome of your SQL output, e.g.:
[
{
"Text1": "Row 1 - Text 1",
"Text2": "Row 1 - Text 2"
},
{
"Text1": "Row 2 - Text 1",
"Text2": "Row 2 - Text 2"
}
]
The Populate a word template action does not create the file. That's why I added the Create file action. This will create the file eventually:
