Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Clean Duplicates

Posted on by 35

Hi there!

What is the best way to clean lots of duplicate Contact/Lead entries in Dynamics 365?  
I can easily detect all the duplicate entries when exporting all leads/contacts into an (online) excel file. I created a temporary boolean field "isDuplicate" to flag all records that were duplicates.
However, when trying to import them back into dynamics i can not update the records as i throws me an error for wanting to import duplicates...

Is there any better way to clean/delete multiple duplicate records?

I also tried using OOTB function of dynamics to detect duplicates, however, this only allows to merge/delete records one at a time which would take for ever in our case.
(Moreover, the Interface for this funcitonality looks like it is from 1995...)

Best Regards
Matthias 

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Clean Duplicates

    If you enable the allow duplicates while importing then it will create duplicate records.

    As naveen said, you can use power automate to delete records.

    Which means, During import allow duplicates and after import complete you can run the power automate to delete the record.

    First try on existing record once it works then import and run the power automate.

    Instead delete you can try the Merge Request class as described in below link:
    https://sureshmaurya.me/2021/06/13/record-merging-and-merge-tracking-in-depth-in-microsoft-dynamics-365/

  • Crownd Profile Picture
    Crownd 35 on at
    RE: Clean Duplicates

    I'll attach the screenshot to this message. It is in German unfortunately, but it essentially says that the lead could not be imported/updated since there exists a duplicate.

    However, what would happen if I allow duplicates while importing, I would not want to create even more dups in my system?

    Best Regards

    Matthias

  • Naveen Ganeshe Profile Picture
    Naveen Ganeshe 3,393 User Group Leader on at
    RE: Clean Duplicates

    can you share the screenshot of the error while importing? I believe we can allow dups in the system while import

  • Crownd Profile Picture
    Crownd 35 on at
    RE: Clean Duplicates

    Hi Naveen!

    thanks for the fast reply and your input.

    This would seem like a nice way to go about it, but, unfortunately, we do not have a license for power automate.

    And i would assume a CRM the size of Dynamics should have some sort functonality do deal with multiple duplicate records

    Best Regards

    Matthias

  • Suggested answer
    Naveen Ganeshe Profile Picture
    Naveen Ganeshe 3,393 User Group Leader on at

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans