Showing results for 
Search instead for 
Did you mean: 
New Member

How to find items that exist in SharePoint List and not in Excel?

I'm working with a very large amount of data stored in an Excel sheet. Once a day a SharePoint list needs to be updated to reflect exactly what is on the Excel sheet. Because, of the large quantity of data, I'm trying to:

  • Update the items when the primary key exists in both the SharePoint list and the Excel sheet.
  • Delete the items with a primary key that exists on the SharePoint list but not in the Excel sheet.
  • Create items with a primary key that exists in the Excel sheet but do not exist in the SharePoint List.

I've managed to do the update portion by using filter as illustrated below:



However, I am stuck on when to delete and create items.

What would be the best way to accomplish this?


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,656)