CountIf Sharepoint List delegation workaround

[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?

[Pstork1 · Accepted solution]

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]

@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]

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!