Answered

Delegation warning when sorting dataverse table.

(0) Share

Report

Posted on by MuFeR

I got a gallery where I'm trying to sort a dataverse table based on a variable that holds the column name as a text.
This has worked across multiple apps/tables so far but in one specific table only i'm getting a delegation warning.
Ideally this is what i should have:

Even a more simplified version gives a delegation warning:

Meanwhile other tables even with AddColumns/Searching and extra stuff work just fine in every case:

I really can't figure out what's different for the table "Invoices" that creates the warning.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

When you use add columns it will create a local collection with 2000 itens or less, that's why you don't receive the delegation warning.

And as far as I know the only way to do that without get the delegation warning is creating a condition to check which column you are sorting and hardcode the columns, like this:

Switch(varSortByField, "Column1", Sort(Invoices,Column1), "Column2", Sort(Invoices,Column2), "Column3", Sort(Invoices,Column3), //...... Sort(Invoices,ColumnDefault) // Default )

I hope it helps 🙂

Was this reply helpful? Yes No
MuFeR 31 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Indeed that seems to be the case. So that actually means that I'm sorting the first 2000 filtered items and not the whole table?

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No