Notifications
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.
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
