How to restrict users list to the company of the logged in user

[Daisy_Ramirez]

Hello I have an app with groups so I have a security filter that restricts the information to that particular group based on the user that’s logged in. The security filter is: LOOKUP(USEREMAIL(),“group_users”,“user”,“group”)=[group_id]

Question 1: Is there a less expensive expression I can use?
Question 2: I now have to restrict the “group_users” table to only show users in the logged in user’s company.

The above expression no longer works of course as we’re IN the table so it would be great if we use something like LOOKUP(USEREMAIL(),[_THIS],“user”,“group”)=[group_id] but that doesn’t work either.

Any ideas?

Thank you