Filter a list of Form Responses to the ID captured

therush321 · ‎04-22-2021

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:

Pstork1 · ‎04-22-2021

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.

therush321 · ‎04-23-2021

@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 · ‎04-23-2021

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.

therush321 · ‎04-28-2021

@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.