I have a Power Automate flow where when I select multiple payment records, the payment details populate in a Word Template with all of the payment details and creates DocuSign envelope. However, the flow is currently creating the x number of Word Templates for x number of payments selected. I just want one Word Document created. I created an array and have array populating in Word Template that that is not working. I am not sure what step I am missing. Any suggestions?
It sounds like the create template action is behaving as if it were in an Apply To Each loop. Your screenshot does not show that, which is weird. Perhaps that is happening inside your condition.
Regardless, before generating your template, you need to consolidate all array items into a single output. I personally like to use the format as a HTML table action. That will force the array to print it out all at once as a table. You will then want to insert the output of the HTML action inside your word document. I have never tried to do that myself with a word document so I don’t know how well those actions work with each other. Please let me know how that goes!
Thanks so much, Jonathan. I had the trigger as manually run and then when I changed it to When a row is selected and Apply To Each Loop were not created, but it still behaving that way, and I don’t understand it either. The condition only pulls another related field based on what is entered in the field.
I tried the HTML action but it is still only pulling one record at a time like the array and giving me multiple Word documents. I am not sure what else I need to put into the HTML action to pull the information from all of the records selected. I appreciate your help!