Hide an Icon based on Count Rows in a Gallery

(0) Share

Report

Posted on by Sajarac

3,284

Hi there,

I would like to hide an icon based on this formula:

CountRows(Gallery1.AllItems) = 0

So this means if the gallery is empty the icon won't be visible.

The problem is: In my gallery I have some fields that the default = "false" or "true"

But there is no data in my gallery. And still showing the icon as visible.

How can I skip this?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@sajarac

If you have any records in your Gallery, then the count will not be 0.

What you will want to do is filter out certain records in that gallery.

i.e. CountRows(Filter(Gallery1.AllItems, <criteria>)) = 0

Just replace the criteria with what you want to filter on about those rows in the gallery.

I hope this is helpful for you.

Was this reply helpful? Yes No
Sajarac 3,284 on at

Like (0)

Report
Copy link

Link copied!

OMG, you are 24/7
As always thank you very much for your prompt response.

I don't have any records in my gallery but some fields are showing i.e false or true and I guess the formula is counting those are records.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sajarac

I'm actually an AI Robot!! LOL I could use a couple of those though!!

Well, if something is showing in your Gallery, then it has to have records. Otherwise it would be blank.

Now, when I say something showing - that is in Play/preview mode...not in design mode.

In Design mode you will see the template of the Gallery always. In play/preview, you will see the template for each record in your items. So, again, if you see something in play/preview, then there HAS to be records in your gallery Items.

Confirm what you are seeing based on that statement.

Was this reply helpful? Yes No
Sajarac 3,284 on at

Like (0)

Report
Copy link

Link copied!

OK. How Do I know that you are not a Bot? 😀

In edit mode I see the template and 3 fields with a value of false in a record that I know is empty.

Now switching to another record that has some values I see the same but when I hit play/preview I see nothing.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sajarac

"Invalid Input!!" <in robotic voice>

Okay, so if you see nothing in play/preview, then that means there is nothing.

So, let's explore...

What is the Items property of your Gallery?

Was this reply helpful? Yes No
Sajarac 3,284 on at

Like (0)

Report
Copy link

Link copied!

Is :
Filter (myDatabase, ReqID = Gallery1.Selected.ReqID)

And inside there is a HTML Label

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sajarac

Confusion sets in!!!

In your original formula you were trying to count the rows of Gallery1

BUT, you are stating that your Items property is based on a record Selected in Gallery1 - that is not valid. You should be getting a circular reference error on that.

Was this reply helpful? Yes No
Sajarac 3,284 on at

Like (0)

Report
Copy link

Link copied!

sorry sorry, let me send you some screen shots

Was this reply helpful? Yes No