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 :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Prevent Duplicate Reco...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Prevent Duplicate Records in CRM Contact Details

(0) ShareShare
ReportReport
Posted on by CRM Dynamics 365 25

Hi, 

I am having issues on CRM contact details with duplicate records. So, would you please suggest me to prevent duplicate entries. 

I have the same question (0)
  • CRM Dynamics 365 Profile Picture
    CRM Dynamics 365 25 on at

    How to prevent duplicate entries in CRM Contact details?

  • Suggested answer
    Gilmeyer Profile Picture
    Gilmeyer Microsoft Employee on at

    Hi 

    This will fulfil your requirements, refer to https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean.

    Also https://docs.microsoft.com/en-us/power-platform/admin/detect-duplicate-data can help with existing duplicated records.

    Thanks for reaching out. 

  • Inogic Profile Picture
    Inogic 754 on at
    Hello, you can use native duplicate detection rules. Native duplicate detection in Microsoft Dynamics 365 works through rules and conditions, where a rule defines the base and matching entities, and conditions specify which fields are compared. It supports simple matching criteria like exact match, same first/last characters, and case sensitivity, but has limited flexibility for complex or fuzzy matching scenarios. These rules must be published to activate detection during record creation, updates, or data import. If you don’t have more complex data, this setup is best for your needs to prevent duplicates and keep your CRM data clean.
    If your requirements include fuzzy matching and preventing duplicate records, you can explore various third-party solutions that extend data deduplication capabilities by offering advanced matching criteria and the ability to prevent duplicates created through workflows or integrations.
     
    Thanks!
  • Inogic Profile Picture
    Inogic 754 on at
    Hello, you can use native duplicate detection rules. Native duplicate detection in Microsoft Dynamics 365 works through rules and conditions, where a rule defines the base and matching entities, and conditions specify which fields are compared. It supports simple matching criteria like exact match, same first/last characters, and case sensitivity, but has limited flexibility for complex or fuzzy matching scenarios. These rules must be published to activate detection during record creation, updates, or data import. If you don’t have more complex data, this setup is best for your needs to prevent duplicates and keep your CRM data clean.
    If your requirements include fuzzy matching and preventing duplicate records, you can explore various third-party solutions that extend data deduplication capabilities by offering advanced matching criteria and the ability to prevent duplicates created through workflows or integrations.
     
    Thanks!
  • Suggested answer
    ManoVerse Profile Picture
    ManoVerse 979 Super User 2026 Season 1 on at
    Duplicates usually come from Manual user entry without proper checks or  Data imports (Excel, CSV) or Integrations (Marketing tools, ERP, APIs) or Lead-to-Contact conversion issues or Weak and missing duplicate prevention rules , recommendation is to combine prevention + detection + cleanup, not rely on a single feature. you can do this in three different way or mixup as per your requirement
     
    1) Duplicate Detection Rules (Out‑of‑the‑box)
    Dynamics 365 provides Duplicate Detection Rules that warn users when they try to create a duplicate Contact , you can use the common matching fields under rule , like email address , FirstName + Last name  , phone number.  its check the duplicate during :
    • Record creation/update
    • Data Import
    • Bulk duplicate detections jobs 
    ✅ Pros
    • Native Microsoft feature (supported & secure)
    • Easy to configure (no code)
    • Works in real‑time for users
    • Prevents obvious duplicates early
     
    ❌ Cons
    • Users can ignore and save the duplicate
    • Does not block high‑volume API integrations
    • Limited fuzzy matching
    • Not reliable alone for large environments
    2.) Alternate Keys (Strongest Prevention @System‑level)
    Alternate Keys enforce data uniqueness at the database level (Dataverse) . e.g. Make Email Address a unique key on Contact 
    ✅ Pros
    • It does hard stop and duplicates cannot be saved
    • Works for:
      • UI
      • Imports
      • APIs
      • Integrations
     
    • Ideal for Email‑based Contact models
    • Zero user dependency
    ❌ Cons
    • Requires clean existing data
    • Not flexible ( like strict exact match only)
    • Errors can confuse end users as it add violation message. 
    • you can create one alternate key per uniqueness scenario means if you would like to detect duplicate based on different fields and scenario then it wont be ideal or recommended.  This is best for organizations that treat Email as a unique identifier
     
    3) Synchronous Plugin (If custom logic needed)
    This runs before save and can fully block duplicates contacts 
    ✅ Pros
    • Real‑time enforcement
    • Flexible business rules
    ❌ Cons
    • Requires development
    Hope this explanation will give you an idea to implement this accordingly.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 157

#2
ManoVerse Profile Picture

ManoVerse 153 Super User 2026 Season 1

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans