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.
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!
Thanks! 👍
Hi, thanks for helping.
I entered the code as shown in the post.
Post your entire flow here.
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!
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.
@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
Hi @Anonymous It works great but how would you delete the oldest duplicate instead of the newest?
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
Churchy
6
Chriddle
4
Super User 2025 Season 1
stampcoin
4