Announcements
Hi,
Is there a way to prevent duplicate data being entered on dataverse? Pls guide.
@Teresa24486
You can use duplicate detection rules:
https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
Hi @Teresa24486 ,
You can create Alternate key in your table to prevent duplicate records being created in dataverse.
https://docs.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity
Thanks,
Bipin
Hi @Mira_Ghaly
I already have it set up but does not detect duplicate values.
HI Bipin,
Can you give me more details please?
Are you trying to prevent duplicate records for out of the box entity or Custom Entity?
What is criteria for duplicate detection, for example if record with same email address already exist prevent creating/updating new record in crm system?
You can create keys for single column and also combining the Multiple columns.
Login to make.powerapps.com - select Environment- Selected Data - Table - secelct your table and select Keys tab . now add your new keys then publish your change.
For OOB duplicate detection mentioned by Mira, you will have to create duplicate detection rules and publish them.
Hi @Mira_Ghaly ,
I separately configured a new run and it worked. Thanks for your help.
In my experience the duplicate detection rules only warn the user of a potential duplicate. The user can choose to create the duplicate.
It appears that there is NO WAY to PREVENT duplicates OOB.
Hoping somebody can tell me otherwise.
@urklnme
For duplicate prevention it would be so either the key as by mentioned by @bipinshan or you can write a plugin to do the duplicate prevention mechanism and throw an exception which will prevent the user from proceedings.
hi @urklnme ,
Please check this link:
https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean to prevent duplicate entry into the dataverse table.
I found this article which was quite helpful for me when I had to deal with this same issue:
Dataverse: Duplicate Detection Rules vs Keys – Temmy Wahyu Raharjo (wordpress.com)
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
