New Bug Encountered: LIST Behaviour

When you construct a static list of values with LIST expression, it does not matter if you enclose the list items with double quotes or not, as AppSheet interprets the list items as text already. So below expressions are truly identical:

LIST(Red, Yellow, Green) === LIST("Red", "Yellow", "Green")

However, when replying to a post of @Kirk_Masden, I have realized something which seems a bug to me. When you use such a LIST expression in-conjuction with other expressions like FIND, appsheet evaluates the above 2 syntax differently. For example:

[1] FIND("Red", CONCATENATE(LIST("Red", "Yellow", "Green")))

and

[2] FIND("Red", CONCATENATE(LIST(Red, Yellow, Green)))

The first expression evaluates correctly and returns the value of 1, which is correct because the item “Red” starts at the 1st index of the string. However, when evaluating the second one, the very 1st item of the list is capitalized as RED and as there is no match, the evaluation returns the value of 0. Provided you explicitly capitalize your search string in the second expression, it returns the correct value as 1.

FIND("RED", CONCATENATE(LIST(Red, Yellow, Green)))

Here is the screenshot from the expression tester:

1 Like

We had make some further testing with @Aleksi and come to a conclusion that the problem relies on the explicit usage of the word RED. Provided you have a word “red” in your list, and provided it’s not quoted, than the list evaluation capitalizes only this word.