Compare a SharePoint List and an Excel File

[ithinkmaybethis]

Here is what I want to do:

1. Compare an Excel file with a SharePoint List
2. Update the SharePoint List with differences to Excel file
   • Add new lines, where they didn't exist before
   • Delete lines, where they no longer exits
   • Modify fields in lines in SharePoint list, where the fields do not match
3. Provide an output (Email, Teams post, whatever) that provides the SharePoint ID, Title, and the old and new value for the updated item (for modified items) and maybe just the title and another field or two for deleted or added lines

I guess the output is very similar to using the "Alert me" feature in the SharePoint list, but I would just like a bit more control over what is included in the message, and where the message it output to (instead of email only). 

I was going to try and articulate exactly where I feel like I am getting stuck, but I don't feel like I can. I'm just not sure how to accomplish what I'm trying to do, or whether I'm even on the right path (or if it's even possible).

Anyway, this is what I was working on. I don't even know if I'm remotely on the right track.

I'm wondering whether I need to map every field in the "Condition" section? It will be tedious if I do, because there are ~30 fields to map... But if that's the solution, then that's the solution.

Any help would be greatly appreciated. I've been searching through previous posts for hours, and I still haven't been able to quite get it.

[abm]

Hi @ithinkmaybethis 

What's your identifier to check the SharePoint list from Excel? Is it the title which is unique?

Thanks

[ithinkmaybethis]

Hey @abm, yeah the Title will be unique, which maps to a field in Excel.

[abm]

Hi @ithinkmaybethis 

Thanks for your reply.

First discuss the below tasks

Update the SharePoint List with differences to Excel file

• Add new lines, where they didn't exist before

         Is this means you need to add the excel row in SharePoint?

• Delete lines, where they no longer exits

         Could you please explain?

• Modify fields in lines in SharePoint list, where the fields do not match

         If Title is matched can't you do an update for all the rows using Excel data?

[Anonymous]

Hello @abm ,

It is unfortunate that there is no reply to your message, because I have the very same question as the user above.

In a nutshell, I have an Excel file and make changes only on the excel file. When I modify the excel file, I have already a corresponding SharePoint list which is successfully updated when a row is changed or added in Excel.

However, I am lost about which flow I need to build for the following: Delete a row in excel and then also delete it in sharepoint list.

My flow so far is the following:

In the Update Item and Create Item section, I match all the SharePoint columns to the Excel columns.

I hope my problem is explained clearly enough. 

Thank you very much for any help! 😊