How to Implement Pagination in a Power Apps Screen

Overview

When a gallery shows hundreds or thousands of records on a single screen, the app becomes slow and harder to use. Pagination solves this problem by showing data in small chunks, such as 10 or 25 records per page. In this article, we will learn how to create Next / Previous / First / Last page buttons, show Page X of Y, and optionally add a Search + Page Size selector.

This approach works for:

• Dataverse

• SharePoint Lists

• SQL Tables

• Static Collections

Final Result (What We Are Building)

You will get a screen like this ↓

Prerequisites

• Basic knowledge of Power Apps Canvas App

• A gallery showing your data source

For better performance, we load data into a local collection and apply paging in the app.

Step 1. Add Controls to the Screen

Inside your screen:

Control	Name	Purpose
Gallery	galEmployees	Displays paged records
Button	btnFirst	Go to first page
Button	btnPrev	Go to previous page
Button	btnNext	Go to next page
Button	btnLast	Go to last page
Label	lblPager	Shows record count and page number
Dropdown	ddPageSize	Select page size (10, 25, 50)
(Optional) Text Input	txtSearch	Search filter
(Optional) Text Input + Button	txtJumpToPage, btnGo	Jump directly to page

Step 2. Initialize Variables (Screen OnVisible)

Select the Screen → OnVisible property and paste:

Set(PageSize, 10);
Set(CurrentPage, 1);

ClearCollect(colData, Employees); // Replace 'Employees' with your datasource

Set(TotalRecords, CountRows(colData));
Set(LastPage, Max(1, RoundUp(TotalRecords / PageSize, 0)));

Step 3. Gallery Items Formula (Pagination Logic)

Set galEmployees.Items:

FirstN(
    Skip(
        SortByColumns(colData, "ID", Ascending),
        (CurrentPage - 1) * PageSize
    ),
    PageSize
)

Step 4. Pagination Button Logic

Button	OnSelect Formula
First	Set(CurrentPage, 1)
Previous	If(CurrentPage > 1, Set(CurrentPage, CurrentPage - 1))
Next	If(CurrentPage < LastPage, Set(CurrentPage, CurrentPage + 1))
Last	Set(CurrentPage, LastPage)

Step 5. Page Size Dropdown

ddPageSize.Items

["10", "25", "50"]

ddPageSize.OnChange

Set(PageSize, Value(ddPageSize.Selected.Value));
Set(CurrentPage, 1);
Set(LastPage, Max(1, RoundUp(TotalRecords / PageSize, 0)));

Step 6. Pager Text Label

Set lblPager.Text:

With(
    {
        start: If(TotalRecords=0, 0, (CurrentPage - 1) * PageSize + 1),
        finish: Min(CurrentPage * PageSize, TotalRecords)
    },
    $"{start} – {finish} of {TotalRecords}  |  Page {CurrentPage}/{LastPage}"
)

Step 7. (Optional) Search + Pagination Together

txtSearch.OnChange

ClearCollect(
    colFiltered,
    If(
        IsBlank(txtSearch.Text),
        colData,
        Filter(colData, StartsWith(DisplayName, txtSearch.Text))
    )
);

Set(TotalRecords, CountRows(colFiltered));
Set(LastPage, Max(1, RoundUp(TotalRecords / PageSize, 0)));
Set(CurrentPage, 1);

Update gallery to use filtered collection if available:

FirstN(
    Skip(
        SortByColumns(
            If(CountRows(colFiltered)>0, colFiltered, colData),
            "ID",
            Ascending
        ),
        (CurrentPage - 1) * PageSize
    ),
    PageSize
)

Step 8. (Optional) Jump to Page

btnGo.OnSelect

If(
    IsNumeric(txtJumpToPage.Text),
    With({ p: Value(txtJumpToPage.Text) },
        If(p >= 1 && p <= LastPage, Set(CurrentPage, p))
    )
)