cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bchan1
New Member

Excel table : No row was found with Id xx

I am trying to use "update a row" but error "No row was found with Id xx" is shown.

I then tried to obtain the row Id by using output from "list rows present in a table", I fed the Id of the output again into "get a row function" but no luck, still the same error "No row was found with Id xx". I am not sure is this a bug, entering "Key Value" for "get a row"/"update a row" resulting the same error.image.pngimage.png

bchan1_0-1616669220913.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Rilsina
Resolver II
Resolver II

Hi,

 

Please try with key value as P1, it should work.

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

bchan1
New Member

After awhile same thing failed again, I am frustrated.

bchan1_0-1616728542676.png

 

View solution in original post

4 REPLIES 4
Rilsina
Resolver II
Resolver II

Hi,

 

Please try with key value as P1, it should work.

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi Rilsina,

 

Thanks a lot! After your comment it is okay now, I have been trying the same things for a number of times but no luck before. It now worked magically!

And the exact same thing of my original post works now as well, not sure if a bug is fixed. Thanks anyway!

bchan1_0-1616724761528.png

 

 

 

bchan1
New Member

After awhile same thing failed again, I am frustrated.

bchan1_0-1616728542676.png

 

View solution in original post

Rilsina
Resolver II
Resolver II

Hi,

 

Key Value is the unique ID that 'update a row' action searches in your excel to update.

 

For my Use case: I added a column Sr.No in Excel and in flow created a new variable count, initialized it to 1. In Update a row, Key column was Sr.No and key value was variable count. After first update i used increment variable action to increment count. 

 

This helped the update a row to successfully run in loop. You can try if you have a similar use case.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,802)