Button visible only for users with admin role in users sharepoint list

(0) Share

Report

Posted on by ThommyPrez

Hi,

I need make visible a button only if users role in 'SP Users list' is admin.

This is my list:

Titolo is text column with Last Name and First Name of user, Role is selection type column and Users is email address column.

I have this code on visible property of ADD button but not work:

!IsBlank(LookUp('SP Users list'; User().Email = Users; Role.Value = "Admin"))

Can you help me to find a solution?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@ThommyPrez

Try this

LookUp('SP Users list'; Users = Lower(User().Email); Role.Value) = "Admin"

Was this reply helpful? Yes No
ImaKickUrAsh 51 on at

Like
a
(0)

Report
Copy link

Link copied!
Looks like you're very close, try this:
!IsBlank( LookUp( 'SP Users list', User().Email = Users.Email, Role.Value = “Admin” ) )

Was this reply helpful? Yes No
ThommyPrez 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried but don't work 😞 If I change my own role in SP list from Admin to User, the button is not visible and formula result is false with each role.

Was this reply helpful? Yes No
ThommyPrez 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried but don't work 😞 same result as other solution from @EddieE

Was this reply helpful? Yes No
ImaKickUrAsh 51 on at

Like
a
(1)

Report
Copy link

Link copied!

Is the SharePoint column "Users" a people picker? & is it multi-select?

Was this reply helpful? Yes No
ThommyPrez 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes "Users" column is a people picker but no multi-select.

Was this reply helpful? Yes No
Jayant_Kumar 4 on at

Like
a
(0)

Report
Copy link

Link copied!

check the video on this topic
Implementing Role Based Security in Power Apps - YouTube
PowerApps Hide Button Based on User and other fun - YouTube

You need to create a list and add an item on it.
Break the permission and set item level permission.
Now on Powerapp fetch the that particular item, if the record count is 1 means permission is fine else no permission. Set button's visibility based on count.

Was this reply helpful? Yes No