Power Platform Community Forum Thread Details

Hi all, I have the following situation and I was hoping someone could suggest how to solve/build it.

Here is the story:

I have an app that servers a couple of HR offices, each one requiring different information to be entered, so I show/hide the field on the screen dynamically based on the selected country. For that, to work I have a formula on the visible property of the field that looks at the text of the label if present in an SPO configuration list where for every country, I define the field names which are the same as their Text property.

If(Self.Text in LookUp('Configuration list', Country=varCountry).Columns && varTabSelected=2 || Self.Text in LookUp('Configuration list', Country=varCountry2).Columns && varTabSelected=2,true,false)

So far so good, BUT now I also have to add a dynamic translation option so every country sees the field in his language, and this is where the problem is.

For the text property of every field. label, tooltip, etc. I'm using this formula:

LookUp(Translation, LanguageTag = varCurrentLanguage && Title = "RequireDeskPhoneTextID").LocalizedText

Here I'm telling that the text will change dynamically based on the current user's language (selected on the main screen), and then find in an SPO list the localized text for that language.

Because in the first case I show/hide the field if the text is located in a specific SPO list, and on the second condition I translated it based on the language, the visible function now is not working.

Any suggestions are welcome on how to keep both conditions (Show/hide the fields dynamically based on the configuration list, but at the same time to translated them dynamically using the second SPO list)

Categories:

Building Power Apps