Cannot compare List with Text in

Hi. I have the next expression:

SELECT(“Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]”, Traduction[Text] = “Confirm”)

The expression “Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]” return Traduction[CA] if the language of the user is Catalan, Traduction[ES] if the language of the user is Castilian or Traduction[EN] if the language of the user is English and I have this columns in my table.

The field Traduction[Text] is key and contain AppSheet’s expressions: Confirm, Yes, Delete… My objective is use this expression on Localize functions to have an easy traductor.

The interface returns “Cannot compare List with Text in (Traduccions[Literal] = “Confirm”)”.

What is the error? Can you help me?

THANKS!

0 4 1,222
4 REPLIES 4
Top Labels in this Space