Answered

Duplicates in a SharePoint Asset Management List

(0) Share

Report

Posted on by SP-24071929-0

I need to delete duplicate SharePoint records in a list made up of users' equipment (fields like "Service Tag", "Barcode", and "Approval ID" etc. I have been trying in vain to apply lessons I've seen here and elsewhere on how to effectively (1) identify the duplicates and (2) delete them, or at least update the records in some way I can then manually delete them. I have seen a lot of posts with ideas that should help, but I either delete all the records or none of them... Right now, the list is around 500-800 records, but it will likely grow exponentially in the next few weeks as it captures our 7,000 users' information.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

So let's say you have 3 entries that are all the same -- which one should be kept, which one should be deleted? Is it whichever was added first? Does it matter?

Are there any more columns in the row that need to be compared?
SP-24071929-0 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Rhiassuring

Yes, I am usually prone to delete all but the most recent one if there's a choice. This is the closest I've come to making something work (I added an Odata filter of a known set of duplicates in my list to test the flow -- that's the part underlined with Red) I know that specific record has a space in front of the first character, so I can fix that manually later...

Part 1Part 2
Verified answer

SP-24071929-0 43 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you, @Anonymous ! and to you too, @Rhiassuring

@Anonymous -- I found your article from 4 July of this year and followed your directions on the flow, and It inspired me to make some changes to my flow and it is working now:

I posted my flow here in case this helps someone else: