Visibility based on SP Yes/No column

(0) Share

Report

Posted on by ErikM9

163

Hi All,

I'm missing something. I feel like this is such a basic operation.

I have a Yes/No column in a SharePoint list.

In the app, I'm trying to make an If statement stating that, if the check box is checked, then make the image visible.

I just can't seem to get the column reference syntax right:

If('TEST_CS_tool(EN)';color_chart.value, true, false)

Feedback would be great appreciated.

Thanks-Erik

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

charlessexton 11 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It's as simple as setting the visibility of the image to the column value.

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ErikM9

Try this:
If('TEST_CS_tool(EN)'.color_chart, true, false)

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
jfeghali 68 on at

Like (0)

Report
Copy link

Link copied!
If I understand correctly, the solution should be rather simple. In the Visibility property of the image:
ThisItem.'Yes/No-Column'.Value
You shouldn't need any if statement, as the column is a boolean. Change 'Yes/No-Column' to the name of your column.

Let me know, if you need any more help 🙂

Was this reply helpful? Yes No
ErikM9 163 on at

Like (0)

Report
Copy link

Link copied!

Thanks charlessexton
PowerApps is not accepting "ThisItem" as a function?
I've inserted a Image into a container. In Visible, I want to say, If(ListName.Column, is equal to true (visiable, else false(hidden)

Erik

Was this reply helpful? Yes No
charlessexton 11 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

ThisItem is because my example was showing a Gallery. You will need to refer to the record.

e.g. First(ListName).Column will get the Column for the first record, and that can be put in the Visibility property of your image. You don't need to specify true or false as a Yes/No column returns true or false.

Was this reply helpful? Yes No
ErikM9 163 on at

Like (1)

Report
Copy link

Link copied!

Awesome. Thank you.
I don't understand why I need to use the operation First?
Also, I did not try placing the ListName in brackets followed by the column.

So many different rules...

Was this reply helpful? Yes No
charlessexton 11 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

A list is a group of records/items. You need to specify which of those records should be looked at for the Yes/No column.

The brackets are needed when you use a function. In my example above, the function is called First(). It retrieves the first record in a data source. You can find a list of all of the available functions here: https://learn.microsoft.com/en-us/power-platform/power-fx/formula-reference-overview

Was this reply helpful? Yes No
ErikM9 163 on at

Like (0)

Report
Copy link

Link copied!

Hello,
I thought the solution from charlessexton was correct, but it is not responsive to when the column is not true.
The "ThisItem" function is not recognized. Name is invalid?
I feel like the key is in the message say that the data type is a Table. This reminds of a situation I ran into on the past. I just can't remember what it was that I did.

Was this reply helpful? Yes No
jfeghali 68 on at

Like (0)

Report
Copy link

Link copied!

Could you provide us with screenshots of your app, to better understand the structure?
I think we are talking past each other because your problem might have been misunderstood.

Was this reply helpful? Yes No
Verified answer

ErikM9 163 on at

Like (2)

Report
Copy link

Link copied!

Solved!
I knew the issue was going to be silly.
The presented data is part of a collection that is executed on the OnStart.
I also referenced the yes/no column from the selected record in the gallery.
Therefore, the function is: Gallery1.Selected.Color_chart and I initiated OnStart to refresh the collection.

Was this reply helpful? Yes No