Excel Update a Row does not work

[keepitsimple]

Hello,

I have created a Flow which needs to update a row in the Excel. However, the Update a Row action does not work and give an error the matching ID is not found. Screenshots below.

The error is as below:

However, the Id with the given value exists in the excel. In fact the value of Id is coming from the excel itself from a 'List rows in table' operation.

The excel column uses the formula ROW() to maintain the uniqueness of the value.

Is there a solution available for this?

If this a known issue with the 'Update a row' operation for Excel, is there any alternate available to update the data in excel?

Thanks

[ChristianAbata]

hi @keepitsimple  unfortunally PA don't allows read formules in excel, please try adding the ID manually.

[keepitsimple]

Hello @ChristianAbata ,

Many thanks for your response.

I too thought the same and tried by removing the formula as well. However, it still doesn't work.

I do not know what is going on here. I have another flow where this is working fine. But in this flow i have tried by doing it by different ways, but could not make it work 😭

I hope if someone can help me or point out to something which could be causing the issue.

Regards