Notifications
Announcements
Can I disallow duplicate value for a Microsoft Dataverse table column?
For example, I have a single text column named "Project Name". If there have been already a record set "Project Name" with "Project1", then "Project1" will not be allowed to be the value of "Project Name" for another record.
Hi
Hope you are doing good.
You can simply write Duplicate Detection Rules to achieve the same.
1. Navigate to https://make.powerapps.com
2. click Gear Icon at the top right
3. Then Select Advance Settings
4. Then Select Settings --> Data Management --> Select Duplicate Detection Settings and enable the settings
5. Once Done Select Duplicate Detection Rules --> Click New and Select Primary Entity and Select the Fields and Save and Publish
Duplicate Detection Rule will only show the message but we can ignore and save the record.
If you want to completely block you need to write Plugins for the same.
@Rena_Yu
Hi Rampprakash, thanks for the idea. I tried this feature, the result will block saving duplicate records somehow.
See the screenshot above, the error icon will appear, just saying the saving disability without reason. but I think it is because of the duplicate rule.
Not sure whether this is a normal behavior because you said we should be able to save duplicate records?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 711 Most Valuable Professional
Michael E. Gernaey 319 Super User 2025 Season 2
Power Platform 1919 268
