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

Notifications

Announcements

No record found.

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

    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

    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

    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

    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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
#ManoVerse Profile Picture

#ManoVerse 101

#2
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 62 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans