Excel updates the first row only but not the next row

[VGanji]

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.

Please let me know if any details are needed.

Thanks for the help.

@abm @DAsogan @v-micsh-msft 

[JohnAageAnderse]

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