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

[pperrot1]

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!

[efialttes]

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

[pperrot1]

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

First, I tried exactly what the video instructed.

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

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.

[v-alzhan-msft · Accepted solution]

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.

[efialttes]

Hi!
Sometimes a hidden space makes the difference between finding (or not) a row
Hope this helps

[v-alzhan-msft]

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.

[schphi]

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

[pperrot1]

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.

[clemett1]

What method did you use to "break the link"?, a simple turning the flow off and then back on again?

[pperrot1]

@clemett1 
It's been a while, but I think I simply opened the Excel file, and in the "Existing Connections" section, turned off the existing connection to the list.

[clemett1]

I am having very similar issues where I would initially get that error but then I would alter the Filter array Value from my "ID" to "Identifier" and then the flow simply creates a new row for the updated information instead of replacing the row that is already there despite the Key Value within the Key Column being there. It's like my flow is back and forth between being able to update rows that are already there and being able to add new rows. At the moment within its current configuration it is bringing over information however if information is updated on an already created line item in sharepoint, it creates a new row within my excel location.