@moerah ,
Gallery content can be presented (in the background) in two ways.
Firstly a Delegable filter will return the records in batches of 100 (for performance reasons) with the subsequent batches queried as the user exposes the first record in the next set. This can accommodate any number of records as the user continues to scroll. The performance of this would be affected by mainly the quality of the internet connection, but also the complexity of the query.
For a non-Delegable query (I am assuming you have your Data Row Limit set to 2,000), the gallery will retrieve up to (the first) 2,000 records initially and then perform the query locally, with all scrolling then performed on a local data set that has been fully retrieved (so no batches to scroll through).
You can also (as you have mentioned) make a collection (limited to 2,000 records) and use that in the Gallery.
So the first question is regarding the Items of the Gallery and whether the query is Delegable.
The other issue you need to be aware of is that a Gallery linked directly to the data source (as distinct from a Collection) will automatically refresh if a record is changed, whereas a Collection will not.
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
