I am working on restricting views in my app and we are not having success with the expression.
We have useremails and groups in a table with column headers useremail and role.
We want to allow access to the view if the current user is within the useremail and the role matches the role required to view the table.
I tried this but it just made the view not visible to anyone.
AND(IN(CURRENT_USER,OPS USERS[USEREMAIL],IN("UGA",OPS USERS[ROLE]))
Any help would be greatly appreciated.
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |