You’re offline. This is a read only version of the page.
Hi,
For a model-driven app, I have an alternate key on a Dataverse entity comprised of 3 lookup columns, one of which is left null a majority of time. I still need to enforce uniqueness, which I've come to understand isn't supported for alternate keys.
My question is- has anyone out there found a workaround?
My only idea so far has been to default create a "Null" placeholder value in the problematic field. This is not ideal for my current environment but will use as a last resort.
don't make things complicated. As you already imagined, just create a lookup value called "NULL" and set the lookup to be required. (you can also set it as default value with some javascript so users don't need to select it manually if often the value should be this null)
EDIT: sorry, didn't notice the thread was old
An alternative approach is to create a string column on the table which contains a concatenation of all the other keys, including the nullable key, adding this to the keys, and making sure it is alway populated.
So you could have end with a concatenated "key" of "00000000-0000-0000-0000-00000000000011111111-1111-1111-1111-11111111111122222222-2222-2222-2222-222222222222" when the nullable column isn't null, and a key of 33333333-3333-3333-3333-33333333333344444444-4444-4444-444444444444 when it is null.
Hope this makes sense.
@KyleRichardson1, I see, the null value is not a value that can be tested against the Alternate Key. In this case your last resort is the only solution.
@AhmedSalih Thank you for the response.
Unfortunately, if there's a null value in any of the alternate key fields, it will not enforce uniqueness.
For instance, if columns A, B, and C below are my key fields, it will allow the duplicate entry with null values in C, even though it should be recognized as a duplicate with the exact combination.
Hello, @KyleRichardson1, Alternate keys must be unique. If you have your Alternate Key from three Columns: A, B & C, you can’t have two exact combinations.
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (