Depend dropdown items on chosen variable

[Anonymous]

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!

[JayMagness]

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

[Anonymous]

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

[JayMagness]

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

[Anonymous]

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.

[v-siky-msft · Accepted solution]

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