Answered

Translate drop down column

(0) Share

Report

Posted on by Jakubek

Dear Community,

I successfully translated all labels and buttons on all the Screens in my app (thanks to this article) but don't know how to achieve the same for drop down column that I get from SharePoint list.

My Items formula for drop down list is:

Choices([@'lista-obecnosci'].'Tryb pracy')

where Tryb pracy is the name of the column on SharePoint list that holds only 2 items.

Any ideas? 🙂

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-wenjuan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jakubek ,

Please try this:

ClearCollect(ColTranslator,Choices([@'All users email'].Choices)); ClearCollect(BB,AddColumns(ColTranslator,"translatorcolumn",MicrosoftTranslator.Translate(Value,"FR")));

I will store the choices value into a collection, and then add a column to store value translated into French. So that you can display them wherever you want.
Remember to add connection to "Microsoft Translator" and replace my column name to yours.

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
Jakubek 10 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-wenjuan-msft ,
thanks for quick answer.

I'm using Toggle to switch between languages and when I trying to use your solution it's simply doesn't work. Maybe because Toggle is using "OnCheck" and "OnUncheck"? When I paste your formula (with renamed column name) to "OnSelect" nothing happen.

My OnCheck formula is
Set(varLanguage,"en-us")
and even if I add your formula it still doesn't work.

--
Best,
Jakub
Verified answer

v-wenjuan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jakubek ,

I set the toggle like this:

Now I can switch language when I check/uncheck the toggle.

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
Jakubek 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-wenjuan-msft,
unfortunately it doesn't work.