Limit picklist options according to $[SYS_USER] many to many

[arammaliachi]

I have an app form screen as follows:

The dropdown should be a FILTER() of table Advertisers according to $[SYS_USER]. In the Advertisers table I have a column named authorized_users which is itself formatted as:

=FILTER(Users,"Users[accessible_advertiser]=THISROW()")

Following the examples from the screenshots, how can I make the dropdown in my build to display only row 2 of table Advertisers to the 2 authorized users and row 3 to none. I'm trying the following unsuccessfully:

=FILTER(Advertisers,"$[SYS_USER] IN Advertisers[authorized_users]")

Column authorized_users is based on the following table:

Moderator note: Edited our personal information from the image.

[Alyssa]

Hi @arammaliachi,

Thank you for your details here

You're very close! You just need to add the column of the agents you want to check. This means your formula will look like:

=FILTER(Advertisers,"$[SYS_USER] IN Advertisers[authorized_users][agent]")

This is how it would look in Builder:

And in the app:

Hope this helps clarify! Let us know if we can help with anything else.