Unanswered

Identify duplicates in SharePoint list

(0) Share

Report

Posted on by lwarix

Hi, I am trying to create a flow that will loop through our list and flag the entries as possible duplicates based on 3 columns. I have tried this post with no luck.

https://powerusers.microsoft.com/t5/General-Power-Automate/Remove-Duplicates-from-a-Sharepoint-List/td-p/427277

Any additional in site would be welcomed.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@lwarix

Please share your flow screens.

Thanks

Hardesh

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi!

In this thread @Anonymous describes a simple, nice approach to identify and delete duplicates in a sharepoint list by analyzing the content of a single column and storing it inside an aux array. I am just wondering if you can adapt this approach to your requirements by storing inside the aux array a value obtained by concatenating your three column value, so it probably depends on the type of columns you need to analyze

https://powerusers.microsoft.com/t5/Building-Flows/Check-for-Duplicates-in-SharePoint-using-Flow/td-p/302168

Hope this helps

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

Like (0)

Report
Copy link

Link copied!

You could also try this template that helps find & remove duplicates based on multiple column inputs:

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

Was this reply helpful? Yes No