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?

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

Hi I am new in MS flow ,

May I know why I cant get the column list from "List rows present in tables"? 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,623)