cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
subhash

Composite Primary Key in CDM

Submitted by Advocate I on ‎02-22-2017 10:41 AM

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

3 Comments (3 New)
Comments
Michael_H
Regular Visitor
‎07-04-2017 01:26 PM
I agrree! Would be nice to have this functionality!
JenVitug
Kudo Commander
Kudo Commander
‎10-25-2017 06:04 AM

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
Power Apps
‎08-20-2018 08:47 PM
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