Find & Remove Duplicates - Power Automate

Need to identify and/or remove records in a datasource based on duplicate values in one or more columns?

This template uses a SharePoint list to demonstrate, but this method ultimately pulls in the data from any source as a standard JSON array and processes it to identify all the duplicates based on the selected columns. From there the duplicates can be easily deleted.

Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team.

Venmo

PayPal

Buy Me a Coffee

Thanks for any feedback,

[simon]

I can't import your solution, what is your formula in the DuplicateCheckFields?

[tasneemmadihah]

Hi, would you mind to help, how can i get only the latest duplicate records?

Ex: i have 3 latest record, with recordID = 10, how I can i get this 3 records only? Not all listed duplicate.

Basically what I want is the latest data only from my list. But latest data may vary time to time

[napoleonmachine]

The link to the community thread download takes me to a page that does not display a download. It looks like Microsoft rolled out an update that may have killed the link to the download.