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

5 REPLIES 5
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.

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

 

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.

not understanding the solution !!!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,859)