News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Importing data to an O...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Importing data to an OptionSet field

(0) Share

Report

Report

Posted on by SBeal

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!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

SBeal 50 on at

Like (0)

Report

RE: Importing data to an OptionSet field

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,274 Super User 2025 Season 1

#2

Martin Dráb 231,947 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans