Power Automate Help with Updating a Sharepoint List from an Excel Table

(0) Share

Report

Posted on by GE-22021700-0

Hi Everyone,

I've built a flow that will look at document library, see if there's any new excel sheets and if there are it will upload that information to a sharepoint list. From my images you can see my current flow.

It works great in pulling info from the docs. It'll only update items that are new and not duplicate anthing that is already there. However, it does not delete entries that the new document doesn't have from the list. Also, if I open one of the excel docs in there and remove a few data columns and run, those entries will not be removed from the list.

I'm pretty new to power automate and have been working on this for days! If anyone could help me in building the last piece so that it deletes entries there are no longer in the new document, or removed from one in there, that it will be reflected in the list.

Honestly I'd be fine changing this so that it's based off of one Excel document, just as long as it always updates to reflect how that doc currently looks.

I will be a hero in work if I get this to work, and I desperately need this win. Any help would be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

chiaraalina 2,023 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @GE-22021700-0

Are you still working on this?

The missing piece is that your flow is only doing upsert behavior right now. It adds new rows and skips duplicates, but it never compares the current SharePoint list against the current Excel dataset to remove records that disappeared from Excel.

Make sure both the Excel table and the SharePoint list have a common unique identifier column. Then use the key to match rows between Excel and the list.

Use “List rows present in a table” (Excel Online) to retrieve all rows from the Current_Bugs table. Enable pagination, if the table has more than 256 rows to ensure all data is fetched.

Add “Get items” (SharePoint) to retrieve all existing items from the target SharePoint list.

Extract the unique ID from each Excel row. For example, use a “Select” action to build an array of all Unique ID values present in the Excel data (let’s call this array ExcelIDs).

Add an “Apply to each” loop over the SharePoint items. Inside, use a Condition to check if the current item’s ID is not in the ExcelIDs array. If true (meaning the SharePoint item’s ID is missing from the Excel table), use a “Delete item” action to remove that SharePoint item.

Let me know if you still working on this and if you have questions.

Was this reply helpful? Yes No
lbendlin 8,709 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The only way you can accomplish this is by using the Version History of the files, pulling the penultimate version and then comparing that to the current version. That involves the Graph API, HTTP calls, premium connectors etc. Might be a bit too much effort. It also breaks down if there were multiple changes since you last ran the flow.

Was this reply helpful? Yes No