Announcements
No record found.
How does it come that the records of our PickListMappingSet doesn't have a unique relation within single option sets between SourceValue and TargetValue for ~67% of the option sets?
*This post is locked for comments
I assume it is because of global option sets that share values.
I'm not sure if this is the reason but I don't think so.
As already mentioned, when querying this in Power Query: XRMServices/2011/OrganizationData.svc/PickListMappingSet?$select=ColumnMappingId,SourceValue,TargetValue I don't get unique relations.
Example:
On contact entity in default solution we have a global option set with two possible values 10.000.000 meaning A and 10.000.001 meaning B.
In PickListMappingSet I get two rows for this option set: 10.000.000 meaning C and 10.000.000 meaning D
=>Neither C nor D is existent in current default solution.
=> 10.000.001 is completely missing
Expanding the query further I recognize ColumnMappingId.Name (=Option Set Name, more specific: the display name of the field showing the Option Set SourceValue on the form) & ColumnMappingId.Id being the same and also PickListMapping_ColumnMapping.TargetEntityName being "contact".
It seems to me that C and D in PickListMappingSet came from a failed data import via data import wizard. However these values are not existent in customization area of the default solution.
So what's wrong?
It looks to me that querying "PickListMappingSet?$select=ColumnMappingId,SourceValue,TargetValue" is totally unappropriate to map existing OptionSet Values.
I believe there is a bug or missing product feature here:
ideas.dynamics.com/.../1686453
Looks like it describes what you experience.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
JS-09031509-0 3
AS-17030037-0 2
Mark Eckert 2
