Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Sum nondelagable for SharepointList

Hi everyone,

my company has license of office 365 and I created a simple Powerapps survey form based on sharepoint list.

unfornately after reading about delegation, Sum/ Count function is not delegable for sharepoint data source...

Is there any  other workaround?

Currently only SQL server seems to be delegable for SUM function but I have never learnt to create it before and I dont know if it cost extra...

thanks for your kind attention

Resolver II
Resolver II

There are probably people that can help, but you'll have to provide more information about how your app works and what you're trying to sum/count. Just for reference, I'm providing a link to Microsoft SQL Express, which is free. There are several free versions of SQL server out there if you search, but I have a feeling SQL may be overkill for what you wish to accomplish.




Thanks for your reply,


I will provide more detail:

- My app is a survey form for people to  collect information about potential customers (similar to a census)

- The data will be large , each person will have over 1000 data point and counting ...

- I want to countrows to see how many number of customer that each person has surveyed (shown on their phone by filter username). And also SUM the potential revenue for each of those customers.



Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,125)