Hi Like to give access to action buttons to certain users based on their useremail(), currently its not possible ?..or is there a way to achieve itโฆelse it a good feature to have under action button definition as valif_if etcโฆ
Hi , I request you to try the following
As per my understanding you are looking at invoking actions in a tableโs rows based on usersโ emails.
If this understanding is correct ,then you may wish to try the following ,
roles (Engineer, manager, technician etc.) of the users whom a particular row and hence action is accessible.
each User email, you can assign the roles.
Role
Email Manager
manager1@abcdef.com Engineer
engineer1@abcdef.com Technician
technician1@abcdef.com Engineer
engineer2@abcdef.com Technician
you may wish to put an expression under "If this condition is true"of action definition such as
AND([RolesCol]=โEngineerโ,(ANY(SELECT(EmpRoles[Role], ANY(EmpRoles[Email]) = USEREMAIL(), true)))=โEngineerโ)
For action accessible for managers, the expression can be
AND([RolesCol]=โManagerโ,(ANY(SELECT(EmpRoles[Role], ANY(EmpRoles[Email]) = USEREMAIL(), true)))=โManagerโ)
Of course the above
expressions may be further optimised.
I am sure your actual implementation need may be different. Hope the above helps you in some way. Also Role table concept may not be applicable if data needs seperation by security filters.
Thanks for such a detailed solutionโฆbut in my use case like to give access to tables on which action buttons acts based on useremail () and not row basedโฆ
if under actions there is a valid if which allows expressions will be a great new feature โฆ
Hi @Thomas_Varghese :Thank you for your revert. Yes, got it. Your use case is actions access control at table level and not at row level.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |