CountIf Sharepoint List delegation workaround

(0) Share

Report

Posted on by mminervini

I have a Sharepoint list with a column "Status" that is either "In Process" or "Completed".

I want to return the number of "In Process" records.

CountIf(MySPList, Status="In Process")

The issue I run into is my list has grown larger than the non-delegable limit.

I tried to sort my SP List by created date, thinking PowerApps will look at the newest records only and ignore the older ones (assuming my oldest records are all marked as "Complete" now and I dont care about counting those)

But that did not seem to do the trick.

How do I get PowerApps to only Count the newest records in my SP List to workaround the delegation limit?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(3)

Report
Copy link

Link copied!
If the number of In Process records will stay below the data row limit, you could do this by pre-filtering the list based on Status using this formula

CountRows(Filter(MySPList, Status="In Process"))
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(6)

Report
Copy link

Link copied!
@mminervini

In addition to @Pstork1 's suggestion (which will still give you a delegation warning), you can also use a formula like this:

Len(Concat(Filter(MySPList, Status="In Process"), "X"))

Also, to add to @Pstork1 's suggestion. It is interesting that PowerApps provides a warning for that formula, yet this one does not:

With({ds:Filter(MySPList, Status="In Process"))}, CountRows(ds) )

I hope this is helpful for you.
mminervini 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Duh! Should have realized I could just pre-filter...
I actually have filtered galleries within the same app so my solution looks more like this:
CountRows(Gallery1.Allitems)
Thanks for the help!
luizhr 112 on at

Like
a
(2)

Report
Copy link

Link copied!

Worked for me, thanks 😀 ! I used this formula: Len(Concat(Filter(MySPList, Status="In Process"), "X"))