You’re offline. This is a read only version of the page.
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 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?
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.
#1
stampcoin
17
#2
mmbr1606
13
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
