Answered

CountIf on Gallery Label

(0) Share

Report

Posted on by Farcole88

Hello,

I have a nested gallery with a label to indicate if someone is over a maximum number of points. This is a label that I created based on an "If" statement, and therefore not coming directly from a list or other source. I have tried a countif statement to control the displaymode of a button outside the gallery. Context would be that if any of the gallery rows exceed the maximum points, to disable to button until the issue is resolved (points < Weekly maximum).

Here is my code:

My label "Label_OverMax" is based on [If(Sum(Filter(collection, Column=ThisItem.Result), Points) > Value(Label_Max.Text), "Over Weekly Max", "")

Does anyone know why the CountIf function is returning 'blank'?

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Farcole88 ,

How many items will be there in the Gallery? Can you see any Label_OverMax Label text is "Over Weekly Max"?

It seems like Power fx has the similar issue as in Excel... Please try and use CountRows() for your scenario or add an additional If statement for the CountIf function:

CountRows(Filter(Gallery_CatActivities.AllItems, Label_OverMax.Text = "Over Weekly Max")) > 0
If(CountIf(Gallery_CatActivities.AllItems, Label_OverMax.Text = "Over Weekly Max") = 0, true, false)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Verified answer

JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-jefferni @Farcole88 ,

The result is still Blank even though I use your formula. Your further guide is highly appreciated.

CountRows(Filter(GallerySNGroupTest.AllItems,LabelErrorMessageSNGroup.Text="Required"))

UPDATE: I found the workaround or trick (or probably "bug" / enhancement opportunity for Microsoft to consider). The formula only works if the Gallery is outside of Form.

P.S. it will also work if you just insert a label control (with the exact same formula) into the Gallery which sits inside a form. Once it "links" up, you can then remove the label and the formula should still work.