Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Convert Local Option s...
Sales forum
Suggested answer

Convert Local Option set to Global Option Set

Posted on by

Hi,

What is the best way to convert Local Option Set to Global Option Set?

  • EKL Profile Picture
    EKL on at
    RE: Convert Local Option set to Global Option Set

    Hi Wahaj,

    Thank you, let me give the details what Im trying to achieve.

    I want to convert local Option set field "PreferredMethodofcontact" to Global Option Set in both Lead and Contact tables. Attribute Manager from XRMtoolbox will not work as iPreferredMethodofcontact field is not an custom field, hence  created manually a new Global Optionset "Preferredmethodofcontact"  copying values from Optionset field.

    Now after manually creating global option set, I want to migrate data of local option set to newly created Global Option set, is there OOB way to achieve it ?

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Convert Local Option set to Global Option Set

    Hi,

    Try using the following plugin of the XRM Tool Box:

    https://www.xrmtoolbox.com/plugins/OptionSetEditor/

    Or, you have to manually add all the values (open both option sets and copy-paste labels, values one by one).

  • EKL Profile Picture
    EKL on at
    RE: Convert Local Option set to Global Option Set

    Thank you, but have a query ,how do I copy the existing data values from the existing option set to newly created global option set.

  • Suggested answer
    Adnan Jalees Profile Picture
    Adnan Jalees 455 User Group Leader on at
    RE: Convert Local Option set to Global Option Set

    Hi EKL,

    in this case you'd require to create the global optionset field manually. Also you can copy the system optionset field text + values and paste in your custom field text + values.

    please refer docs.microsoft.com/.../create-edit-global-option-sets

    let me know if you have any questions.

    Thanks

    Adnan

  • EKL Profile Picture
    EKL on at
    RE: Convert Local Option set to Global Option Set

    Hello Adnan, I need to convert Preferredmethodofcontact from contact/leads table and the field preferredmethodofcontact was not available since its not a custom field.

    What's the approach to be followed for non custom fields.

  • Suggested answer
    Adnan Jalees Profile Picture
    Adnan Jalees 455 User Group Leader on at
    RE: Convert Local Option set to Global Option Set

    Hi EKL,

    you can use XRM ToolBox (Home Â· XrmToolBox) plugin Attribute Manager to convert local option set to global option set.

    Just a note you can do it for custom field only as system doesn't allow System fields to be deleted. 

    pastedimage1613462423154v1.png

    Hopefully you will be able to map the business requirements as needed. 

    let me know if you have any questions. 

    Thanks,

    Adnan

  • LuHao Profile Picture
    LuHao 40,860 on at
    RE: Convert Local Option set to Global Option Set

    Hi partner,

    You can use this tool to convert a Local Option Set to a Global Option Set.

    https://github.com/daryllabar/DLaB.Xrm.XrmToolBoxTools

    For how to use it, please refer to this video.

    https://www.youtube.com/watch?v=NgyvtpBrY0Q&feature=emb_logo

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans