Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Identify duplicates in SharePoint list

(0) ShareShare
ReportReport
Posted on by 9

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!

  • takolota1 Profile Picture
    takolota1 4,777 on at
    Re: Identify duplicates in SharePoint list

    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

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Identify duplicates in SharePoint list

    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

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Identify duplicates in SharePoint list

    @lwarix 

     

    Please share your flow screens.

     

    Thanks

    Hardesh

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard