Unanswered

Delegation warning in filter search

(0) Share

Report

Posted on by evanscona

Hi Community, i need help with following filter functions. I applied a filter functions to an app am creating, but keep getting delegation warning. Please can anyone look at it and help? Thanks.

SortByColumns

( Filter(DaEmp, StartsWith(Title, TextInput101.Text)

|| StartsWith(Review, TextInput101.Text),

IsBlank(Dropdown123.Selected.Value)
|| IsEmpty(Dropdown123.Selected.Value)
|| Shift = Dropdown123.Selected.Value,
Date >= DatePicker125.SelectedDate && Date <= DatePicker126.SelectedDate
&&
IsBlank(Dropdown124.Selected.Value)
|| IsEmpty(Dropdown124.Selected.Value)
|| Placement = Dropdown124.Selected.Value,
Date >= DatePicker125.SelectedDate && Date <= DatePicker126.SelectedDate

),"ID", Descending
)

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @evanscona .

I have done a bit of bracketing and consolidation in the below, but your original should be Delegable - where are the "blue lines" showing the warning ? You also repeated the date filter

SortByColumns( Filter( DaEmp, ( StartsWith( Title, TextInput101.Text ) || StartsWith( Review, TextInput101.Text ) ) && ( Len(Dropdown123.Selected.Value) = 0 || Shift = Dropdown123.Selected.Value ) && Date >= DatePicker125.SelectedDate && Date <= DatePicker126.SelectedDate && ( Len(Dropdown124.Selected.Value) = 0 || Placement = Dropdown124.Selected.Value ) ), "ID", Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
evanscona 65 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz the redlines are showing on the Dates, I attached screenshot
WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@evanscona ,

I was simply using your code assuming it to be valid values - it appears that Date (not a good name for a field anyway) is not a valid reference.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @evanscona ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps