Select column from data set based on dropdown

[katunar]

Hi guys

I have a data set with different languages in it like shown in the table below. I also have a dropdown with all the languages I am using in my data set.

["German"; "English"]

I want to display the text in a label based on the langauge I selected in the dropdown - something like this:

First(Filter(_Translater; German = "Flasche")).[Dropdown1.Selected.Value]

Can anybody Help?

German	English
Flasche	Bottle
Tisch	Desk
Tastatur	Keyboard
Fenster	Window

[eka24 · Accepted solution]

If(Dropdown1.Selected.Value,
Filter(_Translater; German = Dropdown1.Selected.Value ||
Filter (_Translater; English = Dropdown2.Selected.Value )))