cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Excel updates the first row only but not the next row

Hi,

 

I have created a workflow to get the details from a excel file and submit the details to a UI Flow and then track the status back to excel sheet.

 

While updating status back to excel using "update a row", is updating the first row and errors out for the next row.

 

Here is the screenshot of the workflow.

Excel1.JPGExcel2.JPG

 

Please let me know if any details are needed.

 

Thanks for the help.

 

@abm @DAsogan @v-micsh-msft 

1 REPLY 1
Super User
Super User

Hello @VGanji 

As far as I understand the Key column usage, then the column is supposed to contain unique values, so as to be able to identify a single row.

The column "status" in your Excel table does not contain unique values! The result is that only the first row that matches the Key value will be updated - at least it does in my test 🙂

Kind regards, John

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (37,861)