Answered

Trying to make it ITEMS delegable?!

(0) Share

Report

Posted on by jed76

I have a gallery which has a variety of different check boxes to apply various filtering. Can anyone suggest a way of making the following code delegable? If I remove the IF statements from inside the FILTER, it works fine:

Sort(
Sort(
Sort(
Filter(
CRUD_3,
If(
FilterBox_6months.Value = true,
(StartDate <= Today() - 180),
(StartDate >= Today() - 180)
),
If(
FilterBox.Value = true,
(TaskType = Value(Filter.Text)) || ProjectId=TxtSearchJob.Text,
TaskType <> Blank()
),
If(
FilterBox2.Value = false,
(TaskNo = 0 Or TaskNo = 3),
TaskType <> Blank()
),
Show = "true"
),
TaskNo,
SortOrder.Ascending
),
ProjectId,
SortOrder.Ascending
),
ProjectName,
SortOrder.Ascending
)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Delegation will depend on data source as they have different delegable functions in some case. Here is that info.
<> or not equal or Not() or ! are all non-delegable I believe.
Also system fields are non-delegable by default. This includes fields like Path, FullPath, Link, VersionNumber etc
Sort is non-delegable for SP when used with Complex column types

Im not sure this was a solution but hopefully the info helps
Verified answer

uwenagel 382 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess the source CRUD_3 is a SharePoint list, because there you receive delegation warnings.

A standard 'trick' is to add a column to the source table. This way the delegaton warning is normally gone:

Just like that (assuming that there is a column called TaskNo, but you can use any valid column name)
...
Filter(AddColumns(CRUD_3,"TASKS",TaskNo),
If(
...
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. It’s actually a Dataverse table but I am thinking that a SP list would probably do. So just that code you lost added to the top of my code will sort it for the date filters etc.? Many thanks.
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

OMG! I just added your 'trick' to before the filter and it worked!!! That's amazing. Thank you!!!