No row was found with Id '1', however I am checking against "Data ID" and not "Id"

(0) Share

Report

Posted on by BenDonahue

932

(Please respond to the other, identical, posting here:

https://powerusers.microsoft.com/t5/Building-Flows/No-row-was-found-with-Id-1-however-I-am-checking-against-quot/m-p/646130#M86303.

I created this post, then realized that it is better posted in Building a Flow, so copied the data there. Now, I can't find a way to delete this post.)

I have a iterating primary ID being generated programmatically via variables and expressions, entering static integers into the column, Data ID, such that row 2: Data ID = 1, row 3, Data ID = 2, and so on (row 1 is headers).

Here is the set-up in Flow:

setup for no row was found with id 1.png

When I attempt an "Apply to each" identifying the Key Column as "Data ID" and the key value as the current value of "Data ID," I see in the run report that Data ID was the Key Column, the Key Value used in the first iteration was "1" then get the error message 404: No row was found with Id '1.'

error report no row was found with id a.png

To my inexperienced eye, it looks like:

I am asking flow to look for a row with "Data ID" to be equal to "1" then

Flow goes and tries to find a row where "Data ID" equals "1" and then, for some reason, says that

it can't find a row with "Id" equal to "1" which is a problem, for some reason.

How do I make Flow look for a row to update with "Data ID" equal to 1?

Yes, Data ID = 1 exists
Data ID 1 exists.png

What key concept am I missing on this? Or, is this yet another one of the many bugs in Flow?

Thank you in advance for your help; it is very appreciated.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Jcook 7,779 Most Valuable Professional on at

Like (2)

Report

Re: No row was found with Id '1', however I am checking against "Data ID" and not "Id"

Hello @BenDonahue

Excel does not like spaces in the column names.

Please remove the space in your excel column.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

Re: No row was found with Id '1', however I am checking against "Data ID" and not "Id"

Hi @BenDonahue ,

Does this problem still bother you? Have you tried the suggestions provided by @Jcook to improve your configuration?

Perhaps you can consider using the string() or int() function to format the key value into an integer or string and see if similar problems still exist.

I speculate whether it is because of the type of the field that caused this error.

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
BenDonahue 932 on at

Like (0)

Report

Re: No row was found with Id '1', however I am checking against "Data ID" and not "Id"

I doubted this was the issue, but, after changing all column names and all references to those columns, it works fine.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: No row was found with Id '1', however I am checking against "Data ID" and not "Id"

This is related to the issue "404 error unable to find the the row with ID", But not the exact scenario as mentioned by the Thread initiator.

If you have unchecked the Header Row check box under table design tab, this issue happens for 1st row.
As a workaround I enabled the header and kept the header text as same color as column name.

Was this reply helpful? Yes No