cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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

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
Highlighted
Dual Super User III
Dual Super User III

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

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!



Highlighted
Helper I
Helper I

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

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

Highlighted
Community Support
Community Support

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

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

Highlighted
Dual Super User III
Dual Super User III

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

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!



Highlighted
Community Support
Community Support

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

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.

Highlighted
Frequent Visitor

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

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

 

 
Highlighted
Helper I
Helper I

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

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
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,101)