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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update multiple rows i...
Power Automate
Suggested Answer

Update multiple rows in excel

(1) ShareShare
ReportReport
Posted on by CU28060308-0 35
Hi,
 
In the Excel's UpdateARow action,
 
my goal is to update a cell for the row I am currently working on inside a foreach loop. This foreach goes over all of the rows inside of my excel table and I want to set one by one a cell to a "done" status.
 
Is there a way to reference the specific row or row number of the item in a foreach to only update that row?
 
Thanks
Categories:
General topics
I have the same question (0)
  • WillPage Profile Picture
    WillPage 2,335 Super User 2026 Season 1 on at
    You need a unique key column in your table - that is to say a column where the value in each row is different. If you don't have one now, you can add one to your table and generate unique values by doing something like =RAND() * 100000000000 in another sheet in Excel, fill down to the number of rows you have in your table then copy and paste values into the table - important to paste values only not the formula that generated them.
     
    In the Update a row action, select the key column, let's say it's called Key and the Key value will be items('Apply_to_each')?['Key] in the expression editor.

    N.B you will need to put a unique value in each time you create a new row. If you're creating new rows in Power Automate you can fill it with guid()
  • Suggested answer
    Tomac Profile Picture
    Tomac 4,061 Moderator on at
    To begin, you'll need a defined table in your Excel file using the Format As Table button:
     
    From there you'll need to have a "key column" of unique values in the table. In my sample spreadsheet, I'm using the PO column:
     
    Then inside of your loop you'll use the Update a Row action referencing this key column's value to select the specific row:
     
    That should be enough information to get you running. If you have any more questions, feel free to reach out. If this comment solved your issue, please mark it as the answer.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans