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

(1) Share

Report

Posted on by WillBeeSea

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 (1)

Answers (1)

Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (1)

Report
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