web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Importing global choice label fields from an external excel spreadsheet

(0) ShareShare
ReportReport
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.

I have the same question (0)
  • TedB Profile Picture
    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
    12,119 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
    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
    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
    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
    12,119 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 174

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 121 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans