Dynamic Dashboards filter for enumlist of task assigned ref by users table linked

[Muhammad_Salooj]

@Aleksi   @QREW_Apps  @CJ_QREW 

I'm creating a task app and I want to use the dynamic dashboard with slice filters that can be populated by the user and will be set in their user table. (I have a Users Table, a Tasks Table, and  a Tasks table slice to be filtered using the dynamic dashboard setup.) 

How can we do multi selects to bring up data from a referenced table as enumlist.. Use case: I have a tasks table, and a users table.. Tasks can be assigned to multiple users (referenced from the user table) .. I want to select multiple users in the filter and then show all tasks if they're one of the users assigned to those tasks...

For example, If I select Adam, Noah, Moses,... Then if there's 1 task with Adam, another with Adam and Noah, and another with Adam, Noah and Moses,... All 3 of these tasks should show even though the users assigned vary.

[WillowMobileSys]

Look at using the INTERSECT() function.

AppSheet Help INTERSECT()

[SkrOYC]

IN() - AppSheet Help
AND() - AppSheet Help

[MultiTech · Accepted solution]

---

@WillowMobileSys wrote:

Look at using the INTERSECT() function

---

Specifically: combining IsNotBlank() and Intersect()

A logic branch for my dashboard slice filter would look something like:

if(IsNotBlank(Current_User[User_Enumlist_Filter]), 
  isnotblank(
    Intersect(
      Split(Concatenate(Current_User[User_Enumlist_Filter]), " , "), 
      [List]
    )
  ), 
true)

[Muhammad_Salooj]

Perfect, this worked like a charm!