Answered

Choosing a specific column from a sharepoint list in a dropdown

(0) Share

Report

Posted on by CSilva

I am currently making a dropdown list that is multilingual. I have a column with the options in English, a column with the options in Spanish, and a column with an item identifier.

I also have a Radio button that changes the language from English to Spanish. The issue that I am running into is if I put List.Spanish or List.English as the item for the dropdown (based on the language selected), I cannot collect the text from the item identifier column. I get an error saying I am collecting an error type instead of a data type.

Is there a way to format the dropdown so I can switch between columns, but still collect the appropriate item identifier based on what is selected? Thank you very much

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @CSilva ,

I managed to get something like what you described to work with a Combo Box:

For this I have set the DisplayFields property of the combobox to:

If( Radio2.Selected.Value = "English", ["English"], Radio2.Selected.Value = "Spanish", ["Spanish"] )

Because this didn't immediately update the text in the combo box when changing the selection in the Radio control I added a data source refresh to the OnChange property of the Radio control:

Refresh(Test)

Was this reply helpful? Yes No
CSilva on at

Like (0)

Report

For some reason, this solution only works for one column. When the radio button is on Spanish, it works, but when I switch to English, I get nothing but blanks for each item.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CSilva ,

Can you share what you are doing? Below is the set-up that is working for me:

Was this reply helpful? Yes No
CSilva on at

Like (1)

Report

Thank you for the help. The issue was that my "English" column was labeled field_0 in Powerapps for some reason. Now it is working.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CSilva ,

Perhaps your list was created using an Excel file as a template...

Glad to hear it is working for you.

Was this reply helpful? Yes No