web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Non-delagable--First 5...

Power Apps

Answered

Non-delagable--First 500/2000? Last 500/2000? Or unknown?

(1) Share

Report

Report

Posted on by WillBeeSea

55

When running a non-delegable function in PowerApps, we know that the function will only work on 500 (up to 2000) records.

The question is does the function get to work on the first or last 500/2000 rows? Or is this a complete unknown? Or perhaps there is a way to write into the expression to use the first or last rows?

I imagine that the later records in a table are those that are the most recently entered/created, but if that is wrong please correct me.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

When a query is non-delegable, Power Apps only gets the first 500 records from the data source and then perform the actions in the query.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

To ensure that you are working with the most recent records, you can sort your data before applying the non-delegable function. For example, you can use the Sort or SortByColumns functions to sort your data in descending order based on a timestamp or ID column, ensuring that the most recent records are at the top.

Sort(IceCream, CreatedDate, SortOrder.Descending)

Was this reply helpful? Yes No

Join the conversation