Hi @OzarkOnline ,
You will need to pass the data from your gallery to a cloud flow in Power Automate. To do this, create a new instant cloud flow and use PowerApps as the trigger:
You will likely have more variables to initialize and perhaps other steps, but this focuses on how to get your gallery lines into Power Automate as a JSON table and then how to insert that into your Microsoft Word Template.
Initialize a variable of type string. For Value, select "Ask in PowerApps". This is how we will pass the data from PowerApps to Power Automate.
Before finishing the flow, connect to this flow from Power Apps. Insert a button for calling the flow. While having the button selected, click on Action in the toolbar and then Power Automate.
A pane will open on the right which will show all available flows. Select the flow you just created.
It will add "FlowName.Run(" to the OnSelect property of your button and ask for a variable to pass to Power Automate. This is where you want to pass the collection used in your gallery.
FlowName.Run(
JSON(
CollectionName,
JSONFormat.IndentFour
)
)
Hit the button and run the flow.
Going back to the flow, you should see a successful run of the flow.
Click on the date to open the flow run. Copy the text from Value field in the variable you created.
Edit the flow. Create a new step called Parse JSON. The content will be the string variable from above. For Schema, select Generate from sample. Paste the text you copied a moment ago and hit done.
Create a new step called Select
From is the 'Body' output from the Parse JSON step. In the Map section, enter all fields that show up in your table in the Word template as Keys (left side). The "Values" should be the corresponding field from the Parse JSON step.
Finally, you will add that to your Microsoft word template using the step called "Populate a Microsoft Word template". Navigate to where your file is stored, and where you come to the repeating content control, change the input method to input entire array:
Then use the Output from the Select step as the value:
This will generate the appropriate number of rows in the Word template.
If you found this post helpful, please consider Accepting it as the solution.
