Announcements
Hi,
How can I enforce unique in the table itself off of 2 columns?
Thanks
Todd
Hi @Tango
When you create a new column in table there is option to enforce unique value .
I hope this helps you !
@ShrutiDhiman Thanks but im in Dataverse not Sharepoint. I also need the uniqeness to be based on 2 columns in the table not 1
Yes @Tango
With the Dataverse you can setup "duplicate detection rules" but this will not stop the insert of the record, it will only provide a warning that you are creating a duplicate. You would need to implement a plugin that would execute on pre-validation (Synchronous) and return exception.
@ShrutiDhiman Thanks. So much for low code
Create an Alternate Key https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-reference-records
If you just want a 'soft' check (user can still save if duplicate, but warns them), then you could try Duplicate Detection rule if Model Drvien App.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional
