Solved: Filter a menu table with IN() error - Page 2

VictorB · 09-06-2022 07:37 AM

Hi,

I'm trying to filter a menu view, the answer seem easy to me but the expression it's not working... am I missing out something ?

I'm using a EnumList column of type Text in the User table to select a list of menu views the user is allowed to see. Then i'm trying an expression in the security filter of the Menu Table :

IN([Name]; User_Slice[View acces])

The result is always False. I don't understand why.

Any thoughts ?

P.S. 1 User_Slice[View acces] alone give me the right list when I test it.

P.S. 2 The column View acces is type Text

Suvrutt_Gurjar

As you mentioned, [View acces] is an enumlist. So the expression User_Slice[View acces] creates a list of lists. You can flatten such a list of lists into a normal list of single elements by using SPLIT(), something like below

IN([Name], SPLIT(User_Slice[View acces],","))

SPLIT() - AppSheet Help

View solution in original post