Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Security Filter based on admin and user

G_S
Bronze 3
Bronze 3

I am having a table called Employee

I have key value as [Email]

[Role] column 

I want to set a security filter that Admin role people can see all records and user can see only their records 

I used below expression but it throws error 

G_S_0-1701708496142.png

Expression which is used :

IF(IN(USEREMAIL(),SELECT(Employee[Email ID],[Role]=Admin)),TRUE, [Email ID] = USEREMAIL())

Please suggest correct expression !

0 8 463
8 REPLIES 8
Top Labels in this Space