
Is it possible to have a unique constraint for a custom column in Dataverse for Teams?
Hi @HappyFace6,
In a full model driven application that is connected to the Dataverse you can setup duplicate detection rules that will notify you in a model-driven application if you are creating a duplicate record although the user can "ignore" this and still create the record so the Dataverse actually has no Unique Constraint type of capability specifically. https://docs.microsoft.com/en-us/power-platform/admin/detect-duplicate-records#:~:text=Microsoft%20Dataverse%20helps%20you%20address,child%20records%20are%20also%20merged.
Dataverse for Teams does not expose even this functionality so you would need to do something in code to try and accomplish this, nothing at the data layer exists.
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew