Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Duplicate Detection Rule - Not working

(0) ShareShare
ReportReport
Posted on by 99

I have a duplicate detection rule on the primary column of a custom table that just detects exact match. We recently migrated the App and the data to a new environment and once I publish the rule it works but after a few hours the rule just stops working.

I can confirm it initially works as I cannot create a duplicate record as it prompts the record exists. After a while it will allow the creation of a duplicate record with no prompt. Disabling and re-enabling seems to fix it for a few hours.

I have tried the following:

  1. I have tried deleting and re-creating the rule.
  2. Re-creating it basing in on the first 20 characters (thats the character limit of this field)

Any help on this will be greatly appreciated.

  • Suggested answer
    Yuri ji Profile Picture
    on at
    RE: Duplicate Detection Rule - Not working

    Hi,

    The following situations may cause Duplicate Detection Rule to stop.

    1. Duplicate Detection Rules are not solution components, they are automatically unpublished whenever you publish a managed or unmanaged solution involving one of the entities referenced in the rule.

    How to stop duplicate detection rules unpublishing in Dynamics CRM / 365 | XRM

    2. System resources.

    (+) Duplicate Detection Rules have stopped working in Version 1612 - Microsoft Dynamics CRM Forum Community Forum

    As there is no specific error message, we can't give more help, but you can open a ticket to Microsoft support for further help:

    https://admin.powerplatform.microsoft.com/support

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 181 Super User 2025 Season 1

#2
Siv Sagar Profile Picture

Siv Sagar 149 Super User 2025 Season 1

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 124 Super User 2025 Season 1

Product updates

Dynamics 365 release plans