Show/Hide Command Bar Buttons using PowerFx

(1) Share

Report

Posted on by mk1329

Can we set visibility for a command bar button using powerFx based on Logged in user Security Role ?

I have tried This using button component library

but the formula returns boolean correctly based on the roles, but when published not working as expected

Categories:

General Comment

All responses (5)

Answers (0)

mk1329 6 on at

Like (0)

Report

Show/Hide Command Bar Buttons using PowerFx

@MSR@08012015 we don't have user id on security roles table
Suggested answer

MS.Ragavendar 1,126 on at

Like (0)

Report

Show/Hide Command Bar Buttons using PowerFx

If the below one doesn't work try with the GUID

If(Lookup(SecurityRoles, 'User Id'=Guid(User().Email)).'Role Name' ='System Admin",true,false)

// Note check the table is accessible in our powerapps and Role Name as per your requirement.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item
MS.Ragavendar 1,126 on at

Like (0)

Report

Show/Hide Command Bar Buttons using PowerFx

Hi,

Try this formula

If(Lookup(UserRolesTblName, UserEmail=User().Email).Roles in ["Admin","Manager"],true,false)
mk1329 6 on at

Like (0)

Report

Show/Hide Command Bar Buttons using PowerFx

@Michael E. Gernaey yes updated my question as well
Michael E. Gernaey 38,415 Super User 2025 Season 1 on at

Like (0)

Report

Show/Hide Command Bar Buttons using PowerFx

Hi @mk1329

Are you talking for Model Driven Apps?