Sneak Peek: Pagination Support in Power Apps SDK

[marcelbf]

Overview

We're excited to share a preview of pagination support coming soon to the Power Apps SDK! This feature enables efficient data retrieval for large datasets, providing developers with flexible query options and improved performance.

Current Implementation: Offset-Based Pagination

The initial release will include offset-based pagination through the enhanced IGetAllOptions interface. This approach gives you fine-grained control over data retrieval using familiar SQL-like concepts.

IGetAllOptions Interface

export interface IGetAllOptions {
  maxPageSize?: number;    // Maximum records per page
  select?: string[];       // Specify fields to return
  filter?: string;         // OData filter expression
  orderBy?: string[];      // Sort criteria
  top?: number;           // Limit number of records (page size)
  skip?: number;          // Offset for pagination
  count?: boolean;        // Include total record count
}

Supported Values & Examples

Property	Type	Description	Example
top	number	Limit records returned	top: 20 (get 20 records)
skip	number	Skip records (offset)	skip: 40 (skip first 40)
filter	string	OData filter expression	"contains(Name,'John')"
orderBy	string[]	Sort fields	["Name asc", "Date desc"]
select	string[]	Field selection	["ID", "Name", "Email"]
maxPageSize	number	Max page size limit	maxPageSize: 100
count	boolean	Return total count	count: true

Usage Example

// Get page 3 of filtered results (20 records per page)
const options: IGetAllOptions = {
  top: 20,
  skip: 40,  // Skip first 40 records (page 1 & 2)
  filter: "Status eq 'Active'",
  orderBy: ["CreatedDate desc"],
  select: ["ID", "Name", "Status", "CreatedDate"],
  count: true
};

const result = await BooksService.getAll(options);

Practical Pagination Implementation

// Page navigation helper
const getPage = (pageNumber: number, pageSize: number = 10) => ({
  top: pageSize,
  skip: (pageNumber - 1) * pageSize,
  count: true
});

// Get page 5 with 25 records per page
const page5 = await service.getAll(getPage(5, 25));

Looking Ahead: Cursor-Based Pagination 🔮

While offset-based pagination provides immediate value, we're also planning cursor-based (token) pagination for future releases.

Feedback Welcome!

We'd love to hear your thoughts:

• What pagination scenarios are most important for your applications?
• How do you envision using these query options in your workflows?
• Any specific OData filter patterns you'd like to see documented?
• What cursor-based pagination features would be most valuable?

What do you think? Are there specific pagination use cases you'd like us to prioritize? Let us know in the comments below! 👇

---

This feature is planned to be available by July 18th. API surface may change based on feedback.

[smedero]

Hi, can this feature be implemented? I'm trying to create a paginated list, and it would be very helpful. Thank you very much!

[marcelbf]

it is available already in with #62

[EstudiodeModaDev]

Hi, can this feature be implemented with sharepoint list?