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

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,672)