Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Count items Sharepoint List 20K



I have an SP list with 20 rows, and I want to make a table. In column 1 show all distinct values. And column 2 show the count of the rows with the condition in column 1.


the list item is more than 20K rows. Can I do this in powerapps?


thank you

Super User
Super User

hi @FrancoGR i think you have two challenges here, 1 performance issue with SharePoint and, 2 the GroupBy Function you need is not delegable.


You could have better performance with power automate if read large list from Sharepoint (have a look at this:


Consider an extra list where the output of flow is appending that list and use that list for your PowerApp - just a suggestion.


Hope it steers you into a solution.

Helper I
Helper I

@rubin_boer Thanks, but I think I passed delegation with an “auxiliar” gallery filtering the items I need. But now I have another question. How can I count all different items of the gallery in a table


thank you

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,039)