You’re offline. This is a read only version of the page.
Hello,
I am trying to build a flow that takes the responses of multiple flows (in my case 2) and combines them into a word file.
The flow/flows/solution should be able to:
- Get the response of user1 to Form1
- Send an approval request using the extracted information to user2
- Get the response of user2 to a Form2
- create a file that contains all information extracted from Form1 and Form2
So far I wasn't able to create a fully automatized solution. What I did so far: I created two separate flows, so that, while filling out Form2, user2 must manually input a ID provided in the approval request, that links the flow to Form1.
I tried several workarounds but nothing works except this quick and dirty solutionThe same problem. I don't particularly like it because of the manual user input. The same issue is described here (Solved: Chain multiple forms in a flow - Power Platform Community (microsoft.com) but the proposed solution is similar to mine, which is copy/paste some form/item ID.
Somebody has other ideas?
Thanks lot
@AlexEncodian Thanks for your reply.
I already have two separate flows and each of those saves the responses in two separate items, such as a Sharepoint list, excel or word file - I made several tests.
The problem arises because I have multiple processes where multiple users submitting the same form1. What I would like to have is the following:
Process 1: user 1 --> form1 --> file1_form1 --> user 2 --> file1_form2--> Joint file 1 : file1_form1_file1_form2
Process 2: user 3 --> form1 --> file2_form1 --> user 2 --> file2_form2--> Joint file 2: file2_form1_file2_form2
Process 3: user 4 --> form1 --> file3_form1 --> user 2 --> file3_form2--> Joint file 3: file3_form1_file3_form2
and so on
So simply storing the results would not work, because I still need an ID that relates form2 to that particular process/submission.
A good solution would be to use the "Populate Word Template" action, but unfortunately we don't have Premium licences.
Any suggestion?
@aivalf
You could store the form1 and form2 responses, for example in an Excel file or SharePoint list. You would have two use two different flows as a flow can only be triggered by a single form.
In your second flow, insert a wait action to make sure the form2 response is saved. Then get the data from both forms from the storage location and use it to populate a word document.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (