Power Platform Community Forum Thread Details

Hi All ,

I have 10000 rows in my sharepoint list containing 6 to 8 columns I want to fetch the data in power apps but the rows are calculating the sum of one of y columns.

Suppose I have 2 column , Project,Employee, Total Hours, Week.

In Power Apps

1.I want to fetch the data and to show them individually.

2. I want to summarize the TOTAL HOURS BY PROJECT per week.

3.The performance of my app should not get affected.

Please provide some solutions. Thanks in advance

Categories:

Dataflows

Hi @AR-23070514-0,

A bit of a wish list there. Firstly, "fetching" to display them in a gallery can be done with a Delegable query if the user wants to scroll down enough times, however once you start summarising using "local" functions such as Sum, GroupBy and AddColumns, which you will need for what you have described, then the total number of records you can address with a Delegable query is limited to your Data Row Limit, which is a maximum of 2,000.

There are two paths you can take - the first if there are no more than 2,000 records per project records (and you set your Data Row Limit to this and have a drop-down wiht a list of the Projects (you will need to maintain another list with these), then you would do something like per project

With(
   {
      _Data:
      Filter(
         SPListName,
         Project = YourProjectDropdown.Selected.Project
      )
   },	  
   GroupBy(
      AddColumns(
         _Data,	
         WeekNumber,
         WeekNum(YourDateField)
      ),
      WeekNumber,
      Grouped
   ),
   TotalHours,
   Sum(
      Grouped,
      YourHoursField
   )
)

The other is doing a big collection - I have a blog on this process (where you are going to need an additional column) and then you can summarise as per the code below, This will definitely substantially affect performance, both in the gathering of the colleciton and generating the end data.

AddColumns(
   GroupBy(
      AddColumns(
         YourColleciton,
         WeekNumber,
         WeekNum(YourDateField)
      ),
      Project,
      WeekNumber,
      Grouped
   ),
   TotalHours,
   Sum(
      Grouped,
      YourHoursField
   )
)

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn