How to visible based on Value

(0) Share

Report

Posted on by dylandavis09

438

How to set up for visible based on value from SharePoint.

There are two text labels, one for the value 'Yes' and another for the value 'No.

If based on value is "No". (see below screenshot) If based on value is "Yes". (see below screenshot)

Screenshot 2023-11-05 015525.png Screenshot 2023-11-05 015403.png

^^ Label1_107 ^^ Label1_106

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

Hi @ANB, sorry, I just found out that I was wrong to use a comma; it should be an equal sign (=). All good! Thank you!
Also, I'm still having issues with DisplayMode. It didn't save the work after I locked my computer in sleep mode. 😭 I just start over. Please check: Display Mode If Lookup - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

What is the error message? What is the type of Full Name column?

Thanks,
ANB

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

Thank you! I just added it, and still shows as error. Should be works, I don't know why it's still error.

Was this reply helpful? Yes No
Verified answer

ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @dylandavis09 , As i remember for your other queries where I tried helping you. You have being using Choice column type for other SP list.
If 'Full Name' is Person type column and Graduation is of Choice, then below code will help.

If(Lookup('DHS Students Users', 'Full Name'.DisplayName = User().FullName).Graduation.Value = "Yes", true, false)

If 'Full Name' is text type column and Graduation is of Choice, then below code will help.

If(Lookup('DHS Students Users', 'Full Name' = User().FullName).Graduation.Value = "Yes", true, false)

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

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
cdwhite 1,067 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dylandavis09 ,

Is Graduation a choice column in your list? If so, you'll need to reference it in any formula for your visible property like so:

If(Graduation.Value = "Yes", true, false)

As the Visible property is boolean anyway, you can streamline your code further. For the label where the Graduation columns is yes:

Graduation.Value = "Yes"

And where equals no:

Graduation.Value = "No"

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @dylandavis09 , Please try this:
If(Lookup('DHS Students Users', 'Full Name' = User().FullName).Graduation = "Yes", true, false)
If the 'Full Name' is text type column and Graduation is also text type column in SP list. If this does not work then please help me with type of both the columns in SP list.

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

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

@ANB, Hi again! This is not the one. I have a screenshot to show that I have a SharePoint list column. If 'yes,' the label will be displayed; if 'no,' the label will be hidden.

Was this reply helpful? Yes No
ANB 7,250 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @dylandavis09 , Hi Again! If I understood your requirement, you are looking for hide or show the label based on value? Then below code can help you and this should be on visible property of control:
If(SPValue = "Yes", true, false)

If this is not the one that you are looking then give little bit of background of SP list and column.

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

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No