Edit

Share via

Paging

  • Article

Provides properties and methods to work with paging.

Available for

Model-driven and canvas apps

Properties

firstPageNumber

First page number.

Type: number

hasNextPage

Whether the result set can be paged forwards.

Type: boolean

hasPreviousPage

Whether the result set can be paged backwards.

Type: boolean

lastPageNumber

Last page number.

Type: number

pageNumber

Page Number. Same as firstPageNumber. Used in exposed interfaces where firstPageNumber and lastPageNumber is not available.

Type: number

pageSize

The pageSize of the paging.

Type: number

totalResultCount

Total number of results on the server for the current query. In case when value is not available -1 is sent.

Type: number

Note

For Canvas Apps totalResultCount will not always show the total number of records a table has. Because of delegation, it will return a value divisible by 500 until the last set of records is reached.

Let's say that a table has 1022 records in it. Your page size is 100. The following table shows the totalResultCount value you can expect for each page:

Page Value
1 500
2 500
3 500
4 500
5 500
6 1000
7 1000
8 1000
9 1000
10 1000
11 1022

Methods

Method Description
loadExactPage Request the exact page of results to be loaded.
loadNextPage Request the next page of results to be loaded.
loadPreviousPage Request the previous page of results to be loaded.
reset Reload the results from the server, and reset to page 1.
setPageSize Sets the number of results to return per page on the next data refresh.

Limitations

Note

loadExactPage, loadNextPage, loadPreviousPage do not support parallel execution. Executing any of them will trigger updateView on the control with newly fetched results.

Power Apps component framework API reference
Power Apps component framework overview
Data source delegation limitations