Answered

Count rows of a collection nested record table with condition

(0) Share

Report

Posted on by newbieppdev_30

Hello, I would like to count rows of the nested record table of my collection. I have a collection call "colPowerOffUpdate" and one of the column has a nested record table value called "Value". I want to count the rows that IsSubItemChecked = true and SubItemStatus = false. Below are the snapshot of my collection and nested record:

Collection:

Nested record:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @newbieppdev_30 ,

Please try:

CountRows(Filter(Ungroup(colPowerOffUpdate,"Value"),IsSubItemChecked = true && SubItemStatus = false))

Best Regards,

Bof

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

Like (0)

Report
Copy link

Link copied!
Hi @newbieppdev_30 ,

To make this work you first have to select the record int the collection and then apply a CountIf function to the Value column. In the below example I'm using a simple First function to perform the record selection:

CountIf( First(colPowerOffUpdate).Value, IsSubItemChecked || !SubItemStatus )

If you want to use this inside a gallery which has colPowerOffUpdate as a data source, use:

CountIf( ThisItem.Value, IsSubItemChecked || !SubItemStatus )

Was this reply helpful? Yes No
newbieppdev_30 18 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft, this worked! I've been stuck with this since yesterday. Thank you very much for your help! 😅

Was this reply helpful? Yes No