Skip to main content

Notifications

Community site session details

Community site session details

Session Id : roxwambX9pk8HYx4gX4u0i
Power Automate - Building Flows
Answered

Check for Duplicates in SharePoint using Flow

Like (2) ShareShare
ReportReport
Posted on 14 Jun 2019 19:49:45 by

Hi, is there a way to check for duplicate IDs and delete the one entry if it exists?

I tried something below but was unable to get it working - I was attempting to create a list.  Would concat or join even work or am I completly going this the wrong way?  Thank you!

 

0.PNG1.PNG2.PNG3.PNG

 

  • takolota1 Profile Picture
    4,859 Super User 2025 Season 1 on 09 Jun 2023 at 01:16:52
    Re: Check for Duplicates in SharePoint using Flow

    If you just want to find & mark duplicates, then you could load this template & remove the last delete step:

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/m-p/2191403#M1611

  • Dhaval2002p Profile Picture
    103 on 16 Mar 2023 at 20:30:05
    Re: Check for Duplicates in SharePoint using Flow

    @DaveSIS 

    Hello, Need workflow help.

    Task: Find a Duplicate item from List B and change the status column value to Duplicate item
    We receive work from List A to List B
    I work on List B. I created a Choice column called status- and I added choices of New item, Duplicate item, completed, and Under review.

    Sometimes we receive duplicate items in List B from List A, I would like to identify those duplicates every time when a new item is created in List B and I want to change the status to Duplicate item if the manufacturer’s part number is matching.

  • Dhaval2002p Profile Picture
    103 on 16 Mar 2023 at 20:22:45
    Re: Check for Duplicates in SharePoint using Flow

    @bran 

    Hello, Need workflow help.

    Task: Find a Duplicate item from List B and change the status column value to Duplicate item
    We receive work from List A to List B
    I work on List B. I created a Choice column called status- and I added choices of New item, Duplicate item, completed, and Under review.

    Sometimes we receive duplicate items in List B from List A, I would like to identify those duplicates every time when a new item is created in List B and I want to change the status to Duplicate item if the manufacturer’s part number is matching.

  • DaveSIS Profile Picture
    14 on 02 Dec 2022 at 11:04:53
    Re: Check for Duplicates in SharePoint using Flow

    Hi @Brad_Groux 

     

    This is great. I am looking to do something similar and wondered if you could help. I would like to identify duplicates in my list based on the email column, but I don't want the flow to delete them. Instead I would like to be presented with a view of the duplicates, either in SharePoint, Excel or any other way that is possible so that I can review the two records and manually choose which one I'd like to delete/keep.

     

    Is that possible?

  • rkaneknight Profile Picture
    56 on 29 Dec 2020 at 15:41:03
    Re: Check for Duplicates in SharePoint using Flow

    I think I figured it out.  I replaced Sort ID by Email in my list, because it was a user list, and I knew if there were 2 of the same email it would be a duplicate.  You can use whatever field that would show you it was a duplicate.

    Now when running, it creates a list of all the items the first time it sees them, "if No" add it to the array.  Then when it sees them again it's already got them in the list and it runs the "If Yes".  I hope that helps someone else.

  • PowerSap Profile Picture
    6 on 02 Nov 2020 at 03:24:02
    Re: Check for Duplicates in SharePoint using Flow

    @Brad_Groux @Anonymous how would the above 'Apply to each' configuration change to delete all rows in an excel sheet?

    Please suggest

  • dlprentice Profile Picture
    626 on 23 Oct 2020 at 14:39:09
    Re: Check for Duplicates in SharePoint using Flow

    Brad,

     

    Could you please explain why this works? I tried this, and it does indeed work, but honestly I can't understand why it works.

     

    Thanks!

  • Verified answer
    Brad_Groux Profile Picture
    4,556 on 15 Jun 2019 at 04:32:34
    Re: Check for Duplicates in SharePoint using Flow

    @Anonymous is on my team, and he and a teammate were able to accomplish checking for, and deleting duplicates in a list utilizing a Flow that looks like so: DeleteDuplicatesInSharePointList.png

    If you have an questions about further about how we accomplished this, pleaset let he or I know. Otherwise, marking this question as solved. 

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 14

#2
Churchy Profile Picture

Churchy 12

#3
rzaneti Profile Picture

rzaneti 8 Super User 2025 Season 1

Overall leaderboard