Choosing a specific column from a sharepoint list in a dropdown

[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

[BCBuizer · Accepted solution]

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)

[CSilva]

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. 

[BCBuizer]

Hi @CSilva ,

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

[CSilva]

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. 

[BCBuizer]

Hi @CSilva ,

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

Glad to hear it is working for you.