Delegate Access for a Reservation App

[arunshan]

Hello Everyone,

I am building a Reservation App to book workstations and would like to assign a security filter with a condition that will allow the primary user ( for self) and only their delegate users (on behalf of the primary user) to book a station. The expression used is

OR(IN(USEREMAIL(),SELECT(ASET Users[Primary Email],TRUE)),IN(USEREMAIL(),SELECT(ASET Users[Delegate Email],TRUE)))

It worked as expected and when I tested today, this is no longer functioning. Would appreciate it if someone can assist with this ask.

And, I would also like to know if one primary user can have multiple delegate users that can manage the booking for them.

Thanks and I will look forward to hearing from you.

Regards,
Arun
State of Arizona