cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ClementeChH
Level: Powered On

How to hide items in a Gallery with a label countif function as a condition?

Hi,

 

I need to hide some items in a gallery to create a menu selection. De items in the gallery have a diferent elements, one of them it's a Label that contain in his Text a formula CointIF(). So, when this Label.Text  = 0, the item will be hiden, and show the items that contains any other number.

 

I upload a photo of muy Gallery.

 

MenuGallery.png

 

Thank for yur help.

 

CCHH

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Level 10

Re: How to hide items in a Gallery with a label countif function as a condition?

You would need to filter the gallery items to keep those from appearing.

What i might recommend is to Collect the items in a collection and AddColumns to the collection that have the CountIf formula.

Then on your Gallery - Filter(dataSource, CountColumn>0)

 

2 REPLIES 2
RandyHayes
Level 10

Re: How to hide items in a Gallery with a label countif function as a condition?

You would need to filter the gallery items to keep those from appearing.

What i might recommend is to Collect the items in a collection and AddColumns to the collection that have the CountIf formula.

Then on your Gallery - Filter(dataSource, CountColumn>0)

 

Community Support Team
Community Support Team

Re: How to hide items in a Gallery with a label countif function as a condition?

Hi @ClementeChH,

 

You could just use filter function to extract items that the number field are not equal to 0.

My app is based on SharePoint list and there is a Number column, I will use the following code to show items that number are not equal to 0:

Filter(List11,Number<>0)

Please take it for a reference.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.