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

Dataverse key confused

Hi, all :

Coulud I ask a question, if dataverse key created key already.

why still have keys in schema? (picture in circle color red)

【please see the picture in keys.png】

Thanks, have a nice day.

Judy

1 ACCEPTED SOLUTION

Accepted Solutions
GuidoPreite
Resolver III
Resolver III

in  your screenshot "Name" is not a key, is the primary name attribute.

However with "Keys" it means alternate keys, that you can create to identify a record beside the primary id.

I make an example with Contact.

Inside "Contact" you will have "contactid" that is the primary key (a Guid) and "fullname" that is the primary name attribute.

You can create a new column called for example "Contact Code" and set is as an alternate key, the field is unique (means that no duplicate "Contact Code" exists) and  you can retrieve the contact directly by this "Contact Code" 

View solution in original post

2 REPLIES 2
GuidoPreite
Resolver III
Resolver III

in  your screenshot "Name" is not a key, is the primary name attribute.

However with "Keys" it means alternate keys, that you can create to identify a record beside the primary id.

I make an example with Contact.

Inside "Contact" you will have "contactid" that is the primary key (a Guid) and "fullname" that is the primary name attribute.

You can create a new column called for example "Contact Code" and set is as an alternate key, the field is unique (means that no duplicate "Contact Code" exists) and  you can retrieve the contact directly by this "Contact Code" 

_Judy_
Frequent Visitor

Thank you, GuidoPreite.
Explained in great detail and easy to understand.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Users online (4,145)