Unanswered

Automatically Update Excel-to-Sharepoint List

(0) Share

Report

Posted on by markelliot

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?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

v-litu-msft on at

Like (0)

Report

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:

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.

Was this reply helpful? Yes No
markelliot 10 on at

Like (0)

Report

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 x entries

Was this reply helpful? Yes No
JamesTechAssist 14 on at

Like (0)

Report

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

Was this reply helpful? Yes No
markelliot 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JamesTechAssist 14 on at

Like (1)

Report

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

Was this reply helpful? Yes No
markelliot 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
tony_sky 7 on at

Like (0)

Report

Hi I am new in MS flow ,
May I know why I cant get the column list from "List rows present in tables"?

Was this reply helpful? Yes No