cancel
Showing results for 
Search instead for 
Did you mean: 

Composite Primary Key in CDM

It would be helpful to validate entries if multiple fields together act as primary key(Composite primary key) 

Status: Completed

Hi @subhash - while the primary key itself is always a GUID in CDS, you can define a multi part composite key - you can read more details here : https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-alternate-keys-portal

Comments
Michael_H
Regular Visitor
I agrree! Would be nice to have this functionality!
JenVitug
Kudo Commander

What would be the workaround if i want to find the record in an Entity which has LastName and FirstName as primary Keys ?  I need to be able to retrieve the record to be loaded to the form for editing.

 

multiple primary keys.JPG

CWesener
Power Apps
Status changed to: Completed

Hi @subhash - while the primary key itself is always a GUID in CDS, you can define a multi part composite key - you can read more details here : https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-alternate-keys-portal