Unanswered

How to apply CountIf and CountRows functions on child gallery items to count parens gallery items ?

(0) Share

Report

Posted on by ManouverRR

Hi,

I am unable to count rows of parents gallery items while applying CountIf and CountRows formulas on child gallery item. Bothe has different SharePoint list as data source. I also unable to filter Parent galley items while applying filter formula on child gallery item.

Any solution for it ???

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ManouverRR
Can you please share all data needed to replicate your issue?

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ManouverRR ,

Could you tell me

1)the formula in your parent gallery's Items and child gallery's Items?

2)what column do you want to count? count rule? that column data type?

3)fields data type in your parent gallery?

CountIf and CountRows functions do not have limitation for parent gallery or child gallery.

The key point is what formula that you use.

So please show me the details, then I will give you more detailed advice.

Best regards,

Was this reply helpful? Yes No
ManouverRR 2 on at

Like (0)

Report
Copy link

Link copied!

The formula I apply is -
"Total 60 KVA UPS:" &" " & CountIf(Gallery1_1.AllItems , Title5_7.Text ="60")
All column data type is - single line text input.
I am using two share point list as date source . one is for master date(for reference) and other for data entry.
I am displaying entered date in gallery as rows . columns include from both list.
if column data belongs to master list then count if not work if column data belongs to data entry list the it work.
for example in my formula - if UPS KVA rating data belongs to entered data list then formula work if UPS KVA rating data belongs to master list then formula is not work.

Thanks

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ManouverRR ,

Could you tell me:
1)the formula in the gallery's Items?

2)what control do you use to display data of master date? how do you set this control? formula?
3)what does Gallery1_1 and Title5_7 represent? the child gallery or the parent gallery? Title5-7 is used to display what?

4)what is the counting rule in detailed?
If you could describe with screen shoot, it will help me to understand.

What's more, if "Gallery1_1" is the gallery to display data entry list, then Gallery1_1.AllItems could only represents data related to data entry list.

Best regards,

Was this reply helpful? Yes No