web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Import of .csv with Mu...
Customer experience | Sales, Customer Insights,...
Answered

Import of .csv with Multi-Select option set data created values in D365

(0) ShareShare
ReportReport
Posted on by William Bradley 175

I recently imported data from .csv to an environment. Two of the fields were multi-select, so I imported as is shown below in the following examples:


pastedimage1591895522207v1.png

I am noticing now that these fields have added values to the 2 Option Set in D365:

pastedimage1591895574010v2.png

pastedimage1591895613928v3.png

I do not need these values to show in the Option Set.  What is the fix for this?  I do not want to delete the values as obviously there is data that references them.  

Any assistance is helpful, thanks.  

I have the same question (0)
  • Verified answer
    Bipin D365 Profile Picture
    Bipin D365 28,983 Moderator on at
    RE: Import of .csv with Multi-Select option set data created values in D365

    Hi,

    The reason these values getting created in Multi select option field is when you import records and do the mapping of field, CRM will ask to you to either ignore optionset field values or create new whatever coming from source.

    Since you have not selected ignore option so by default system created this values.

    CQ8.PNG

    Now coming to your questions on how to resolve see issue. See below thread which will help you to fix your issue.

    community.dynamics.com/.../how-to-import-data-into-new-multi-select-option-set-field

    If found helpful, Please mark my answer verified.

  • William Bradley Profile Picture
    William Bradley 175 on at
    RE: Import of .csv with Multi-Select option set data created values in D365

    Thank you sir.  I was able to fix this data by taking the following steps:

    "Export to Excel" from All Contacts View as Dynamic Worksheet with only 2 columns (Service Line, Work Type)

    Remove " from all data in Worksheet (find and replace)

    Save Worksheet

    "Import  from Excel"

    Select File

    Ignore all other fields, Map 2 fields above

    MAKE SURE Service Lines and Work Types match from source to target

    Import

    Delete additional OS values in Prod

    Verify Data

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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 165

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 148 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans