Hi,
How can I enforce unique in the table itself off of 2 columns?
Thanks
Todd
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.
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 but im in Dataverse not Sharepoint. I also need the uniqeness to be based on 2 columns in the table not 1
Hi @Tango
When you create a new column in table there is option to enforce unique value .
I hope this helps you !
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1