In this post, I will show you how to detect duplicate records/ items in Dynamics 365 CRM/ CDS/ SharePoint, delete the record/ item and send a list of deleted records/ items as an email attachment. We will look at finding duplicate entries based on specific fields/ columns (specific values on these fields/ columns), deleting those and sending an email with the list of deleted records/ items.
Follow the article here: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Delete-duplicate-records-items-from-Dynamics-365-CRM-CDS/ba-p/334853
