Problem with importing values for multiselect option sets

(3) Share

Report

Posted on by AZ-01081450-0

Hi!

I work on a project where we use multiselect fields for accounts and opportunities. Does anybody know if there is possibility to import records with multiselect fields from csv? When I try it, in import wizard multiselect field doesn't display in mapping on ms dynamics 365 side? Is it a standard import limitation or it's possible and how?

Categories:

Dynamics 365 Sales

I have the same question (0)

All responses (5)

Answers (5)

Verified answer

Tom_Gioielli 3,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

There was another posting here recently on this topic.

Dynamics 365 (CRM) Import - Multi-Select Option Set Field Fails

Long story short, I also was not able to find a way to import to the multi-select field using the built-in import method. There is a way to map it with Power Automate, so that could be an option for you.

Was this reply helpful? Yes No
Verified answer

AS-09111250-0 11 on at

Like (2)

Report
Copy link

Link copied!

Did you give try using XRM Toolbox, I believe it might work.
Using the standard Bulk Import option.

Was this reply helpful? Yes No
Verified answer

ManoVerse 884 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

while importing Multiselect Option set data you have to format the data in below format , means separated by " ; "

While import wizard you should have option to map like below :

It would importing the data successfully

hope this will help

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Tom_Gioielli 3,084 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Thanks #Manoverse.

Looks like what I had missed in my testing was there was a leading space before a second choice, which needs to be removed to import.

----------------------------------------------------------------

Does NOT Work

option 1: option 2; option 3

Works with Mapping

option 1;option 2;option 3

----------------------------------------------------------------

It's particularly confusing because the data is exported with the space in it, meaning you are unable to reimport a file without changing the column (even if you did not intend to make any changes to the choices).

Was this reply helpful? Yes No
Verified answer

AZ-01081450-0 44 on at

Like (2)

Report
Copy link

Link copied!

Adding a space worked, thank you guys!

Was this reply helpful? Yes No