Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Update a sharepoint list row based on a common value of another row (same ID)

(1) ShareShare
ReportReport
Posted on by 2

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.

MarcosEng21_0-1720003333832.png

 

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.

 

MarcosEng21_1-1720003362059.png

 

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.

 

MarcosEng21_2-1720003994233.png

 

Thank you very much

Categories:
  • FLMike Profile Picture
    FLMike 31,580 on at
    Re: Update a sharepoint list row based on a common value of another row (same ID)

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard