web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... How to import and map ...

Customer experience | Sales, Customer Insights,...

Suggested answer

How to import and map option set values ?

(0) Share

Report

Report

Posted on by FrancoisT

188

We are importing data from a CRM 2013 to the 365 version. We are exporting the data from our SQL data, but it's not exporting the option set labels, only the IDs.

Is there any easy way to map the option sets values, or do we need to list all the IDs in both CRM and map them manually when we create the import ? Thanks in advance if you have any advice !

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: How to import and map option set values ?

OptionSet/Labels mapping are available in StringMap Entity.

Check this post: community.dynamics.com/.../retrieve-option-set-metadata-via-sql

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Rishabh Kanaskar 241

#2

Tom_Gioielli 164 Super User 2025 Season 2

#3

MVP-Daniyal Khaleel 153

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans