Resolved : Struggling populating a word template and looping through multiple records

Like (0) Share

Report

Posted on 2 Nov 2023 15:18:41 by Gilles12

115

Hello. I am quite new on Power Automate, I have filled a Word template from the Dataverse with no issue for the header data of an invoice, but after one day searching on the net, I don't succeed looping in the detailed underlying records (in another table) to continue filling the array in the same template for different products. I tried to use the "List Rows" action along with a second action to populate the same template, an "Apply to Each" container is automatically created, I have done all the necessary mapping, but it seems that when running it cannot continue to use the template filled in the previous action. I have tried many things and workarounds, but nothing works. I hope some of you will be able to help me understand what is the proper way to achieve that! Thank you. See screenshots attached.

Categories:

Business Process Flows

Flow2.PNG

Flow1.PNG

All responses (1)

Answers (0)

Gilles12 115 on 03 Nov 2023 at 17:34:50

Like (0)

Report

Re: Struggling populating a word template and looping through multiple records

Resolved by myself, I have to use an array. I have found the solution in this video Generate Word & PDF Documents from Dataverse Related Tables Using Microsoft Power Automate✨ - YouTube.