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
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
