cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
therush321
Helper II
Helper II

Filter a list of Form Responses to the ID captured

Hi

 

I have 2 forms that are completed in the same flow. When form 1 is completed, it sends an email out to the client to complete their details on Form 2 which they capture an ID which is the forms 1 ID so I can update the form 2 details with my form 1 details in a  SQL database.

I am having issues when there is more than 1 flow running and Client 2 completes form 2 before Client one gets to then flow one takes the details of form 2 rather than waiting for a response.

 

I think the issue is due to grabbing multiple responses for form 2.

Please see the image below:

therush321_1-1619094453474.png

 



4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

I assume the flow is triggered when Form 1 is submitted.  The problem is you really can't have two triggers in the same flow.  It almost never works.  If someone starts a new version of the flow by filling out Form 1 again Power Automate has no way to know which flow instance to Trigger when Form 2 is completed.  You'll need to redesign the flow so the triggers operate separately.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 Thank you. yes, the trigger is when a response is submitted.

I have created 2 flows.

The first one sends an email to the client with an ID for them to capture which is forms 1 ID.

The second flow takes the ID captured by the client which is flow's 1 ID.

The issue is I cannot validate the ID correctly as it uses the ID to update a record in SQL relating to Form 1 ID.

If the client captures an incorrect ID, I would not know unless I check.

Is there a way to resolve this automatically or even using forms pro?

Pstork1
Dual Super User III
Dual Super User III

There is no built-in mechanism for validating a Forms ID that I'm aware of.  You would need to capture the ID in some data source along with identifying information, like the email you sent it to.  Then when Form 2 is submitted compare it to the datasource and verify that it is the one you sent to that person.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 I see. Thank you.

I have just created a flow which will be sent to myself to validate each form response coming in so that it does not update the incorrect record.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,512)