Just tried to launch my online for our vendors and No can Do.
I have a security Filter than is the Following
OR(In(useremail(),Admin Emails[Email]), In([ID], SELECT(Security Filters[Vendors], [email]=useremail())))
Note, this expression could significantly impact sync time.
ANY of these statements is true:
…1: (USEREMAIL()) is one of the values in the list (ADMIN EMAILS[Email])
…2: (The value of column ‘id’) is one of the values in the list (The list of values of column 'Vendors’
…from rows of table 'SECURITY FILTERS’
…where this condition is true: ((The value of column ‘Email’) is equal to (USEREMAIL())))
Admin Emails Work perfecly, Everyone onsite here can see everything. I removed my own email from admin emails and added to a few vendors in the Security Filter Table, and this works completly fine, problem is when somone elses email is added to security filter table for certain vendors they see nothing.
Security Filter Table
I’m have no idea what I’m doing wrong and thought i had it all figured out. Also tried contains etc but to no avail. I dont understand why it is working for my email and not for others. Extremly frustrating. Ugh