Hii
I am using SharePoint list in making a management system with the list data of more than 5000. In which I am able to fetch the data and show them on my PowerApps but when it comes to implementation of the functions such as count, sum, average etc. in that part I am getting error of delegation. Can you help us in removing that error from my application.
Thank You
Sure, but I need to know the code you are using to help further. Please post it in a code window ie (</>) for me to have a look at
Hii EddieE
I have implemented the same code as you told in chat but it showing error in that. Can you please help me in other way.
@WarrenBelz
Sorry, was halfway through typing a response then saw that you had replied ... thought I'd reply anyway lol
@Satya121
As Warren says, these functions cannot be delegated to SharePoint. Another way around this is to use filtering. If, for example, your list has a column that stores data where filtering on this field will always return less than 2000 items, then you can do something like this.
Assume your field is called 'Region' and is of type Text:
With(
{
// note, each filter must return <2000 records for this method to work
wRegion1: Filter(ashish_5011, Region = "Region1"),
wRegion2: Filter(ashish_5011, Region = "Region2"),
wRegion3: Filter(ashish_5011, Region = "Region3")
},
Sum( wRegion1, 'Number of units') + Sum( wRegion2, 'Number of units') + Sum( wRegion3, 'Number of units') & "
Total Assets"
)
I cannot see your complete code (please post in Text), but if your question is whether you can Sum/Average/Count these in a Delegable manner, then the answer is that you cannot unless you start making big collections - I have a blog on this if it helps (please note the comment on Shadow ID Field in particular).
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps