cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saadssk94
Frequent Visitor

How to Enforce Unique Vales for a Column

Hello,

 

Trying to figure out how can i make a column accept only unique values just like in sharepoint.

 

can't seem to find an answer with search or youtube.

 

Any directions would be extremely helpful.

 

Thank you. 

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @Saadssk94 ,

 

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.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
Prakash4691
Super User
Super User

@Saadssk94 ,

Try creating alternate key. Make sure it gets succeeded while creating an index. You can check the status in system jobs. If it fails you can get a log. System job type is "Entitykey Index Creation".

 

If it answers your question, kindly give kudo and accept it as solution.

 

Regards,

Prakash

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,140)