PowerApps控件是否内置分页？百万行数据场景下Gallery控件如何处理？

Hey there! Let's clear up how pagination works with PowerApps' Gallery controls, especially when you're dealing with a massive dataset like a 1-million-row table.

内置的自动分页行为 #

First off, the Gallery control does have built-in lazy loading (automatic pagination) by default—it won't try to load all 1 million rows at once. Instead, it only fetches the rows that fit in the current view, plus a small buffer for smooth scrolling. As you scroll down, it pulls more data from the source on-demand, rather than loading everything upfront.

A quick caveat: this automatic behavior depends on your data source. For official sources like Dataverse, SharePoint Lists, or SQL Server, PowerApps leverages the source's native pagination capabilities to handle incremental loading. But if you're using a custom data source (like a third-party API that doesn't support pagination out of the box), this automatic magic might not work.

When you need to handle pagination manually #

There are scenarios where you'll want to build custom pagination logic:

• Your data source doesn't support PowerApps' automatic incremental loading (e.g., a custom connector without configured pagination parameters)
• You need precise control over page size, or want explicit "Previous"/"Next" buttons instead of relying on scroll-based loading
• You're working with complex filters/sorting that the automatic pagination can't accommodate cleanly

Here's a quick outline of how to implement manual pagination:

• Use variables to track the current page (varCurrentPage) and page size (varPageSize), e.g., Set(varPageSize, 20); Set(varCurrentPage, 1)
• Use the Skip() and Take() functions to slice your data source:

  Gallery.Items = Skip(YourDataSource, (varCurrentPage - 1) * varPageSize) |> Take(varPageSize)
  

• Add buttons to navigate pages: for "Next Page", use Set(varCurrentPage, varCurrentPage + 1) (with a check to make sure you don't go beyond the total number of pages), and similar logic for "Previous Page".

内容的提问来源于stack exchange，提问作者Thomas Segato