Answered

Update items twice on the same row in Sharepoint list

(1) Share

Report

Posted on by syhrh

997 Super User 2024 Season 1

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.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @syhrh ,
you can avoid replacing data following this example:
1. Update item in the Title field:

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:

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

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

BR,
Marco

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @MarconettiMarco, it works, thank you!

Was this reply helpful? Yes No