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
hi @keepitsimple unfortunally PA don't allows read formules in excel, please try adding the ID manually.
Proud to be a Flownaut!
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
66 | |
23 | |
16 | |
16 | |
13 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |