Hi AppSheet Team,
I’m currently building a slice depending on user allowances.
The purpose is to display a list of buttons to the users, so that they can jump to view according to what they are supposed to use.
Despite testing my expression outputs that looks OK, the result is not what I expect.
I describe the structure below.
Table : Menu View
List of possible views and deeplink expressions
Table : Users
List of users, with column [AccessLevel] set this way:
Slice: MenuView_ReadOnly_PerUser_Slice
This slice filters the views allowed to the current user, depending on its email.
ISNOTBLANK(
INTERSECT(
SPLIT(
LOOKUP(
USEREMAIL(),
"Users",
"UserEmail",
"AccessLevel"
)," , "
),
LIST([key])
)
)
What I expect:
a slice keeping the items that are allowed to the user.
What I see at evaluating data from my Table Users:
This is a result of the enumList I ticked
What I see at evaluating data from my slice:
This is the expected result (see below)
What I see at emulating in the editor:
Only one item, this is not what I expect to be displayed.
I checked multiple times, the displayed view is based on the correct slice.
I just can’t understand what’s going on.
Does someone have a clue ?
Many thanks in advance !
Solved! Go to Solution.
Try:
IN(
[key],
SPLIT(("" & Users_currentUser_AccessLevel_ReadOnly_Slice[AccessLevel]), " , ")
)
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |