You’re offline. This is a read only version of the page.
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
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.
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:
| Name | Created On | Choice Field |
Record A | 18/08/2022 12:32 | Option A |
| Record B | Option B | |
| Record C |
If I import the above table, Dataverse parses it into the below:
No need for processing after import.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
