Showing results for 
Search instead for 
Did you mean: 

Extend delegation to Sum and CountRows

Please extend delegation of Sum and CountRows for the basic datasources:

  • CDS
  • SQL Server
  • SharePoint

Many thanks.


Status: Planned
Level: Powered On

Delegation for countrows would be extremely useful. Is this planned for 2019 for CDS and/or SQL Server?

Level: Powered On

So this feature request is 2.5 years old...


Having the inability to do the equivalent of a "select count" SQL query is super frustrating.  At this point, I'm considering adding a "is_one" column to my tables where every row has an int value of 1, so I can use Sum() to count the rows, assuming I could still use delegation when nesting a Filter insde the Sum.


Any updates form Microsoft on this?

Level: Powered On

Hello, this issue has now been planned for almost three years. When will we see this actioned, please?

Level: Powered On

Do we have an ETA on this for SharePoint?  It looks like it's been PLANNED for over 2 years.  What good is it to release a PowerApps Service Desk template app that USES "CountRows" if it still has limitations?

Level: Powered On



Delegation warnings should go away if you try replacing CountRows with the following (replace "Data_Source" and "Formula" with your own):