Two MS Forms combined into one SharePoint List

Like (0) Share

Report

Posted on 21 Nov 2022 20:02:54 by omer301

Hi all,

I have two MS forms

Form 1 is filled by the user with various fields such as date, name, etc. and is then added to a SharePoint list. This is an approval form which uses the approval template on power automate.

This flow updates the SharePoint list based on the unique approval ID, and then sends an email with the link to the second form.

In the second form, I have a simple yes/no option that I want to update in the same row of the first form that was added to SharePoint. This is the part that I need help with. After some googling, the suggestion was to use a unique ID and ask the user to enter the unique ID from the first form into the second form. Then in Power Automate check if the ID's match, and if so, update that row in the SharePoint list. This is what I have done so far but I am unable to see any changes in the SharePoint list.

Categories:

Business Process Flows

I have the same question (0)

Summarized by AI

All responses (4)

Answers (0)

SudeepGhatakNZ 14,381 Most Valuable Professional on 21 Nov 2022 at 20:33:46

Like (0)

Report

Re: Two MS Forms combined into one SharePoint List

@omer301 ,

I am not getting the full picture. Do you have two separate flows each with a form's trigger?
If yes, you must pass the reference somehow (either in the MS Form or otherwise).

Was this reply helpful? Yes No
omer301 on 22 Nov 2022 at 04:36:46

Like (0)

Report

Re: Two MS Forms combined into one SharePoint List

Yes, I have two separate flows each with a form trigger.

I pass the reference by asking the user in the first flow via email to send the approval ID to the second flow. But I am struggling with adding the second flow information to the SharePoint list

Was this reply helpful? Yes No
Ajinder31 530 on 22 Nov 2022 at 05:51:59

Like (0)

Report

Re: Two MS Forms combined into one SharePoint List

Hi @omer301 , Please confirm if unique ID entered in form is ID of sharepoint row.

If Yes, then probably we don't need to perform Get Items and we can directly use Update Item action.

Was this reply helpful? Yes No
omer301 on 22 Nov 2022 at 09:31:37

Like (0)

Report

Re: Two MS Forms combined into one SharePoint List

Yes, it is the same ID from the first form, but it is not updating for some reason.

This is the ID generated from the first form, and the user enters this ID in the second form.

Was this reply helpful? Yes No