Delegation Limit for loading data more than 2000 rows.

(0) Share

Report

Posted on by ridhan

158

Hi All,

I have a Can vas application which is connect to SQL DB.

Issue- I have a combobox in which items property is below but it is loading the distinct class till row 2000. I have already increased the delegation limit to 2000 and also there is no delegation issue appearing on front end of combobox.

Items of combobox-- Distinct(vw_equipment_classification,class_description)

Any help is apprecaiated!

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ridhan -

based on your description, you might be misunderstanding how delegation works.

Power Apps does not retrieve all of your data, process it with non-delegable queries, and then return a maximum output of 2000 rows.

Power Apps retrieves the first 2000 records and then processes that smaller subset of data with your queries.

Despite the absence of a warning, the Distinct function is not delegable with SQL Server,

Further reading:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

https://learn.microsoft.com/en-us/connectors/sql/#power-apps-functions-and-operations-delegable-to-s...

Was this reply helpful? Yes No
Verified answer

ridhan 158 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik - Thanks for the explanation. I have used sql view now to avoid the delegation.

Was this reply helpful? Yes No