Announcements
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:
Hi @newbieppdev_30 ,
Please try:
CountRows(Filter(Ungroup(colPowerOffUpdate,"Value"),IsSubItemChecked = true && SubItemStatus = false))
Best Regards,
Bof
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 )
Hi @v-bofeng-msft, this worked! I've been stuck with this since yesterday. Thank you very much for your help! 😅
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
