web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort and Filter Multip...

Power Apps

Answered

Sort and Filter Multiple options Delegation Warning

(0) Share

Report

Report

Posted on by ptempleton

65

I have a gallery that I am wanting to filter based on information selected from 2 date pickers and a text box. I am receiving a delegation warning and I am close to the 2000 limit. Below is my formula.

Sort(Filter(KPUnblocks, ('Created On'-1 >= StartDate.SelectedDate) && ('Created On'-1 <= EndDate.SelectedDate) && (ItemFilter.Text in ItemNumber)),'Created On',Descending)

Does anyone have any suggestions on how I can get around the delegation? It is complaining about the Ands and 'Created On' sections.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

DylanSimons 326 on at

Like
a
(1)

Report
Copy link

Link copied!
subtracting 1 from the 'Created on' field is not delegable. You should do the manipulation to the variable in Power Apps rather than the field in your source.

Also, I assume you are subtracting 1 day? you can change it to this:

Sort(Filter(KPUnblocks, ('Created On' >= DateAdd(StartDate.SelectedDate), 1, Days) && ('Created On' <= DateAdd(EndDate.SelectedDate, 1, Days)) && (ItemFilter.Text in ItemNumber)),'Created On',Descending)

You also have the "In" operator, which is unfortunately non-delegable with Sharepoint(I assume that is what you are using).

The only way I see this being resolved is using a collection, so in App OnStart you can do

ClearCollect(MyCollection, KPUnblocks)

and then use MyCollection for all your needs in the Power App.
ptempleton 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! I am using CDS as the source and this fixed my delegation warning.

Sort(Filter(KPUnblocks, ('Created On' >= DateAdd(StartDate.SelectedDate, 1, Days)) && ('Created On' <= DateAdd(EndDate.SelectedDate, 1, Days)) && (ItemFilter.Text in ItemNumber)),'Created On',Descending)

Join the conversation