Hello friends, i have an app that uses an user system to decide who sees what and all that stuff, but i’m having problems using an enumlist to assign tasks.
I have a CurrentUser slice with a filter condition that is [Email]=useremail(), the User table has a role (enum) and a tasks (enumlist base type ref to the tasks table) columns.
I’m trying to filter the Tasks table using both the role and the tasks columns, this is the expression that i’m using for the CurrentUserTasks slice:
SWITCH( INDEX(CurrentUser[Role],1), "Residente de obra",IN([Task_Id],INDEX(CurrentUser[Tasks],1)), "Director de obra",IN([Task_Id],INDEX(CurrentUser[Tasks],1)), TRUE)
It works when there’s only a single task assigned, but if i assign more than one it just doesn’t show them, any ideas?