Unanswered

Check for Duplicates in SharePoint using Flow

(2) Share

Report

Posted on 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!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Brad_Groux 4,556 on at

Like (11)

Report

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

Was this reply helpful? Yes No
dlprentice 628 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
PowerSap 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rkaneknight 58 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
DaveSIS 14 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Dhaval2002p 103 on at

Like (0)

Report

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

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No