Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

enforce unique off of 2 columns in Dataverse

(0) ShareShare
ReportReport
Posted on by 1,153

Hi,

 

How can I enforce unique in the table itself off of 2 columns?

 

Thanks

 

Todd

Categories:
  • Fubar Profile Picture
    7,896 Super User 2025 Season 1 on at
    Re: enforce unique off of 2 columns in Dataverse

    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.

  • Tango Profile Picture
    1,153 on at
    Re: enforce unique off of 2 columns in Dataverse

    @ShrutiDhiman Thanks. So much for low code

  • ShrutiDhiman Profile Picture
    39 on at
    Re: enforce unique off of 2 columns in Dataverse

    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.

  • Tango Profile Picture
    1,153 on at
    Re: enforce unique off of 2 columns in Dataverse

    @ShrutiDhiman Thanks but im in Dataverse not Sharepoint. I also need the uniqeness to be based on 2 columns in the table not 1

  • ShrutiDhiman Profile Picture
    39 on at
    Re: enforce unique off of 2 columns in Dataverse

    Hi @Tango 

    When you create a new column in table there is option to enforce unique value .e44335d2-e392-41cd-b163-1212d1334b75.png

    I hope this helps you !

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.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics