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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Setup duplicate detection rule

(0) ShareShare
ReportReport
Posted on by 26

The duplicate checking for "name" of an Account isn't working properly. We have an account called "The Mall Plaza" already existing. A user created "The Mall Plaza, Inc" a few days ago, and it did not pop up to alert for a possible duplicate. I also created "The Mall" and I was able to create it.  How can I get the duplicate detection rule to pop up the message that it found a possible duplicate for this issue?

I have the same question (0)
  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at
    RE: Setup duplicate detection rule

    Hi,

    Thank you for your query.

    By default, the criteria to match Account names is "Exact Match".

    This means, when you try to create an account with the exact name "The Mall Plaza", the duplicate detection rule will invoke and notify a user about it.

    However, you can change this behavior:

    • Go to Advanced Settings -> Data Management -> Duplicate Detecition -> Duplicate Detection Rules.
    • Open Account with the same Account Name rule.
    • Unpublish the rule and in the rules section, change the criteria as per your need (Same First Characters or Same Last Characters):

    pastedimage1626721156835v1.png

    • Save and Publish the rule (please note, publishing rule might take some time).

    Here is an example configuration:

    pastedimage1626721326653v2.png

    Please note, in my opinion, do not rely only on names (it is very hard to catch duplicates on names as there could be errors in spelling).

    I recommend to set up rules also based on Business Phone or Email, this will be the second layer of validation.

    You may add another line to the same rule, or you can create a new rule altogether.

  • USA80 Profile Picture
    26 on at
    RE: Setup duplicate detection rule

    That didn't work.  I did what you mentioned.  However, I created a record with the same exact name as another record out there, but just added a 1 at the end and it let me save it.

    pastedimage1626804253574v1.png

  • Verified answer
    Wahaj Rashid Profile Picture
    11,321 on at
    RE: Setup duplicate detection rule

    Hi,

    As per your screenshot, this rule is still in the Publishing state.

    pastedimage1626806202226v2.png

    It might take a while to make it Published.

    Once it is Published, it should work as expected.

  • AriaConsulting Profile Picture
    2 on at
    RE: Setup duplicate detection rule

    Dupe rules are notorious for taking quite a while to be published.  Especially if you have a pretty good size DB for them to chew through.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 61 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 52 Most Valuable Professional

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 52 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans