Home » Dynamics » Import data with multi-select option set values in Dynamics 365 v9

Import data with multi-select option set values in Dynamics 365 v9

Text Widget

This is a text widget. The Text Widget allows you to add text or HTML to your sidebar. You can use a text widget to display text, links, images, HTML, or a combination of these. Edit them in the Widget section of the Customizer.

Introduction:

Prior to Dynamics 365 v9, there was no provision to use multi-select option set field. The latest release now allows users to use the multi-select option set field.

In this blog, we will see how data import works for multi-select option set field.

Importing data with multi-select Option Set field in Dynamics 365 v9:

Below are the account records that we tried to import in Dynamics 365 v9 environment.

Importing data with multi-select Option Set field in Dynamics 365 v9

Note: Services is the multi-select option set field of Account entity. This field has following options Home and Financial.

On the completion of the import, we got the below warning message, and on submitting these three records, only the first record was created in CRM because it is the only record which has the correct values in the right format.

 Importing data with multi-select Option Set field in Dynamics 365 v9 error

Importing data with multi-select Option Set field in Dynamics 365 v9

To import the records with the multi-select option set field value, we would need to pass the option set labels and should be separated by semicolon “;”.

  • The first record was created as two option set values, i.e., Home and Financial had passed by using “;” as the separator.
  • The second record failed because ‘Financal’ is misspelled and is not the right value of Services option set.
  • The third record failed because we used “,” as the separator.

Conclusion:

To import records with multi-select option set field, we would need to pass the option set labels with semicolon “;” as the separator.

Copy System and Custom Entities in Dynamics CRM

from Microsoft Dynamics 365(CRM) Tips and Tricks http://bit.ly/2yzsI59
via IFTTT


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: