Update a row: "No row was found with Id

[jkilby]

Hi 

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:

No row was found with Id '_SCC 200004'.
clientRequestId: af5eb03d-6285-4be8-82d0-0f69a7f14834
serviceRequestId: 5579c7c1-daa1-4dde-a477-354fc57eadd8;79c534e5-3ed3-4d03-a1ca-5714a8850a5f

Here is the excel file:

As you can see it's there in A:5...

Any ideas?

Thanks in advance.

[Anonymous]

I am actually trying to update a row which I created in a previous action in the same workflow and the Create a row works, but not Update a row with its own dynamic content. I have tried to change to text, covert to number, tried every kind of dynamic content related to the Column needed to find the row. Ugh! So frustrating. I have been pushing my company to adopt more Power Automate especially in the administrative area, but it will be hard if it takes Microsoft more than 3 years to fix an issue like this with no word.

[BraveITMan]

This was my solution when working from a new form submission. Thank you!

[datastraine]

I know this is old, but do you have any solutions for dates? I'm running into this exact problem right now

[openspaceranger]

The solution is to use something else to store your data like Sharepoint Lists, another Office 365 data store, or a database.

[datastraine]

If those were an option I wouldn't be asking, also it didn't reply in-line so my question was for @AWorley 

[AWorley]

please pm me with more info.

[BCNUTIN]

If this is an error due to data range not set correctly. Check this 

[MCNZylte]

Thanks @mabraham : That was the solution for me: Change table from $A:$N to $A1:$N500 (limited rows) and everything worked nicely!

[VincentBvS]

Experienced completely out of the blue (no changes were made and nothing was touched) the same after it worked for about 3 years flawless.

Had a flow to run when a task is placed in a certain bucket and the task was marked as completed.

What helped me (finally) was to force the Key Value to be an integer: 

int(outputs('Get_task_details')?['body/description'])

The 'description' of the task holds the ID value of the Excel ID column and consists of only numbers generated when a MS Form was filled out.

[tientranv]

Thank @BCNUTIN  for your solution, it worked 

[Janice_Lee]

Hello all,

I also faced this problem.

But!!!! After I re-sized my table and it works!!

At the beginning, my table range was $A"$:AC, and the error message showed "cannot find the row with ID 'xx'.

After I re-sized my tabel range to A##:AC##, then it works!!

You can try.

Janice

[tientranv]

It is not about the size of the table, it is about the identity column of a Table. Power Automate make the first column of a table the identity column by default. When you know it, the problem is solved

[chay0k]

I had such problem:
it can appeare because of unlimited rows in Excel table.

Seems, like power automate can't search data in such tables.

When I add down bounder:
Resize table from like($A:$B) value to like ($A$1:$B$4) - it starts work.

I hope these solutions work for you. 

[good-java]

Thank you @BCNUTIN your solution helped me 😀

Cheers!

[SulemanTT]

Hi All,

I ran into the same issue and saw it being a problem intermittently and I think I've found the solution! The data.

Please check if the data contains additional spaces. It seems that a filter query like ColumnName eq 'Yes' will bring back all the items containing 'Yes' even if the field is 'Yes ' with a space at the end. This runs into an issue on the delete because if you're deleting the row where ColumnName is 'Yes' and it's really 'Yes ' it fails to match and therefore fails.

Solution?

Maybe see if you can implement some stricter rules on the excel sheet to prevent people typing things incorrectly.

Regards,

Suleman