cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Issue with Update Row function (Update Excel table from Sharepoint List data)

Hello,

I have an Excel File that I want to get updated whenever an item is modified in a Sharepoint List.

 

I have followed exactly (and repeatedly) the steps described in this video: https://www.youtube.com/watch?v=ibqFGgkZ1Cs

But I cannot get the flow to work, as I keep getting an error saying that "NO ROW WAS FOUND WITH ID ...". Even though there IS a row with a matching ID on the Key Column I'm pointing the "Update Row" command to.

 

For the life of me, I cannot figure out where the issue lies... Please help!

 

issue.png

 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @pperrot1 ,

 

I have made a test on my side and don't the issue that you mentioned.

Could you please share a screenshot of the excel table?

The error message said that no row was found with the id 35, could you please make sure that you have a row in the excel table with the Project id column set to 35, or please create a row in your excel table with the Project id column set to 35 and then run the flow from the run history again.

Also please create a new excel table and run the flow to see if the issue still exists.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

7 REPLIES 7
Super User III
Super User III

Hi!
Can you share a screenshot of your flow design, showing details of how the action inputs for 'Update Row' are currently configured?
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@efialttes I tried 2 different approaches, with same outcome.

 

First, I tried exactly what the video instructed.

flow1.png

 

Then, I tried going directly with the Excel connection, and, since Update Row didn't work on this scenario as well, my latest try was Deleting the row and adding a a new one. On the "Delete row" command, it gives me the same error.. 

 

flow3.png

 

So there is obviously something about the matching of Sharepoint and Excel data that simply isn't working. But I'm sure all data is the same because I extracted the Excel file from that exact same Sharepoint list. So it's gotta be something I'm doing wrong on the flow coding.

Community Support
Community Support

Hi @pperrot1 ,

 

I have made a test on my side and don't the issue that you mentioned.

Could you please share a screenshot of the excel table?

The error message said that no row was found with the id 35, could you please make sure that you have a row in the excel table with the Project id column set to 35, or please create a row in your excel table with the Project id column set to 35 and then run the flow from the run history again.

Also please create a new excel table and run the flow to see if the issue still exists.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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!
Sometimes a hidden space makes the difference between finding (or not) a row
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Community Support
Community Support

Hi @pperrot1 ,

 

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

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

Frequent Visitor

Hi,

 

I think I have the same problem. I also get a "no row with id..."-error when I try to update a row in my table although the id is definitely there. I can even list all rows beforehand and the row with the ID is included. But when I want to update it I get the error.

 

Furthermore I noticed that only the ID of my first row is not found and that if I try to update a row then itself stays unchanged but the row above is updated.

 

Finally I found that this all is only the case if I disable/hide the header of my excel table. If the table has headers everything works fine. Without headers (i.e. visible headers, since the headers should still be there in the table definition) the first key is not found at all and to update a row one has to refer to the row below.

 

So do the people here, whose ids are not found, also have no headers and is it always the first row that can't be found. I think this is probably not expected behaviour that I just don't understand, but probably a bug.

 

any help is welcome

Philipp

 

 
Helper I
Helper I

Just coming here to say that I finally figured out why my flow was not working.

Since I had generated the original Excel file (the one I'd like the flow to update) from my Sharepoint list, the file was linked to the list. I actually had to break the link and that allowed the flow to actually update the file.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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!

Top Solution Authors
Top Kudoed Authors
Users online (6,450)