web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

List of duplicate records

(0) ShareShare
ReportReport
Posted on by 1,085

Hello Community Experts,

There is a requirement where i have to list all the duplicate records associated with lead separately

Kindly Guide,

Best Regards,

Sumaira Noor

I have the same question (0)
  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi Sumaira,

    In my opinion, first of all, it is impossible to list duplicates through a view.

    Because the view is composed of xml, views filter records by comparing fields values, xml cannot implement the logic of duplicate detection at all.

    In fact, the most suitable way is still through Deduplicator of XrmToolBox to detect and export to Excel.

    https://www.xrmtoolbox.com/plugins/DynCrmExp.Deduplicator/

    The only way I can think of that meets your requirements is to create an HTML page that calls the OOTB duplicate detection method to get the duplicates and display them in the HTML, then upload it to the web resource. Finally create an area on the sitemap to show the web resource.

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/detect-duplicate-data-for-developers

    But this only theoretical, we have to do a lot of development coding in reality. So if you don't have a development team, this requirement will be difficult for you to achieve.

    Maybe we could wait for good suggestions form other experts.

  • ba365guy Profile Picture
    2,950 on at

    Hi Sumaira Noor

    Do you mean duplicate records for one specific lead? 

    Like a view inside a lead form which shows potential duplicates for this particular lead?

  • Sumaira Noor Profile Picture
    1,085 on at

    Thanks for the information Lu.

    The HTML suggestion is good, but i have no coding experience

    Best Regards,

    Sumaira Noor

  • Sumaira Noor Profile Picture
    1,085 on at

    Thanks for the response ba365guy.

    I'm looking for listing all the duplicates in a single view or anywhere it is so that i can delete them easily.

    You said view inside a lead form which shows potential duplicates for this particular lead- Is it possible?

    Kindly Guide,

    Best Regards,

    Sumaira Noor

  • Verified answer
    ba365guy Profile Picture
    2,950 on at

    This should be helpful. Please have a look and let me know.

    community.dynamics.com/.../generate-excel-report-for-duplicate-records-in-dynamics-crm-for-bulk-merge

  • Verified answer
    ba365guy Profile Picture
    2,950 on at

    One more.... this is using OOB fetaure:

    www.marksgroup.net/.../

  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi Sumaira,

    So we can only search for the OOTB method.

    Anyway, D365 has the OOTB function of deleting duplicates, you can also see all the duplicates through it. (Not in the view, but in the system job)

    pastedimage1577094122413v1.png

    So without coding, it is impossible to see all duplicates in a separate interface like view.

    Or you can accept the way OOTB detects duplicates. Because as long as you set the duplicate detection rules accurately, you can correctly filter out the duplicates you want and then delete them.

    Please read the following blogs in order.

    1. Enabled Duplicate Detection - https://www.marksgroup.net/blog/dynamics-365-spring-cleaning/
    2. Set up the duplicate detection rules for the lead entity - https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-rules/
    3. Perform the duplicate detection job - https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-jobs-merging-records/
  • Sumaira Noor Profile Picture
    1,085 on at

    Thanks for the valuable response ba365guy.

    I need something which lists duplicates within CRM

    Kindly Guide,

    Best Regards,

    Sumaira Noor

  • Verified answer
    ba365guy Profile Picture
    2,950 on at

    The second one is within CRM. Using OOB

    Giving link again: www.marksgroup.net/.../

  • Suggested answer
    ashish12 Profile Picture
    3,079 on at

    You can use XRMTOOLBOX's plugin deduplicator.

    www.xrmtoolbox.com/.../

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 180 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 123

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans