Button Visibility depending on Sharepoint List Column Value

[Alois]

Hi all, I've searched online how to go about this but have yet to find a solution for my application.

Basically, I created a login screen with access control linked to the following Sharepoint list. Each user has a defined role - Admin or Driver. 

Does anyone have an idea to set visibility of a button to true for Admin and false for Driver?

Thanks in advance,
Alois

[eka24]

On your login screen, insert a label and set it's text property to;

LookUp (LogincredentialList, Username= Textbox4Username.Text, Role)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[MikeScott]

Are you doing this checking to make the login button visable or after they have already logged in? What you could do is when they log into the app, you save their details to a local "currUser" object. This object would have any pertinent info that you would need to do logic, such as your column with the type of employee (admin, driver, etc). Once you have this you can set the button's visibility to something like this:
If(Object.Role = "Admin", true, false)

This will look at the current object (currently logged user) and see if they are and admin or not. If they are, it will set visability to true and if not it will set it to false. 

I hope this is what you were asking! If so accept as solution and if not help me understand and I'd love to give you another idea to test! goodluck in your powerapping!

[RandyHayes · Accepted solution]

@Alois 

Keep in mind that all users need to have access to your username and password list in order for your app to work correctly.  I mention this because storing the information in that list means that anyone can get to it if they want, and thus, there goes your security!

That said, if you want to set the visibility of a button (let's say btnSomething) you can change the Visible property to the following:

!IsBlank(LookUp(LogincredentialList, Username= Textbox4Username.Text && Role="Admin, ID))

This button will then be visible if the user is Admin

Note, there is no need to create variables as you have just created the logic you need.

From this point forward if you want other controls to be visible based on Admin, you can refer to the control.  For example, if you had a button on ScreenX that needs to only be visible for admins, then simply set the Visible property of that button control to btnSomething.Visible  No need to duplicate that formula ever again, just refer to the original button - if it is visible, the person is "Admin" if not, then they are not.

I hope this is helpful for you.

[nvargas]

@RandyHayes ,

How could you adapt that coding to make it based on two different list columns? Meaning I have one list that has user emails in it and another list with admin emails in it. I want to make an object visible for the user if their email doesn't exist in the user list. At the same time, I want the object to not be visible if the user email exists in the admin list.

Everything I've been trying hasn't really worked for both scenarios.

My current coding for the visible property of the object:

If(!IsBlank(LookUp(UserList, Alias= User().Email)) Or IsBlank(LookUp('AdminList', Email= User().Email)), false, true)

[Sidhant_02]

Hi @RandyHayes and @Alois ,
I had a similar requirement in which I want to show a add button only to users for a specific user role i.e. Administrator. So in my SharePointList (named App users) where all the credentials are stored like username, password, role, email (Role is a Choice column with values Administrator, User, Manager).

The SharePoint list:

So I used the expression that you have mentioned @RandyHayes like this:

But the button was not visible in any case, like I logged in with the user Shubham and navigated to the Course page I did not see the clock icon and then I navigated with Sid (Role: Administrator) and even then I could not see the icon. 
Could you please let me know any corrections that I need to make?.

Regards,
Sidhant