Solved: Security Filter for Many to Many Relationship - Page 2

Peter_S1 · 04-10-2021 04:45 PM

Hi,

I’m trying to do a security filter that will only allow users belonging to a certain company to view records for their company.
This would be a many to many relationship?
Meaning that a company can have many users, and I want all users of that company to be able to see information for that company only.

A user could also own more than one company/entity. Is there a way to do this where more than one user has access to more than one company?

Steve

This might be closer:

ISNOTBLANK(
  FILTER(
    "Users",
    AND(
      ISNOTBLANK([Email]),
      ([Email] = USEREMAIL()),
      ISNOTBLANK([Company ID]),
      ([Company ID] = [_THISROW].[Company ID])
    )
  )
)

View solution in original post