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 ,
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
@MarconettiMarco I put the variable in the Update items 5 as I want it to be the same writing as the variable
@syhrh ,
in the Update item 5 action, instead of the variable, you should put the Approver value got from the Update item 4 action.
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.
@syhrh ,
do you want to update the "Approver(s)" column? Which type is it? A Person/Group column type?
BR,
Marco
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.
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
@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?
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