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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Convert text column to...
Power Apps
Answered

Convert text column to choice column

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello community,

 

i have built an PowerApp which was based on Sharepoint and now includes DataVerse as Backend. Now i have imported a large Excel file and I couldn't figure out how to convert the text column's to a choice field afterwards. Is there any way to do that or a workaround via PowerAutomate? Or maybe setting up the choice column in the PowerQuery when importin?

 

Any help or hint will be appreciated!

Regards

Engin 

I have the same question (0)
  • Verified answer
    ciaran3001 Profile Picture
    33 on at

    Congrats on your move from SharePoint to Dataverse! 

     

    The "import from excel" feature in model driven apps is powerful enough to parse text labels into option set labels, you simply need to ensure that the option set labels match the text within your excel file. 

    Here is an example, I have an option set with the values "Option A" and "Option B". 

     

    In my excel file, I have the following table set up:

    NameCreated OnChoice Field

    Record A

    18/08/2022 12:32Option A
    Record B Option B
    Record C  

     

    If I import the above table, Dataverse parses it into the below: 

    ciaran3001_0-1660826169609.png

     



     

    No need for processing after import.

     

     

     

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @Anonymous , as @ciaran3001 said you can use Import from Excel and I would like also to add that you can use the dataflows if you experienced any issue with the Import from Excel tool. Also, i usually create the Dataverse tables first then do the import and make sure your Choice column is setup and has the matching values of your excel file. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 893

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 482

Last 30 days Overall leaderboard