cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Responsive Resident
Responsive Resident

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

(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-....

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hello @BenDonahue 

 

Excel does not like spaces in the column names.

 

Please remove the space in your excel column.





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

3 REPLIES 3
Super User III
Super User III

Hello @BenDonahue 

 

Excel does not like spaces in the column names.

 

Please remove the space in your excel column.





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (71,798)