Answered

Check for Duplicates in SharePoint using Flow

Like (2) Share

Report

Posted on 14 Jun 2019 19:49:45 by Community Power Pla...

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!

All responses (8)

Answers (1)

takolota1 4,863 Super User 2025 Season 1 on 09 Jun 2023 at 01:16:52

Like (0)

Report

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 103 on 16 Mar 2023 at 20:30:05

Like (0)

Report

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 103 on 16 Mar 2023 at 20:22:45

Like (0)

Report

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 14 on 02 Dec 2022 at 11:04:53

Like (0)

Report

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 56 on 29 Dec 2020 at 15:41:03

Like (2)

Report

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 6 on 02 Nov 2020 at 03:24:02

Like (0)

Report

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 626 on 23 Oct 2020 at 14:39:09

Like (1)

Report

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 4,556 on 15 Jun 2019 at 04:32:34

Like (11)

Report

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:

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!