In with Select

AppSheet AppSheet Q&A
,
1

What I’m intending to do

I have a table with column of all staff emails and then a second column with a enumlist of all the Services they work at which can have anywhere between 1 - 15 different services per staff

On another table I have the forms that are filled out for all the Services. I have then made a slice of this table with row filter condition

IN(Service],LIST(ANY(SELECT(Staff Info[Services To View],[Email]=USEREMAIL()))))

So what I’m wanting to do is the app to search for the staff email, then look at the services they can view and show all the rows of that table where the column [Service] matches all matches from [Services to View].

The problem I’m having at the moment is it only shows the first service in the list and ignores any others. So instead of showing multiple houses that matches it just shows the one.

The funny thing is I swear this has been working fine for the last few weeks in testing and the day we went live it has stopped working that way

Any help would be massive thank you so much in advance

I

2

Please try

IN(Service], SPLIT(SELECT(Staff Info[Services To View],[Email]=USEREMAIL() ) , “,”))

2 Likes
3

Thank you so much that has worked perfectly exactly how i need it too.

Thank you so much for helping as was stressing so much with that

1 Like