web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Question about 2000 ro...
Power Apps
Unanswered

Question about 2000 row limit and a filtered gallery

(0) ShareShare
ReportReport
Posted on by 437 Super User 2024 Season 1

If I create a gallery with filters on each column and, as the user applies values to those filters, will they get:

 

1. A filtered list from the first 2000 records?  Or....

2. A filtered list that includes up to 2000 records (but may include records beyond the first 2000 in the data source)? 

Categories:
  • jrletner Profile Picture
    720 Moderator on at

    Assuming you are not receiving Delegation Warning messages, the Gallery will contain as many rows as is in the datasource (based off of the filtered values). The Gallery will display the rows in increments of 100. So as you scroll past the first 100 records, the second 100 records will be loaded.

    However, if you are receiving Delegation Warnings, and in your app settings you have set the Delegation Limit to 2000 records, then when you filter your Gallery, the first 2000 rows from your datasource are loaded into the Gallery, and the filtering will only occur on those 2000 records.

    See the documentation on Delegation Warnings here:  Understand delegation in a canvas app - Power Apps | Microsoft Learn

  • FishinKmac Profile Picture
    75 on at

    Is your datasource SharePoint?

    If so, you should be pulling in 2000 items of that filtered data. So it will pull the first 2000 items that meet that criteria.

     

    I would suggest pulling in the data using collections where possible if you need more than 2,000 items. For example, I have a list of 5500 items, but i want to make sure i pull in everything to our request app so the admins can see it all. So I put:

    //Collects data from the list in smaller collections

    Concurrent(

    ClearCollect(colActive, Filter(Requests, Status.Value="Active")), 

    ClearCollect(colInProg, Filter(Requests, Status.Value="In Progress")), 

    ClearCollect(colOnHold, Filter(Requests, Status.Value="On Hold")), 

    ClearCollect(colComplete, Filter(Requests, Status.Value="Complete")));

    //Puts all of the smaller collections into one big collection

    ClearCollect(

             colAllReqs, 

                        colActive,

                        colInProg, 

                        colOnHold, 

                        colComplete)

     

    Your items in the gallery would be the colAllReqs 

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard