Announcements
Hi Guys
I wonder if anyone could help me with removing the delegation warning from the below code - I have made a collection (colstatus) with the different status choices but cannot figure out how to use this is my formula
CountIf('Vacancy Tracker',Status.Value = "New Request")
Counting functions are never delegable. There is no way to change this to remove the delegation warning. The best you can do is use a Filter() function that is delegable and then a CountRows() around that. The CountRows will still have a delegation warning, but as long as the filter gets you below the data limit it will work for the full data source.
Hi @SteCos
CountIf is not delegable.
try using flow to get that data.
check https://youtu.be/qsIn0mytC_8
--------------------------------------------------------------------------------If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.Thanks,Reza Dorrani, MVPYouTubeTwitter
Thanks for your help guys! @RezaDorrani I really enjoy your YouTube videos!
Thanks @SteCos
Other ways to count items but still delegable in Power Apps?
The only way to count all the items in a large list is to use a Flow. If you want to count a subset of records you can filter them first using a delegable formula and then count the results. But there is no way to count the rows in a data source using delegation in Power Apps alone.
Thank you.
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.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
