Hi.
I am trying to compile a conditional expression for the system generated ‘Edit’ action. What I want to achieve is to allow all users to edit records where [Signature] is blank but if the user is an administrator they can edit records with a [Signature] value. The Administrator flag for each user is held in Employees Table.
What I have so far is
OR(
ISBLANK([Signature]),
AND(ISNOTBLANK([Signature]),
IN(“Yes”, Employees[Administrator])
))
Doesn’t seem to be working. I know I am missing something but not quite sure how to update expression accordingly.
Any help would be great, thank you.
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |