Count number of items in SharePoint list based on text values?

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I have a label in a gallery where I want it to show the total number of items in a SharePoint list based on a text field.

The label is on a gallery named "galTopics" and I wish is to lookup the number of items in the gallery named "galSubtopic".

The Items property of "galTopics" is set to:

Filter(TopicsClaims,Building = galDocData.Selected.spBuilding)

The Items property of "galSubtopic" is set to:

Filter(SubtopicArgEvi_1, Building = TopicBuildingValue.Text && Topic = TopicDD.Selected.Value)

So for the label on "galTopics" I want to show the number of Subtopics in "galSubtopic" with the same Topic value that is in "galTopic".

I've tried this but no luck:

CountRows(
Filter(
SubtopicArgEvi_1, 
Topic = galTopics.Selected.Topic))

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

BCBuizer 22,577 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @sudosaurus ,

Assuming the label is inside galTopics, this is how to show the number of subtopics per topic:

CountIf( SubtopicArgEvi_1, Topic = ThisItem.Topic )

Was this reply helpful? Yes No
WarrenBelz 154,492 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @sudosaurus ,

What about simply using the Items of the sub gallery

CouintRows( Filter( SubtopicArgEvi_1, Building = TopicBuildingValue.Text && Topic = TopicDD.Selected.Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@BCBuizer that kinda worked however it is returning all values that match the name, which is what I don't want.

I've just tried this instead and that's not working for me:
CountIf(SubtopicArgEvi_1, Building = TopicBuildingValue.Text && Topic = ThisItem.Topic)

Essentially if "Building1" is selected, you can add topics and "Building1" is patched to the Topics list so that we can ensure the right topics are being displayed for the building. The same goes for the Subtopics list where the items are set to:
Filter(SubtopicArgEvi_1, Building = TopicBuildingValue.Text && Topic = TopicDD.Selected.Value)

So, I only want to display the number of topics that "Building1" has - "Building2" may have more or less.

@WarrenBelz - I also tried your suggestion but errored for me.

Was this reply helpful? Yes No
BCBuizer 22,577 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @sudosaurus ,

Can you please share what is not working about the formula you said you tried? From first glance it looks correct:

CountIf( SubtopicArgEvi_1, Building = TopicBuildingValue.Text && Topic = ThisItem.Topic )

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer

Was this reply helpful? Yes No
BCBuizer 22,577 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @sudosaurus ,

As the error mentions, this formula created a circular error. Is the TopicBuildingValue control inside the TopicsClaimForm by any chance? If it is, I suggest using another control out side of the form to select the building.

Was this reply helpful? Yes No