I am trying to update a cell in in an excel file but my flow keeps returning 404 error unable to find the the row with ID....
Here is the flow:
SubString FYI: substring(body('Get_file_metadata')?['Name'],0,11)
I have also tried just using the folder name as the Key Value, but still no luck.
It keeps falling over at 'Update a row', here is the output:
As you can see it's there in A:5...
Thanks in advance.
Hi @jkilby ,
Have you tried using Get a row action for similar tests?
Perhaps this is caused by extra spaces between characters.
Please do more tests.
Hey @v-bacao-msft, I have the same issue, the difference is that we're getting our value, an email address, from the 'Get user profile (v2)' step. We can confirm that we're getting the value because we can see it in the error message for the 'Delete a row' step.
UPDATE: We've even tried another Excel step 'List rows present in a table', and that queries the Excel table just fine.
What makes this a terrible bug is that is not consistent. Sometimes it works, and sometimes it doesn't. \
Is there a roadmap to fix this bug? I'm wondering since this was first reported last January, so it looks like Microsoft isn't planning on fixing it.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!