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.
State of Arizona