web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Is it possible to upda...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Is it possible to update an option set value from an import?

(0) Share

Report

Report

Posted on by Summers

52

I wanted to confirm if you can update an option set value from an import? I have a client who is claiming on a managed solution, after they did an import with a spreadsheet with wrong values for an option set column, they changed one of the values of the option set to the wrong value (a value that didn't exist in the option set).

I'm under the impression the only way you can change an option set value in a managed solution is through Settings > Customizations > Customize the System as an Administrator.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Robert Bailey 20 on at

Like (1)

Report

RE: Is it possible to update an option set value from an import?

Hi Angel,

Is the client suggesting that the actual value of the option set within the managed solution was changed? Meaning that now if you go to use that option set on a new record, the option set value is different from before?

No, this is not possible when importing records via an excel file. They must be missing a piece of the puzzle.

Perhaps the meaning is simply that the records now have invalid option set values in the data, which could be possible. Can you confirm?

thanks

Was this reply helpful? Yes No
Summers 52 on at

Like (1)

Report

RE: Is it possible to update an option set value from an import?

Hi Robert, thanks for the careful consideration!

We met with the client and actually went through with them the option set values, and they said one of the option set values was incorrect. We suspect though that this is how the system was delivered to them, because as you said it's impossible to update an option set value merely from an Excel import. We believe that the client thinks that because they are confusing how fields that have simple text values can be updated from an Excel import.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 78 Super User 2025 Season 2

#2

Martin Dráb 57 Most Valuable Professional

#3

Anthony Blake 43 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

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