Slice bug maybe?

AppSheet AppSheet Q&A
1

Hi, here is my issue,

I have a slice with a working formula , when I’m testing the formula from the Expression Assistant it is working like a charme.

But on my slice only a fraction of the data is selected.

To illustrate, I have 3 conditions for my slice, 2 of them are yes/no and one is IN( _value, _list())

But from that list, it is only picking 1 of the values .

Again, only in the displayed data, in the Expression Assistant all the values from the list are checked .

Update, it works when I’m hard coding my list, but not when I’m trying to get the list from a lookup() , It is changing my syntaxe automatically by ANY(SELECT()) for some reason .

LOOKUP(USEREMAIL(), “app_settings” , “Utilisateur”, “Commune”)
Is transforme in :
ANY(SELECT(app_settings[Commune_text],([Utilisateur] = USEREMAIL())))

Whene testing the expression

Any ideas why ?

2

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

How are FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() related? FILTER(), LOOKUP(), MAXROW(), and MINROW() are all built upon SELECT(), so they all share similar capabilities and limitations. FILTER(“table”, select-expression) is equivalent to: SELECT( table[key-column], (select-expression) ) LOOKUP(match-expression, “table”, “match-column”, “result-column”) is equivalent to: ANY( SELECT( table[result-column], ([match-column] = (match-expression)) ) ) N…

1 Like