Update Sharepoint List from Excel Table

[Anonymous]

Hi,

I have a flow that is running with no errors, the problem i'm running into is when i update the excel the sharepoint list does not update with the changes.  Any help is appreciated

[michaelpaul]

Can you provide a bit more information about your Excel and SharePoint List, the condition you are using, and the run results? I am suspecting that your issue may be in the Filter Query of the "List Rows" action. Title eq 'Title' will filter out all rows that don't have the word "Title" in the title column. If you are looking to match the Title value in the excel to the title value in the List then remove the filter query from the List rows action. I am also making the assumption that Title will be a unique key column?

On a side note, is there a specific reason that you would need to use both a SharePoint list and an excel? I often prefer to use one or the other depending on the application. The quick edit function in SharePoint isn't ideal but its functional.  

[Brad_Groux · Accepted solution]

The problem is that the Excel connector(s) have many issues - mainly file lockout, and aren't recommended if at all possible. The Excel connectors have a huge number of Known Issues and Limitations.

The only way I've been able to regularly update a SharePoint List from an Excel spreadsheet is to first purge the list, then populate the list from the Excel table.

Here's a snapshot of my two Flows that run with nearly 100% reliability, I purge at midnight, and populate at 12:15AM: 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Thank you for the reply @Brad_Groux 

That flow could work, but as a follow up question, know that the ID field is being used as the unique identifier in the sharepoint list.  Have you seen a workaround for this or a way to uniquely identify the different list items?

[Brad_Groux]

You would use the Filter array functionality to accomplish this, and could create variables with compose based upon those filter arrays. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!