Troubleshooting: Table Not Found in Dropdown List for Duplicate Detection Rules
Question
You need to set up duplicate detection rules for a Dataverse table.
But when you create a new rule, you cannot find your table in the dropdown list under the Duplicate Detection Rule Criteria section on the Duplicate Detection Rules console
What should you do?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: B
In the Dataverse, Duplicate detection is enabled by default for the Organization.
The Dataverse provides the three duplicate detection services: Duplicate detection jobs - creates scheduled jobs for duplicates detection.
Duplicate detection rules - defines duplicate detection rules for tables (entities) and columns (fields)
matching.
Duplicate detection settings - sets the default duplicate detection settings for an organization.
Before you create a duplicate detection rule, you need to enable the Duplicate detection settings for your table (entity).
/answer/imgckeditor_5.jpg)
After that, you will see this table in the dropdown list under the Duplicate Detection Rule Criteria section on the Duplicate Detection Rules console.
/answer/imgckeditor_5.2.jpg)
All other options are incorrect.
For more information about the Dataverse duplicate detection, please visit the below URLs:
To set up duplicate detection rules for a Dataverse table, you first need to ensure that the table has duplicate detection enabled. This can be done by going to the table's settings and selecting "Duplicate Detection" from the left-hand navigation menu.
If the table has duplicate detection enabled and you still cannot find it in the dropdown list under the Duplicate Detection Rule Criteria section on the Duplicate Detection Rules console, there are a few steps you can take:
Verify that you have the necessary permissions: To create and edit duplicate detection rules, you need to have either the System Administrator or System Customizer role. If you do not have one of these roles, you will need to switch to a user account that does.
Verify that the table is published: Duplicate detection rules can only be created for published tables. If the table is not published, you will need to publish it before you can create a duplicate detection rule for it.
Add the table to the Duplicate Detection Rule Criteria section: If the table is published and you have the necessary permissions, but it still does not appear in the dropdown list under the Duplicate Detection Rule Criteria section, you can manually add it by clicking the "Add Criteria" button and selecting the table from the list.
Enable duplicate detection for created and uploaded records: In some cases, you may need to enable duplicate detection for created and uploaded records before you can create a duplicate detection rule for the table. To do this, go to the table's settings, select "Duplicate Detection" from the left-hand navigation menu, and then select the "Enable duplicate detection for created and uploaded records" checkbox.
Based on these steps, the correct answer would be either B or D, depending on whether duplicate detection is already enabled for the table. If it is not enabled, the correct answer is B. If it is enabled, the correct answer is D.
