Unanswered

Update a row: "No row was found with Id

(6) Share

Report

Posted on by jkilby

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.

All responses (55)

Answers (0)

Suggested answer

Bavenraj 12 on at

Like (2)

Report

Update a row: "No row was found with Id

When encountering the error "No row was found with Id '99'," it usually indicates that the data you're trying to read hasn't been inserted into Excel Online yet. This can occur due to a delay in data processing or synchronization.

To resolve this issue, you can add a delay of 1 to 2 minutes before attempting to read the data. This allows sufficient time for the data to be inserted and accessible. Delays in data insertion can be caused by various factors, such as network latency, service load, or the time it takes for connectors to sync data.

If the problem persists, consider checking the data flow and ensuring that all steps in the process are completing as expected. Also, verify that the data source and connections are correctly configured and functioning.
SulemanTT on at

Like (1)

Report

Re: Update a row: "No row was found with Id

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
good-java 3 on at

Like (1)

Report

Re: Update a row: "No row was found with Id

Thank you @BCNUTIN your solution helped me 😀
Cheers!
chay0k 12 on at

Like (2)

Report

Re: Update a row: "No row was found with Id

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.
tientranv 10 on at

Like (1)

Report

Re: Update a row: "No row was found with Id

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
JL-21080925-0 33 on at

Like (1)

Report

Re: Update a row: "No row was found with Id

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 10 on at

Like (2)

Report

Re: Update a row: "No row was found with Id

Thank @BCNUTIN for your solution, it worked
VincentBvS 6 on at

Like (1)

Report

Re: Update a row: "No row was found with Id

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.
MCNZylte 4 on at

Like (1)

Report

Re: Update a row: "No row was found with Id

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

Like (1)

Report

Re: Update a row: "No row was found with Id

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