Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1qf8yDyIU7M9aBmA1h1RPb
Power Automate - Building Flows
Answered

Delete duplicates in a SharePoint List

Like (0) ShareShare
ReportReport
Posted on 18 Jan 2021 07:23:59 by

Hello all,

I have got a SharePoint List with about 1400 items. It only should be arround 800 items and I found out that many items have duplicates. I don´t know why and that´s also not the point here.
My idea is to create a Flow which will get each row of the list and goes through all other rows and checks if *every* column is equal. If yes then delete this row.

I found this here in the forum:
Solved: Delete Duplicate in SharePoint List - Power Platform Community (microsoft.com)
But this is not exactly what I need I think.
I created this flow (unfortunately it is german) - only 3 conditions as an example. In reallity there are 8 columns.

 
 

Screenshot 2021-01-18 115100.jpg


I did not run it yet as I am pretty sure that this Flow will delete everything - or am I wrong?
How can I achieve that the flow deletes only duplicates but leaves one entry of each?

Thank you in advance!

  • AP23 Profile Picture
    7 on 16 Aug 2023 at 13:11:06
    Re: Delete duplicates in a SharePoint List

    Thanks! đź‘Ť

  • shravanreddy13 Profile Picture
    17 on 15 Aug 2023 at 02:40:51
    Re: Delete duplicates in a SharePoint List

    @AP23 Try Parsing your value after compose.

     

    FYI, https://powerusers.microsoft.com/t5/Building-Flows/Convert-array-to-parsed-strings/m-p/2275106#M252752

  • AP23 Profile Picture
    7 on 11 Aug 2023 at 07:51:08
    Re: Delete duplicates in a SharePoint List

    Hi, thanks for helping.

    I entered the code as shown in the post.

    AP23_0-1691739720862.pngAP23_1-1691739737647.pngAP23_2-1691739752131.png

     

     

  • Shravan Profile Picture
    128 on 11 Aug 2023 at 02:28:42
    Re: Delete duplicates in a SharePoint List

    Post your entire flow here. 

  • AP23 Profile Picture
    7 on 10 Aug 2023 at 13:27:01
    Re: Delete duplicates in a SharePoint List

    Hi, I tried to build the flow but now I am stuck at the very last point with "Delete item". Can you see whats's wrong here? Thank you!

    AP23_0-1691673957683.png

     

  • shravanreddy13 Profile Picture
    17 on 01 Aug 2023 at 01:50:12
    Re: Delete duplicates in a SharePoint List

    how do i use the odata filter to check if null as well?

    Title eq 'Title' and Title eq null  ??

    The above doesnt work.

     

    Any help is much appreciated.

     

     

  • takolota1 Profile Picture
    4,859 Super User 2025 Season 1 on 08 Jun 2023 at 22:37:47
    Re: Delete duplicates in a SharePoint List

    @diegothompson12 @der_cosmicyes @herreraguerrah @Dhaval2002p @Krono 

     

    Much cleaner, flexible, & more efficient way to remove all duplicates, while leaving one record here: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/m-p/2191403#M1611

  • diegothompson12 Profile Picture
    78 on 19 May 2023 at 15:20:52
    Re: Delete duplicates in a SharePoint List

    Hi @Anonymous It works great but how would you delete the oldest duplicate instead of the newest?

  • herreraguerrah Profile Picture
    2 on 11 May 2023 at 03:32:29
    Re: Delete duplicates in a SharePoint List

    In case anyone still need to do do this, here's a clean, clever and explained solution

     

    How to delete duplicate items in a SharePoint list with Power Automate (tomriha.com)

     

    Tested and worked like a charm

     

    Thanks to Tom, PA Guru

  • Dhaval2002p Profile Picture
    103 on 15 Mar 2023 at 21:05:56
    Re: Delete duplicates in a SharePoint List

    I tried this Workflow 

     

    https://tomriha.com/how-to-delete-duplicate-items-in-a-sharepoint-list-with-power-automate/#comment-20811

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard