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