You’re offline. This is a read only version of the page.
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?
Share
ReportCountRows(
Filter(QualityPortal, 'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value))Thanks in advance
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
All responses (
Answers (
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)
)
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
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
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
