Answered

Depend dropdown items on chosen variable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm making an app kinda similar to a translator.

At the first screen you choose your language, let's call the variable languageuser. Now I want to make a dropdown, where you see minute, hours, days, in your chosen language. But even though there are not many entries needed in the connected google table, i can't get the items of the dropdown to depend on the chosen languageuser.

How do I have to make the table and what is the needed formula to connect those two?

Help would be really appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The date and times are not really by language by by region, the pointer below gives examples and overview.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times

Now Language Translation is done with the Language Translation Connector.

Jay

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Jay,
thanks for your answer but i guess i have to elaborate a bit on my idea.

I ask them "since when do you have this problem?"
And then they should have one dropdown to select the number e.g. 3 and another dropdown to select the time e.g. minutes, hours etc. -> 3 hours

But the hours should depend on languageuser, e.g. when they chose spanish it says minuto, hora etc.

Thanks in advance

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

Hi again,

I am still not sure if you have format or language as your end goal.

You can use the Translator Connector to get the text conversion in real time, but the language needs to be chose one way ot another.

https://docs.microsoft.com/en-us/connectors/microsofttranslator/

Again is easier to go through Ideas on teams but totally your chose.

Jay

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It might sound more complicated but i want to take the translations manually from this table.

So if languageuser is "german" then the column with the german words should appeare in the dropdown menu to be selected.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Yes, you needs can be achieved by MicrosoftTranslator connector. Please refer to the following steps.

1. Set App.OnStart as follows to create dropdown options.

ClearCollect(Col1,["Day","Minute","Hours"]);

2. I use Listbox to select language, set Items property:

["中文","English","日本語"]

3. Set ListBox.OnSelect as follows, translate the col1 into selected language.

ClearCollect(Col2,ForAll(Col1,MicrosoftTranslator.Translate(Value,MicrosoftTranslator.Detect(ListBox1.Selected.Value).Code)))

4. Set Dropdown.Items property to Col2

Hope this helps,

Sik

Was this reply helpful? Yes No