How do i hide a command bar button based on the users security role

(0) Share

Report

Posted on by SR-10021045-0

Hi,

I am trying to hide two buttons from the command bar in my model driven app. The buttons should be hidden or shown based on the logged in users role.
If the user has the "Manager" role the two buttons should be show. Otherwise the buttons should be hidden. The "Manager role" can see all project entities across the users, but only have read permissions on the project entity. Because of this i just checked of the user have create permission on the project entity. If not, then show the button.

Here is my power fx code, set in the visibility condition bar:

If(DatasourceInfo(projects; DataSourceInfo.CreatePermission); false; true)

I have tried different variations but i cant get it working. Not mather what, all of my users can see the buttons.

Categories:

Building Power Apps

I have the same question (1)

All responses (5)

Answers (0)

Nirav Raval (Akira28) 153 Moderator on at

Like (1)

Report
Hi @SR-10021045-0

>> Use this steps might resolve -
1) Instead of DatasourceInfo, use a direct check against the user's role.
2) Fetch the Securityroles table to verify if the logged-in user has the "Manager" role.
3) Set the button’s Visible property accordingly.

Modify the Visible property of your buttons with this Power Fx formula:

If( LookUp( SecurityRoles, Name = "Manager" && User().Email in Users.Email ), true, false )

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28) 🤞

Was this reply helpful? Yes No
YS-15091406-0 2 on at

Like (0)

Report

Sorry this is not how the security role table works. That Security Role table lists the security roles (Basic User, System Administrator, Workspace Contributor, etc) and their features such as date created, is it customisable, inherited, and so on NOT the list of users in the organisation and their access privileges. Your response is same as I got when I typed into a chatbot. Please share verified answers instead of getting stars as a moderator for pasting chatbot stuff. It does not help as I come to forums seeking real feedback because I am new and need assistance from experienced builders.

Was this reply helpful? Yes No
Suggested answer

Youssef_Arouay 176 on at

Like (0)

Report

Hi,

To control button visibility in a model-driven app using security roles, DataSourceInfo() will not work the way you expect.

DataSourceInfo() checks permissions on the table, but Model-Driven Apps do not evaluate permissions this way inside command bar visibility rules. That’s why all users still see the buttons — the condition is never evaluated correctly.

Try using just :

=> User().HasRole("Manager")

Was this reply helpful? Yes No
Suggested answer

QuentinDURIEZ 547 Moderator on at

Like (0)

Report

Hi,

I never succeeded to hide a command using the user security roles, event if you manage to get the user roles you will experience delegation, so sometimes it will work, sometimes no.

The only way is creating the command the old way with Ribbon Workbench and a custom Enable rule

Regards,

Was this reply helpful? Yes No
Suggested answer

CU24011632-0 4 on at

Like (0)

Report

Hi,

I can give you a hand up via an example. My goal is to allow the people with my ABC App Admin security role to see the 'Activate' ribbon button only.

Inside the ribbon button editor of the App designer, since it can check if the current user has the permission to delete table records using power FX expressions on the top and it's the only difference between the admin role and user role (in my case), I can only show the activate button to those who has the permission to delete records. FX formula: Visible = If(DataSourceInfo('Your Table', DataSourceInfo.DeletePermission), true, false)

Regards,

Was this reply helpful? Yes No