Hi @dave-jorgensen1 :
Unfortunately, this is not a bug.Accourding to documentation:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
Counting functions such as CountRows, CountA, and Count can't be delegated.
If you nee CountRows to be delegabe,I suggest you post your suggestion in this forum:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
In addition,I have some alternatives to circumvent the delegation problem:
Solution1:Use calculation functions
If your entity has a required numeric field, you can use the following formula to calculate the number of items:
Sum(EntityA,NumberFiled)/Average(EntityA,NumberFiled)
Solution2:Use Collect() to save records into a collection in batches (less than 2000 each time), and then use countrows() to calculate the number of records in the collection.For example:
suppose you are collecting data from several areas and that each area you never collect over 2k records.
1\Add a button and set it's OnSelelct property to:
Clear(TheCollection);
Collect(TheCollection,Filter(yourentity,area="A"));
Collect(TheCollection,Filter(yourentity,area="B"));
Collect(TheCollection,Filter(yourentity,area="C"));
2\Using CountRows to get the number of rows
CountRows(TheCollection)
Best Regards,
Bof
