Set up Duplicate Detection Rules for Dataverse Table | PL-200 Exam Prep

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).

Power Platform admin center

| & Environments @ Environments > Trial > Settings > Privacy + Security
2 Analytics v Learn more about Privacy + Security [
G3 Resources “a
Privacy preference Session Expiration
CTS Show privacy statement link for this organization © Set custom session timeout
On off
Dynami 365 apps & ©
Privacy statement URL Enter maximum session length
Portals ;
https://cantoso.com/privacy.micrasoft.com/en-us/privacystatement Mi
Help + support
US Help stp Default action te take when an‘eroroceurs Howlong before the session expires'do youwant’tw show's timeoutiwarriing?
& Data integration O Ask the user for permission to send an error report to Microsoft Minutes
@ Data (preview) CO Automatically send an error report to Microsoft without user interaction oS cf
Inactivity timeout
‘ © Never send an error report to Microsoft
© Data policies Set inactivity timeout
@ _) of
& Admin centers v Blocked Attachments

Block these file extensions

as;bat;cdx;cer;chm;class;cmd;com;con
pl;crtcsh:dll:exe;fxp;hlp;hta;htr;htwiida;idc;idqiinfiins;isp;itsjarjsijs
e;kshil ad;maf;mag;mam;mag;mar;mas;mat;mau;may;maw;mda;m
db;mde;mdt;mdw;mdz;msc;msh;msh1;msh1xml;msh2;msh2xml;mshx
mlmsi:msp;mst;ops;ped;pif:prf:prg; printer, pstreg:rem;scfscr'sct;shb;s
hs;shtm;shtml-soap;stm;:tmp;url,vb;vbe,vbs;vsmacros;vss;vst;vsw;ws;wsc
ywsfiwsh

ade;adp;app;asa;ashx;asmx;

After that, you will see this table in the dropdown list under the Duplicate Detection Rule Criteria section on the Duplicate Detection Rules console.

Ae led (ey Save and Close {ej (@Help ~

re Duplicate Detection Rule: New Duplicate Detection Rule
=F Information

Duplicate Detection Rule : ... 4 General
General
Administration Name * Status Reason * Unpublished v

Notes Description

Related

4 Common
Ei System Jobs

[4 Audit History

Duplicate Detection Rule Criteria

Base Record Type * Pet Matching Record Type * Pet

Case-sensitive O Exclude inactive matching O
records

Clear
Field Criteria No. of Characters
| Appointment date Same Date
| v Breed Exact Match

| Select

Current matchcode length: 110/450
Status: New

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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.