Power Platform Community Forum Thread Details

Hi all,

I appreciate your help in trying to help on this one.

I have 2 forms:

The 1st one the requestee fill-in some information and it triggers an email with a link to the 2nd form to the planner to take action based on the ID informed by the requestee, the information is saved on a sharepoint list.

The 2nd one, the planner inserts the ID provided by requestee and add his ouputs, the information is also saved on the same sharepoint list.

What I wish is to update/copy the cells (Requestee Name, email, site, product, SKU, request date, reason for change) on the row ID - Submited to the row ID-Completed line, where is information is empty. The trigger to update would be the Unique ID from the second column.

I do not want to delete the ID Submited line, because I want to keep the date on the 3rd column, that might be different from Submited to Completed rows.

Thank you very much

Categories:

General topics

Hi @MarcosEng21

Just to be super clear you want to Back Fill the original submitted form, with data coming from the Second form so that they match in those columns, but keep the unique values otherwise.

There are a few things but I will make this suggestion.

On the second form, as the last thing, add a Text Field called LinkId or something

In your List, add another column called LinkId

In the Power Automate flow that sends the link for the second form, create a GUID at the top and apply it to the Create Item for the first row of this "batch" of 2

In the Form URL append ?LinkId=YOURGUIDHERE

On the second form, the last text box will have that value in it and have it "on the form" as LinkId

when you submit the second form, first, do a Get Items, to query out the existing first row that has the LinkId that was just submitted back to you on submission of the 2nd form

Update that record with whatever values you just got

Make sure to include the GUID in the 2nd rows LinkId as well, so you know which 2 go together.

All you have to worry about is, are your users ok with not touching that field.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey