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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Importing data to an OptionSet field

(0) ShareShare
ReportReport
Posted on by 50

Hi,

I am importing data to Dynamics on a daily basis.

Part of my dataset I want to import, I want to map to a field that is an OptionSet. The labels in the optionset are the same as the source data.
However, when I import this data it fails with a formatting error (i.e. the data is not in the correct format).

When testing a little, if I use the numeric value instead of the label, the data imports perfectly. This wouldn't be simple to add to my pre-import processing, but if necessary could be added.

Is there any other way to force dynamics to compare an import value with the optionset label rather than underlying value?

Thanks!

I have the same question (1)
  • Suggested answer
    SBeal Profile Picture
    50 on at

    I resolved this by importing a file which had all the various Options stored in it (with no blanks), selected the correct values on a modified datamap and then saved that. Previously Dynamics would not give the option to select options other than the first few before a blank.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

#3
ManoVerse Profile Picture

ManoVerse 51 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans