Showing results for 
Search instead for 
Did you mean: 
New Member

How relationship work in CDS for custom entities using alternate keys

How relation of standard entity like product in CRM will work in CDS.

Becuase the primary key in CRM is a Guid field and we are passing ItemId from AX which is a String feild and that works perfectly..


But when i create same relation and passing value from AX . An Error is occured of type mismatch.

How i can assign the alternate key for that perticular relation.


Can you please help ? 

Community Support
Community Support

Hi @Integartion ,


I didn't see any error shown in your screenshot, can you please share more related details about the error and the configuration?




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi ,


Below are some details of the issue : 


1. In D365 FO we are passing ContributionId which is a string feild but in CRM it requires Guid feild for lookup. You can refer the attached error screen shot with highlighted value.

2. We need to implement this same as Product Id which we are sending as a string from FO side and they are converting it as a Guid and inserting the records in CRM.


Note : How we can implement the reference relationship in CDS where FO will send string and CRM will take that reference in Mastertable and pick primary key of it which is a Guid feild in CRM ?


Hope you understand my issue , if not then please share your email id , i can show you the issue.


my official id  :

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,796)