Answered

Button visibility based on sharepoint user groups

(1) Share

Report

Posted on by Veblitz

2,249

I used below steps to handle visibility to admin button but im not sure how to check for the users button as i have added the same steps to check for users group as well but its only working for only admin or only users .

I need help in order to check Admin and users using filter property formula for the below steps in onstart property.

Security is my sharepoint list where i added items and gave unique permission for my security list items

Please refer the security list items

Admin Item ->Manage access->unique item level permission->Admin sharepoint group

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Veblitz ,

Do you want the admin button to be visible for admin while the users button to be visible for users group except the admin?

In other words, anyone can only see a button?

If so, you could try as below:

Best regards,

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestions

My requirement is
1)if my user ID got access in Admin sharepoint group then Admin button should be visible in powerapps form and if i do not have access in admin sharepoint group then Admin button should be hided,

2)same way if my user ID got access in users sharepoint group then users button should be visible otherwise users button is hided

unfortunately, im facing below issue that is i removed my access in Admin groups and users group but still its showing Admin buttons

Admin users list

User sharepoint group

I tried removing myself in both the Admin and users sharepoint group(pls check above) but still Admin button is visible but it should not display as i do not have access in admin group and please help in this scenario.

I copied the formula as per your inputs

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

I kindly followup and appreciate kind help for the same.Thanks in advance.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

I kindly follow up and appreciate kind support

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Appreciate kind help and thanks in advacne

Was this reply helpful? Yes No
NurSabrina24 165 on at

Like
a
(0)

Report
Copy link

Link copied!

I assume you have refresh your sp list in your powerapps?

Was this reply helpful? Yes No
NurSabrina24 165 on at

Like
a
(1)

Report
Copy link

Link copied!

From my opinion, you can try to combine both in the same list and add a column name user type for example and determine if the user is admin or user. And you can include a Filter-If function where you will filter the SP list with conditions User().Email = <email column status> and then with If functions for the user type column to set btn visible.

Hope this helps you. I haven't tried the way you did, but this is according to what I have used for this.

Thank you.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes i managed to refresh but unfortunately the formula does not work exactly as expected in any of the probability

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

I request you to please share me the steps hence it would be helpful since i am newbie

Was this reply helpful? Yes No
Verified answer

NurSabrina24 165 on at

Like
a
(1)

Report
Copy link

Link copied!
Instead of OnStart properties, I change it to Visible for each button with this function:
LookUp('People and Groups', User().Email = Email, If('User Type' = "Admin", false, true)) - this is for Visible properties of User button
And for Visible properties of Admin button would be:
LookUp('People and Groups', User().Email = Email, If('User Type' = "Admin", true, false))
Note: I change it to LookUp instead of Filter functions

Hope this helps a little.

Was this reply helpful? Yes No