Unable to Hide Custom Command Bar Button Based on User Role in Model-Driven App

(0) Share

Report

Posted on by CU08100545-1

Hi Team,
I have created a custom “Create Copy” button on the form in our Model-Driven App.

Requirement:
The button should be visible only to System Administrator users
The button should be hidden immediately when the form loads for non-admin users
Non-admin users should not see the button at all

What I Have Tried:
Checked the Visibility option in Command Designer
Only “Show” option is available
No Power Fx (fx) option is visible
Tried using JavaScript to control visibility
Not possible to properly hide modern command bar button on load
I have implemented a JavaScript role check on the button click. However, this logic only runs after the user clicks the button.

Right now, the button is visible to all users, but non-admin users are blocked only after clicking it.

However, the requirement is that the button should be hidden completely when the form loads, so non-admin users should not see it at all.
Is there anyway to hide the button on page load based on user role?
Do we need Power Fx for this, or is Ribbon Workbench the only option?
We are using Modern Command Designer, and the Visibility section only shows “Show” with no Power Fx or custom rule option available.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Sunil Kumar Pashikanti 1,353 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @CU08100545-1,

Did you follow the below steps:

Open your app in the app designer, go to the table's pages, click the three dots (...), and select Edit command bar.
If prompted, ensure you select Power Fx as the commanding option. This creates a component library that stores your formulas.
Set Visibility Rule:
Select your "Create Copy" button.
In the Visibility dropdown on the right pane, change it from "Show" to "Show on condition from formula".
In the formula bar at the top, select the Visible property and enter a formula that checks for the user's role.

Since User() function support can be limited in some model-driven environments, a common approach is to check for a specific privilege that only System Administrators have, such as the ability to read all security roles.

// Example: Hides button if user cannot see 'System Administrator' role details !IsBlank(LookUp(SecurityRoles, Name = "System Administrator"))

Alternatively, if your environment supports it, you can check for the role name directly by looking up the current user's email in the Security Roles table.

// Hides button for everyone except 'System Administrator' "System Administrator" in LookUp(Users, 'Primary Email' = User().Email).'Security Roles (systemuserroles_association)'.Name

References:
https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/use-command-designer#:~:text=Currently%2C%20the%20command%20designer%20can,to%20store%20Power%20Fx%20formulas.

https://www.beringer.net/beringerblog/command-bar-customization-in-model-driven-apps/#:~:text=To%20access%20the%20command%20bar,being%20taken%20to%20the%20editor.

https://stoneridgesoftware.com/how-to-show-and-hide-buttons-in-dynamics-365-using-power-fx-in-power-apps/

https://www.reddit.com/r/PowerApps/comments/1md5zb9/command_button_visibility/#:~:text=It%20could%20be%20possible%2C%20if,the%20command%20buttons..%20sad.

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Was this reply helpful? Yes No
CU08100545-1 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the suggestion. Unfortunately, our environment does not show the Power Fx option in the Command Designer — the Visibility section only shows “Show” with no formula option. Is there any way to enable Power Fx visibility in this environment, or should we use Ribbon Workbench instead?

Was this reply helpful? Yes No
Sunil Kumar Pashikanti 1,353 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU08100545-1

How to enable Power Fx visibility in the Command Designer

Open the app in the modern app designer

Solutions → open your solution → select the model‑driven app → Edit (modern designer).
From Pages, choose the table → … → Edit command bar → pick location (Main form / Main grid / Subgrid).
The first time you add a modern command, pick Power Fx (this creates the command component library).

Create a new custom command (don’t try to edit OOB)

OOB (classic) commands cannot be edited in the modern designer; you can add new commands, but to change OOB visibility you still need classic tools (Ribbon Workbench).

Set visibility with a formula

Select your new command → in the right properties pane under Visibility, choose Show on condition from formula → you’ll get the Power Fx formula bar for Visible.

If the formula option still doesn’t appear

Confirm you are not on an OOB command. Try New → Command and check Visibility again.
Open the command via the component library. In Solutions, open the Command Component Library entry and ensure it loads; sometimes adding data sources there (see next section) “unlocks” the experience. [forwardforever.com]

If the above does not help or you specifically must hide/override OOB commands, then use Ribbon Workbench (XrmToolBox) to apply classic Enable/Display rules or JS. It remains the most reliable approach for OOB buttons.

Let us know if it helps!

Was this reply helpful? Yes No