web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Update Row Multiple Values overwrite themselves

(0) ShareShare
ReportReport
Posted on by

Hi Community,

 

following problem, I have a flow that needs to update a row in Excel. In my PowerApps I have a field which autoselects the person who is using the app, but it is able to add another person.

 

Now I need to update this to a an excel row. But my flow automatically added  an Apply to each container and now only the second person will be saved in the excel row.

 

How can I fix this to add the second person Display Name to the first one?

 

Here an image:

image001.png

 

I have the same question (0)
  • tom_riha Profile Picture
    10,179 Most Valuable Professional on at
    Re: Update Row Multiple Values overwrite themselves

    Hello @Anonymous ,

    the 'Apply to each' is added because of the possibility to add multiple users to the 'Presenter' column. If it's a multiple people picker, then Power Automate will consider it as an array = 'Apply to each' to process the items in the array one by one. In your situation it'll update the 1st presenter and with the next run overwrite it with the 2nd presenter.

    You should initialize a string variable, loop through the 'Presenter' array before the update and 'append to string variable' the presenter display names. Then you can use that variable to update it in the row (without 'Apply to each'). 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard