Translate Items in a List dropdown which is populated from another list

[Nimmers80]

I'm new to powerapps and I'm wondering if anyone can help?

I have a list which is in English, I use the form to populate and I want it to be displayed in multiple languages.

So far I have managed to translate all the labels using MicrosoftTranslator.Translate and they all work.

e.g. MicrosoftTranslator.Translate(Parent.DisplayName,lstChooserLanguage.selected.value)   where lstChooserLanguage is another dropdown with options "EN","ES","FR".

The challenge I have now is one of the list items is a Choice and I want to know if it is possible to translate the options in this choice list. I want the options in the form to be displayed in French but when the user clicks on Save it is saved in English.

thanks

[Rivius]

Aside from having many different choice lists, maybe you could display the choices to the user as a table/collection with the translated values and then when saving you could translate back to english and record the filtered/search/lookup choice.

[v-albai-msft · Accepted solution]

Hi @Nimmers80 ,

Since your dropdown is populated from another list, I assume that the Items property of your dropdown looks like this formula:

ListXXX.ColumnName

If my assumption is correct, I did a test on my side, you can refer to my steps:

1. Set OnStart property of your App to(I get value from Title column in list10, replace to your list name and column name):

ClearCollect(list10_2,AddColumns(list10,"TitleinFR",MicrosoftTranslator.Translate(Title,"FR")))

2. Set Items property of your dropdown to:

list10_2.TitleinFR

3. Set OnSelect property of your save button to(DataCardValue12 is the name of my dropdown control):

Patch(list10,Defaults(list10),{Title:MicrosoftTranslator.Translate(DataCardValue1.Text,"FR"),Choice1:{Value:MicrosoftTranslator.Translate(DataCardValue12.Selected.TitleinFR,"EN")}})

Above code will save records with "Title" in "FR" format and "Choice1" in "EN" format. 

Best regards,

Allen

[Laura3]

Thanks for this, any suggestions on how to do this with a combobox with multiple choices? (Sharepoint as a datasource). thanks

[IgnacioIOB]

Hi Laura3, I'm just wondering if you were able to do it and if so, how did you do it. I find myself in a very similar situation. Thank you!

[Laura3]

Hi @IgnacioIOB I was successful at doing so, but I did not use the Microsoft translation option. Instead manually translated everything using the switch function to read and write data from the database back and forth. It's quite a bit of work but it works fine. You need to use the switch formula on the default (or default items) and on the update property of the datacard so that the data is read well (display the previous selected choice) and updated correctly (patched correctly in English/original language back into the database).  Of course you also need to enter the translation in the items property of the combo/dropdown but that does not require a switch formula. 

I hope this helps

Laura

[IgnacioIOB]

Thank you for sharing! It's a bit of what I was doing.

I have an Excel file with the localizations and different languages, so I ended up bringing those as Items into the Options such as:

Items: [LookUp(Localization,LanguageTag = varCurrentLanguage && TextID = "Option1").LocalizedText,LookUp(Localization,LanguageTag = varCurrentLanguage && TextID = "Option2").LocalizedText] ...and so on.

Then stored that selection into an item, and if Option1 selected used the En language to store it.

Hopefully it helps someone.