Skip to main content

Notifications

Power Automate - General Discussion
Answered

Update items twice on the same row in Sharepoint list

(1) ShareShare
ReportReport
Posted on by 997

Hi, how to update items on the same row twice in the Sharepoint list? When the second update, it just adds the information instead of overwriting the first update?

 

Thank you.

  • syhrh Profile Picture
    syhrh 997 on at
    Re: Update items twice on the same row in Sharepoint list

    Hi @MarconettiMarco, it works, thank you!

  • Verified answer
    MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Update items twice on the same row in Sharepoint list

    @syhrh ,

    so you could also append your variable with the additional approver name.

    In this case in the Update Item 5 action, you should put only the variable.

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

  • syhrh Profile Picture
    syhrh 997 on at
    Re: Update items twice on the same row in Sharepoint list

    @MarconettiMarco I put the variable in the Update items 5 as I want it to be the same writing as the variable

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Update items twice on the same row in Sharepoint list

    @syhrh ,

    in the Update item 5 action, instead of the variable, you should put the Approver value got from the Update item 4 action.

  • syhrh Profile Picture
    syhrh 997 on at
    Re: Update items twice on the same row in Sharepoint list

    @MarconettiMarco 

    do you want to update the "Approver(s)" column?  

    yes and it's a single line of text column

    The Approver displayName is retrieved from the Get Items.

     

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Update items twice on the same row in Sharepoint list

    @syhrh ,

    do you want to update the "Approver(s)" column? Which type is it? A Person/Group column type?

     

    BR,

    Marco

  • syhrh Profile Picture
    syhrh 997 on at
    Re: Update items twice on the same row in Sharepoint list

    @MarconettiMarco 

    This is my flow. It loops twice based on the condition and your way doesn't work as it only updates the field based on the second update. 

    anonymous21_0-1660640343536.pnganonymous21_1-1660640385753.png

    anonymous21_3-1660640423904.png

     

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Update items twice on the same row in Sharepoint list

    Hello @syhrh ,

    you can avoid replacing data following this example:

    1. Update item in the Title field:

    MarconettiMarco_0-1660638792325.png

     

    2. Update again the same item always in the Title field, but in order to keep the previous changes, add the "Title" value from the first "Update item" action:

    MarconettiMarco_1-1660638825294.png

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

     

  • syhrh Profile Picture
    syhrh 997 on at
    Re: Update items twice on the same row in Sharepoint list

    @MarconettiMarco If the second update is also for the same field, it will be replaced no matter what?

    Even if I try using Join or Concat?

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Update items twice on the same row in Sharepoint list

    Hello @syhrh ,

    if in the second "Update item" action you're updating different fields from the first action, Power Automate won't replace any value.

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard