cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Update Sharepoint List from Excel Table

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

 
 
 

start.png

 

List rows.png

 

apply to each_LI.jpg

 

conditions_LI.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Brad_Groux
Super User II
Super User II

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: 

PurgeList.PNG

 

PopulateList.PNG

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!

View solution in original post

4 REPLIES 4
michaelpaul
Frequent Visitor

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
Super User II
Super User II

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: 

PurgeList.PNG

 

PopulateList.PNG

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!

View solution in original post

Anonymous
Not applicable

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?

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!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (78,378)