Dataverse Primary Key Column allowing duplicate values

[PRAVEENZNMD]

Hello Team,

While creating a dataverse table, there is a default  primary key column. However it seems like I can enter duplicate values in that primary column. Is this by design? 

Also how can I restrict duplicate entries in table. 

Thanks,

Praveen

[dpoggemann · Accepted solution]

Hi @PRAVEENZNMD ,

The primary key is actually the GUID of the records in the table, this is unique.  The Primary Name field is not unique and really can not be enforced to be unique out of the box.  You can setup duplicate detection rules so when someone enters a new record it will provide a warning (https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-cle...) but this can be overridden and the record can be added anyway.  

[AhmedSalih · Accepted solution]

Hello @PRAVEENZNMD , I had to do something similar like you use case before and I just made sure that the data in my Primary Name Column initially has no duplicates (if you have data already), and then create an Alternate Key for the table and select the Primary Name Column. This will make it a primary key and won't allow duplicates. 

NOTE: Employee Identification is my Primary Name Column for this table.

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a a 👍 & Accepting it as the Solution to help other members of the community find it more.