Power Apps

Answered

Delegation issues without Delegation Warning

(0) Share

Report

Posted on by unislacker

Hi All

So I have a strange Delegation issue without any warnings.

So I have a Clear Collect Here in the onvisable for the page

ClearCollect(StatusFilter,Filter('LC Sprint Planning ',Or(Status.Value="Not Started",Status.Value="In Progress",Status.Value="Done")))

And I then Have My gallery filter here (The if is to cycle between looking at Department lists or Project Lists)

If(

DeptProj = "true",

Filter(

StatusFilter,

(Status.Value = Dropdown4_2.Selected.Value || If(

Dropdown4_2.Selected.Value = "All Status",

true,

false

)) && (Departments.Value = Dropdown1_1.Selected.Result || If(

Dropdown1_1.Selected.Result = "All Projects",

true,

false

)) && ('Sprint Number' = Dropdown4_3.Selected.Result || If(

Dropdown4_3.Selected.Result = "All Sprint Numbers",

true,

false

)) && ('Action Owner'.DisplayName = Dropdown3.Selected.Result || If(

Dropdown3.Selected.Result = "All Action Owners",

true,

false

))

Filter(

StatusFilter,

(Status.Value = Dropdown4_2.Selected.Value || If(

Dropdown4_2.Selected.Value = "All Status",

true,

false

)) && ('Project Lookup'.Value = Dropdown1_2.Selected.Result || If(

Dropdown1_2.Selected.Result = "All Projects",

true,

false

)) && ('Sprint Number' = Dropdown4_3.Selected.Result || If(

Dropdown4_3.Selected.Result = "All Sprint Numbers",

true,

false

)) && ('Action Owner'.DisplayName = Dropdown3.Selected.Result || If(

Dropdown3.Selected.Result = "All Action Owners",

true,

false

))

)

But not showing any delegation warnings, but there is def one present is im getting a difference in the returned results when on 500 as opposed to 2000 limt .

My lists will grow so i need to sort this soon.

Thanks for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@unislacker
Using SharePoint a single ClearCollect function will only pull in AT MOST 2000 records. The best way to get around delegation is to use galleries the point directly at the List then use filtering on the gallery to find records you wish to work in.

Reza Dorrani has a great YouTube series on SharePoint and Delegation that's well worth watching.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@unislacker

ClearCollect pulls only 2,000 records.

Also, IF statements cannot be delegated inside FILTER functions. Do not use them.

Instead of doing this...

(Status.Value = Dropdown4_2.Selected.Value || If( Dropdown4_2.Selected.Value = "All Status", true, false ))

Do this...

(Status.Value = Dropdown4_2.Selected.Value || Dropdown4_2.Selected.Value = "All Status" )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No