cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

3 REPLIES 3
Super User III
Super User III

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (72,767)