Power Platform Community Forum Thread Details

For may App I'm running a language check in the OnStart property. It's checked if the user has saved a language, if not use the local language, if this is not supported use englisch. For Testing I just hardcoded gblLanguages as ["EN,"DE"] but if I take this values from a column I'm getting an type error when checking gblLanguage in gblLanguages. Using the code like this works:

Set(gblLanguages, ["DE","EN"]);

Set(
 gblLanguage,
 If(
 IsBlank(gblDBUser.language_setting),
 Upper(
 Left(
 Language(),
 2
 )
 ),
 gblDBUser.language_setting
 )
);

If(
 !(gblLanguage in gblLanguages),
 Set(
 gblLanguage,
 "EN"
 )
);

Using as single column virtual view instead doesn't work.

Set(gblLanguages, vw_languages);
//Also tried:
Set(gblLanguages, vw_languages.language);
Set(gblLanguages, ShowColumns(vw_languages, "language"));
ClearCollect(colLanguage, vw_Languages);
ClearCollect(colLanguage, vw_Languages.language);

Even when I'm explicit telling the column to check in. This error cascades down in my code to point where gblLanguage is recognized as error instead of text. I tried ClearCollect, but this also did not work. I have absolutely no idea why. Maybe someone knows why this doesn't work or at least has a new input because I'm running out of ideas.

Categories:

Building Power Apps