cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ithinkmaybethis
New Member

Compare a SharePoint List and an Excel File

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.

PowerUsers1.pngPowerUsers2.png

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.

4 REPLIES 4
abm
Super User
Super User

Hi @ithinkmaybethis 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
ithinkmaybethis
New Member

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

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?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

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:

 

Ilona_Maz_0-1660049784547.png

 

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! 😊

 

 

Helpful resources

Announcements
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
Top Kudoed Authors
Users online (4,601)