Unanswered

Convert text column to choice column

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ciaran3001 33 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (2)

Report

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.

Was this reply helpful? Yes No