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 / Microsoft Dynamics CRM (Archived) / Import drop-down-list ...
Microsoft Dynamics CRM (Archived)

Import drop-down-list entries into Dynamics 365 online

(0) ShareShare
ReportReport
Posted on by Community Member

Hey guys,

i am having some trouble with importing data to Dynamics CRM 365 online.

In the contact-form i have a few fields with drop-down-lists.

Some of the drop-down-lists are system-standard (like address1_addresstypecode),

some of the drop-down-lists are customized (like a new salutation field).

The system-standard-drop-downs are importable via an excel-sheet, my new customized ones are sadly not. Did i miss something?

I created/used the new drop-downs like this: https://technet.microsoft.com/en-us/library/dn531201.aspx

Just in case, it's relevant: All other customized fields (for example text-fields or whatever) are importable... just the drop-downs are troubeling me.

Greetings,

Florian.

*This post is locked for comments

  • Suggested answer
    AndrewLy365lyf Profile Picture
    AndrewLy365lyf on at
    RE: Import drop-down-list entries into Dynamics 365 online

    Hi Florian.  You require a data map to map your values to your optionset value during import.  This blog posts indicates the steps required:  tnycrm.blogspot.com.au/.../how-to-create-data-map-using-download.html

  • Community Member Profile Picture
    Community Member on at
    RE: Import drop-down-list entries into Dynamics 365 online

    Thanks.

    Indeed was a failure in mapping my problem. This mapping-error was caused by the two salutation-fields (the default system-salutation-field and my new one). Both had (of course) different field-names but the same label. The Dynamics 365 import (with the Excel-sheet-import-template) seems to use the label-name for mapping and not the field-name (sigh!).

    So, i solved the problem by using a different label-name during the import-process and renaming it later to the proper label-name back.

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

Quick Links

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans