Excel Update a Row does not work

keepitsimple · ‎07-03-2020

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 · ‎07-06-2020

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

Did I answer your question? Please consider to Mark
my post as a solution! to guide others

Proud to be a Flownaut!

If you want you can follow me at www.christianabata.com

Quieres contenido en español? Síguenos en Power Automate LA

keepitsimple · ‎07-06-2020

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