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
Dual Super User

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?

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,761)