Enable and disable duplicate detection
This topic covers information on how to enable and disable duplicate detection in Dynamics 365 and Microsoft Dataverse.
Enable duplicate detection
Before running duplicate detection, enable it for each of the following:
Globally (for all tables in the organization).
For a table.
For specific operations.
Note
You must enable duplicate detection in all three above mentioned areas to detect duplicates for a table and for operations on a table.
Enable duplicate detection globally
- Use the UpdateRequest message to set the
Organization.IsDuplicateDetectionEnabled
column totrue
. - Read Turn duplicate detection rules on or off for the whole organization to find out how you can use the user interface to enable duplicate detection for the entire organization.
Enable duplicate detection for a table
- Use the UpdateRequest message to set the IsDuplicateDetectionEnabled property to
true
.
Enable duplicate detection for specific operations
Set the following columns to
true
:Organization.IsDuplicateDetectionEnabledForOnlineCreateUpdate
. Create and update records in Microsoft Dataverse by using the Web application or Dynamics 365 for Outlook. This column enables or disables duplicate detection for records created or updated with the CreateRequest and UpdateRequest messages. However, it does not affect records created or updated with the IOrganizationService.Create and IOrganizationService.Update methods.Organization.IsDuplicateDetectionEnabledForOfflineSync
. Synchronize offline records when Dynamics 365 for Outlook goes from offline to online.Organization.IsDuplicateDetectionEnabledForImport
. Import bulk data.
Note
You do not have to publish the duplicate detection rules to enable duplicate detection for these operations. However, you must publish the duplicate detection rules before you perform the operations.
Disable duplicate detection
Disable duplicate detection globally or for a table type by un-publishing the duplicate detection rules or by deleting the published rules.
Disable duplicate detection globally
To disable duplicate detection globally, use the UpdateRequest message to set the Organization.IsDuplicateDetectionEnabled
column to false
. This automatically un-publishes all duplicate detection rules for all table types in the organization.
Disable duplicate detection for a table
To disable duplicate detection for a table type, do one of the following:
Use the UpdateEntityRequest message to set the IsDuplicateDetectionEnabled property to
false
. This automatically un-publishes all duplicate detection rules for a table type. This removes duplicate detection support for the table type and you cannot create a new duplicate detection rule for this table type.Un-publish all duplicate detection rules for a table type by using the UnpublishDuplicateRuleRequest message.
Delete published duplicate detection rules
Delete all published rules in the system to disable duplicate detection globally, or delete published rules for specific table types by using the IOrganizationService.Delete method.
See Also
Duplicate detection
Run duplicate detection
Duplicate rule tables