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
Solved! Go to Solution.
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.
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,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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
I kindly followup and appreciate kind help for the same.Thanks in advance.
I kindly follow up and appreciate kind support
Appreciate kind help and thanks in advacne
I assume you have refresh your sp list in your powerapps?
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.
Yes i managed to refresh but unfortunately the formula does not work exactly as expected in any of the probability
I request you to please share me the steps hence it would be helpful since i am newbie
User | Count |
---|---|
122 | |
87 | |
86 | |
75 | |
67 |
User | Count |
---|---|
214 | |
181 | |
137 | |
96 | |
83 |