cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markelliot
Regular Visitor

Automatically Update Excel-to-Sharepoint List

Hi,

I have a Sharepoint List that I populate using a Flow from Excel. Throughout the week we update the Excel sheet and update it by running a new Flow. Currently we have to delete all the old entries before running the updated Flow to avoid making duplicates. Is there a way to run a Flow that just updates entries in the list rather than duplicating them?

6 REPLIES 6
v-litu-msft
Community Support
Community Support

Hi @markelliot,

 

Is there an associated column between SharePoint list and Excel table?

If there is, you could use Get items action to return all items of SharePoint list, then add Apply to each action to loop them:

Screenshot 2021-01-26 150817.jpg

 

Screenshot 2021-01-26 150847.jpg

 

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

 

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

Hi, 

I'm going from Excel to Sharepoint, not Sharepoint to Excel, but either way this is what I'm already doing to make the initial Flow. The problem I'm trying to solve is:

- I populate my Excel Table with x number of entries

- I run my Flow to import it into Sharepoint (with columns that match the Excel Table)

- I update some of the data in my Excel Table

- I run my Flow again to import the updated data into Sharepoint

- My Sharepoint list now has 2x entries rather than just updating the original entries

Can you provide a screen shot of your flow so we can understand your query better?

markelliot
Regular Visitor

See below. The linked spreadsheet gets updated periodically, and I'd like to be able to run the flow and leave non-updated entries as is but overwrite the updated entries.

 

markelliot_0-1620928399410.png

 

markelliot_1-1620928433565.png

 

I have recently found a solution to your issue - it does the process for ADDING new items, UPDATING changed items and DELETING items from an Excel file to a SharePoint List. I do not claim ownership of this solution, but Jamie McAllister is wonderful in my opinion on explaining all the steps.

Here are the links to the YouTube videos that explains the process:

Part 1: (Overview showing working flow) https://youtu.be/YnuMFnVATuE

Part 2: (Walkthrough the created flow and talking about the process) https://youtu.be/aNoPNcXIg08

Part 3 (goes through creating the flow step-by-step): https://youtu.be/nlw5_qV8pIo 

 

I was going to include screenshots but that made the post too long

markelliot
Regular Visitor

Thanks for sharing, but I've actually watched this video series before and followed it step-by-step and in the end it didn't work and I couldn't tell why. Thanks though, maybe I'll give it a go again.

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

Users online (24,061)