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 |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |