Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Group by and count rows delegation

Posted on 19 Nov 2024 02:21:10 by 205
Hi all, I am trying to create a chart from a Sharepoint List with over 8000 records with the following query
AddColumns(GroupBy(Filter(Surveillance_1,'Surveillance Year'=2024,Compliance="No"),Site, Grouped),Count, CountRows(Grouped)),Count,",")
I would like to check if this filter is delegable as the below is the chart I get which has a total of more than 2000 rows (what I have set as my data row limit) but at the same time does not contain all the records in my Sharepoint list.
Categories:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 911 on 26 Nov 2024 at 20:58:23
    Group by and count rows delegation
    The fact that SharePoint connectors in Power Apps have delegation limits, and some functions in your query (e.g., Filter, AddColumns, GroupBy) are non-delegable. This means that only the first 2000 rows (default data row limit) are retrieved from SharePoint for processing, leading to incomplete data in your chart.
     
    query should look in Power Apps:
    AddColumns(
        GroupBy(
            Filter(Surveillance_1, 'Surveillance Year' = 2024 && Compliance = "No"),
            "Site", "Grouped"
        ),
        "Count", CountRows(Grouped)
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard