Duplicate records are one of the most common data quality issues in Dynamics 365 Customer Engagement (CE). When multiple versions of the same lead, contact, or account exist, sales teams waste time searching for the correct record, customers may receive duplicate communications, and reporting becomes less reliable.

Fortunately, Dynamics 365 includes Duplicate Detection Rules to help prevent duplicate records before they impact your business. This tip of the month highlights how to configure duplicate detection, improve data quality, and maintain a cleaner, more reliable CRM.

Tip summary: Prevent duplicate records with Duplicate Detection Rules

Duplicate Detection Rules help identify potential duplicate leads, contacts, accounts, and other records based on criteria you define. Instead of allowing duplicate records to be created or imported, Dynamics 365 alerts users when a possible match is found so they can review the existing record before creating another one.

Microsoft provides default duplicate detection rules for accounts and contacts, providing organizations with a strong starting point for maintaining data quality. However, many businesses create additional custom rules that reflect their unique processes and matching criteria, such as comparing email addresses, phone numbers, or combinations of customer information.

By enabling duplicate detection and publishing rules that align with your business requirements, organizations can improve data accuracy, reduce redundant work, and provide a better experience for both users and customers.

Tip steps: How to configure Duplicate Detection Rules

1. Enable Duplicate Detection

Depending on your Dynamics 365 version and interface, navigate to:

Power Platform Admin Center > Environments > [Environment] > Settings > Data Management > Duplicate Detection Rules

In organizations still using classic administration screens, these settings may appear under:

Settings > Data Management

Enable duplicate detection for:

• Record creation
• Record updates
• Data imports
• Offline synchronization (where supported in your environment)

These settings determine when Dynamics 365 checks for duplicate records.

2. Create a Duplicate Detection Rule

Navigate to:

Settings > Data Management > Duplicate Detection Rules

Select New, then choose the record type you want to monitor, such as:

• Leads
• Contacts
• Accounts

Define the fields that should be compared. Common examples include:

• Email Address
• Company Name
• First and Last Name
• Phone Number

You can combine multiple fields to create more accurate matching criteria.

3. Publish the rule

After configuring your rule, click Publish to activate it.

Dynamics 365 only applies published rules during record creation, updates, and imports.

4. Run a Duplicate Detection Job

To identify existing duplicate records already in your system:

• Navigate to Duplicate Detection Jobs
• Create a new job
• Select the records you want to evaluate
• Review the results and merge or remove duplicates as appropriate

Running periodic Duplicate Detection Jobs helps keep your CRM clean over time.

5. Use Duplicate Detection during imports

Duplicate Detection can also be applied when importing records into Dynamics 365.

When enabled, Dynamics checks incoming data against your published rules and alerts users to potential duplicates before they are added to the system, helping prevent large-scale data quality issues.

Why this tip matters

A clean CRM is the foundation for effective sales, marketing, and customer service. Duplicate Detection Rules help ensure users work from accurate information, improving reporting, reducing duplicate outreach, and giving teams greater confidence in their customer data.

Whether you’re cleaning up an existing environment or looking to prevent duplicates as your organization grows, Rand Group’s Dynamics 365 experts can help you configure duplicate detection and implement data management best practices. Contact our team today to learn how we can help you get more value from Dynamics 365 Customer Engagement. And be sure to return next month for another CE Tip of the Month.