Answered

Delegation Warning on Countif formula

(0) Share

Report

Posted on by SteCos

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")

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,143 on at

Like (1)

Report

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, MVP
YouTube
Twitter

Was this reply helpful? Yes No
SteCos 36 on at

Like (1)

Report

Thanks for your help guys! @RezaDorrani I really enjoy your YouTube videos!

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (0)

Report

Thanks @SteCos

Was this reply helpful? Yes No
RobertLim 12 on at

Like (0)

Report

Other ways to count items but still delegable in Power Apps?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
RobertLim 12 on at

Like (0)

Report

Thank you.

Was this reply helpful? Yes No