Answered

If user is a supervisor then show visible

(0) Share

Report

Posted on by Maxwell123

Hello, I am building an app and I need a control in it that is only visible to users that have been labeled a supervisor in Sharepoint. The Sharepoint list has the following columns.

Employee Name	Employee ID	Employee Email	Last4DigitsOnCard	Supervisor	SupervisorEmail	IsSupervisor
John Doe	1234	johndoe@gmail.com	1234	Jane Doe	janedoe@gmail.com	Yes

I am trying to do a lookup to return the users record in the list and then check if the user has a "Yes" value under the "IsSupervisor" Column below is my code

If(!IsBlank(LookUp(ReferencenceList,User().FullName=Proper(Title),IsSupervisor="Yes")), true , false )

Let Me Know if you have any suggestions and Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Maxwell123

Please try this code in the Visible property of the control. My assumption will be that the IsSupervisor field is a text type.

!IsBlank(LookUp(ReferencenceList,User().Email='Employee Email',IsSupervisor="Yes"))

If IsSupervisor field is a Yes/No type then do this instead.

!IsBlank(LookUp(ReferencenceList,User().Email='Employee Email',IsSupervisor=true))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Maxwell123 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, I appreciate your quick response!

Yes the field is a text type sorry for not specifying that initially, I plugged that code in and theres no errors however in my testing It is visible no matter what text I put in the column. Any suggestions?

Was this reply helpful? Yes No
Maxwell123 93 on at

Like
a
(0)

Report
Copy link

Link copied!

I was way overthinking this here is the code I got to work. And PS I know I spelled "Reference" incredibly wrong! 😂

LookUp(ReferencenceList,User().Email=EmployeeEmail,IsSupervisor="Yes")

Thanks so much for getting me on the right path!

Was this reply helpful? Yes No