Greetings of the day!
This is occurring within an app in Classic Experience
I have a findrow function that works when I pass in a literal but when I pass in SYS_USER it doesn't return what's expected.
I have a table User_Language with two columns: User, Language. My user is "Dev X Chris" and I can display this on my screen by setting a data cell to SYS_USER. All good there.
What I want to do next is get the value of User_Language[Language] where User_Language[User] is the current user. In the table, User "Dev X Chris" has a Language of "English" I use the latter to get some additional data (which works fine, ironically).
On the data cell Language, I have this Data source setup:
- Type is Variable
- Initial Value uses this formula:
=FINDROW(User_Language, "User_Language[User]=$[SYS_USER]")[Language]
which resolves to #VALUE
If I pass in the literal condition, ala:
=FINDROW(User_Language, "User_Language[User]=""Dev Chris X""")[Language]
I get the resulting language for the users and can carry on.
What am I doing wrong here?