Function only working for one group and not all listed

AppSheet AppSheet Q&A
1

I have 2 tables, 1 table is named Notifications and the other is users. They both have an enumlist field with the same values in them. The User is assigned to certain branches like this

Tragertt_0-1692822905737.png
Tragertt_0-1692822905737.png560×279 9.47 KB

I want to send out a notification to anyone that has the selected branch in their “Organizations” field. The notification looks like this

Tragertt_1-1692823004872.png
Tragertt_1-1692823004872.png248×417 9.76 KB

My code looks like this

select(users[email], in([Organizations], users[Organizations]) = in([_THISROW].[Organization], [Organizations]))

This code works but only if you only choose 1 Org to send it to. If I choose San Diego Branch then anyone with San Diego Branch list in their organization will get an email. The problem is when I choose San Diego Branch and Riverside Branch then no emails are sent. Any thoughts?

2

You’re comparing 2 Lists. Use ISNOTBLANK( INTERSECT() ) as the condition in your SELECT().

3

I tried this

select(users[email], isnotblank(intersect([_THISROW].[Organization], users[User Organization])))

and it tells me Intersect does not accept a list of list. This is the first time I have used intersect so any help would be great.

4

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column-values-in-the-entire-table/50771