Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Importing global choic...
Sales forum
Answered

Importing global choice label fields from an external excel spreadsheet

Posted on by 15

While the process of importing data into a table seems to be a straight forward process, how do you import data into a global choice's label fields?

I'm referring to Global Choice Columns, not a Choice Field in a Table that may be linked to a Global Choice Column.

Global choice columns were formerly referred to as option sets and are sometimes called picklists. They enable you to include dropdown lists of fixed values to a user within your app to ensure data consistency. Accordingly in Power Apps, (Global) Choices are handled distinctly from Tables, although of course Fields that are configured as Data Type Choice Fields can be linked to a global choice column.

An easy way would be to download a data import template for the environment that would relate to global choices, but their doesn't seem to be a template for a custom global choice column.

Categories:
  • TedB Profile Picture
    TedB 15 on at
    RE: Importing global choice label fields from an external excel spreadsheet

    I haven't tested this out yet, but it appears to provide a solution to this challenge. I also was unfamiliar with the XRM Toolbox which is a great find.

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: Importing global choice label fields from an external excel spreadsheet

    Hi TedB,

    In the XRM Toolbox, there is a utility 'CreateOptionSetsFromCSV' to facilitate similar problems. For more details: linnzawwin.blogspot.com/.../create-optionset-from-csv.html

    pastedimage1677645762791v1.png

  • TedB Profile Picture
    TedB 15 on at
    RE: Importing global choice label fields from an external excel spreadsheet

    Hi Abdul - I don't think I was clear enough in the original writeup to my question, so I edited it above. I'm talking about Global Choice Columns that are shared across an environment, not the Choice Columns in a Table (although those Choice Columns my be linked to a Global Choice Column of course.) Thanks however for giving it a try. TedB

  • TedB Profile Picture
    TedB 15 on at
    RE: Importing global choice label fields from an external excel spreadsheet

    Hi Haig - I think you are talking about choice columns, not global choice columns which used to be called option sets. I guess I wasn't clear enough in my original question, so I've edited and added to it above. But I appreciate you reaching out.

    TedB

  • Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Importing global choice label fields from an external excel spreadsheet

    Hi TedB,

    You can import multi-select field values and choice columns to existing records, but you can’t import them for new records.
    The workaround is to import your new records without the multi-select/choice values, and then do a second import to add the multi-select/choice values.

    https://www.encorebusiness.com/blog/multi-select-option-sets-d365-crm/

       

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: Importing global choice label fields from an external excel spreadsheet

    Hi TedB,

    How about handling it using Power Automate? For more details: https://www.youtube.com/watch?v=rJaKEK3tJdU&ab_channel=MicrosoftPowerPlatform. A long time ago I was able to import new options in the choice column while creating dummy records into the table but right now I am wondering about the feature still exists or not.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

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,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans