Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Convert Local Option set to Global Option Set

Posted on by 2

Hi,

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

  • EKL Profile Picture
    EKL 2 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 2 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 2 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,872 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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans