Unanswered

Delegation Warning

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have a formula (below) to show the number of tickets in a sharepoint list that matches the value that has been selected in a drop down list. This has now exceeded 2000 so i'm only seeing the result of 2000. How am I able to see beyond 2000 please?

CountRows(
 Filter(QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value))

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Dave-ITMan

Take a look at @WarrenBelz 's blog Practical PowerApps under Delegation for several work arounds. Which one to use depends on the ultimate size of the list.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @Dave-ITMan and thanks for the tag @Drrickryp ,

This may assist by "pre-filtering"

With( { wData: Filter( QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value ) }, CountRows(wData) )

so up to 2,000 rows resulting from the filter can be counted (but CountRows in itself is not Delegable and cannot count more than this).

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
Dave-ITMan on at

Like (0)

Report

Hi @WarrenBelz and @Drrickryp thank you for the response.

Basically, the screen that I have is like a dashboard to count certain required options from dropdown lists (see attached image), each of these will eventually grow above 2000 records which as you can see that one already has. I've used your recommended code for the one over 2000 records which has removed the delegation warning, what would be my best way to actually view the total figure in this scenario so that my users can see exactly how many have been reported?

Appreciate the help

dashboard.JPG

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @Dave-ITMan ,

If you have a filter that outputs more than 2,000 rows, the CountRows() on this output will not work. There are some other workarounds - for instance if you had another column that had a small number of possible values (example 3) and none of these combined with the main filter had more than 2,000 records

With( { wData1: Filter( QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value && YourTextField = "A" ), wData2: Filter( QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value && YourTextField = "B" ), wData3: Filter( QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value && YourTextField = "C" ) }, CountRows(wData1) + CountRows(wData2) + CountRows(wData3) )

Was this reply helpful? Yes No