Delegation warning for gallery filter

(0) Share

Report

Posted on by Sifu

834

Hi all,

having an issue i cant work out... which part is causing the delegation problem and what would be the alternative?

here is what I use:

DropdownAvailableTime, items: [ "0", "<2", "<4" ]

ExpectedFinishDate, column in SPO, Date

in the filter I include following, which works but causes also delegation problem:

If(
DropdownAvailableTime.Selected.Value = "0", Value(ExpectedFinishDate - Today()) =7,
DropdownAvailableTime.Selected.Value = "<2", Value(ExpectedFinishDate - Today())<=14,
DropdownAvailableTime.Selected.Value = "<4", Value(ExpectedFinishDate - Today())<=28
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sifu,

The If function itself cannot be delegated and is likely causing the warning.
Could you alternatively use And and Or directly in your filter formula, e.g.
Or(And(DropdownAvailableTime.Selected.Value = "0", Value(ExpectedFinishDate - Today()) =7),And(DropdownAvailableTime.Selected.Value = "<2", Value(ExpectedFinishDate - Today())<=14),...)?

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!
not getting now delegation error and even returns some values but always only the lowest ...below 7 days 😕

(IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "0" Or ( ExpectedFinishDate - Today() ) <= 7), (IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "<2" Or ( ExpectedFinishDate - Today() ) <= 14), (IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "<4" Or ( ExpectedFinishDate - Today() ) <= 28)

Was this reply helpful? Yes No
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Sifu,

I think you would have to include an AND operator in your formula.
For example,
(IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or And(DropdownAvailableTime.Selected.Value = "0", ( ExpectedFinishDate - Today() ) <= 7))
Probably only the first part of your filter criteria is evaluated, because a match is found. The IsBlank and IsEmpty criteria are in every part of your filter, this might be the reason.
I imagine that what you posted above is only part of the complete formula. Could you share the complete formula and provide some background?

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!
full story
Filter( 'Program Management', //plant filter IsBlank(DropdownPlants.Selected.Result) Or IsEmpty(DropdownPlants.Selected.Result) Or Plant = DropdownPlants.Selected.Result, //status filter IsBlank(DropdownStatus.Selected.Result) Or IsEmpty(DropdownStatus.Selected.Result) Or StatusReport = DropdownStatus.Selected.Result, //project type IsBlank(DropdownProjectType.Selected.Result) Or IsEmpty(DropdownProjectType.Selected.Result) Or ProjectType.Value = DropdownProjectType.Selected.Result, //product division IsBlank(DropdownProductDivision.Selected.Result) Or IsEmpty(DropdownProductDivision.Selected.Result) Or ProductDivision = DropdownProductDivision.Selected.Result, //product group IsBlank(DropdownProductGroup.Selected.Result) Or IsEmpty(DropdownProductGroup.Selected.Result) Or ProductGroup = DropdownProductGroup.Selected.Result, //priority IsBlank(DropdownPriority.Selected.Result) Or IsEmpty(DropdownPriority.Selected.Result) Or Priority.Value = DropdownPriority.Selected.Result, //sesarch of Project ID IsBlank(SearchID.Text) Or IsEmpty(SearchID.Text) Or ID = SearchID.Text, //available time (IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "0" Or ( ExpectedFinishDate - Today() ) <= 7), (IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "<2" Or ( ExpectedFinishDate - Today() ) <= 14), (IsBlank(DropdownAvailableTime.Selected.Value) Or IsEmpty(DropdownAvailableTime.Selected.Value) Or DropdownAvailableTime.Selected.Value = "<4" Or ( ExpectedFinishDate - Today() ) <= 28) )

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

btw. delegation issue is here as well... although it filters only in one case...

Was this reply helpful? Yes No
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hm, I thought the delegation error was gone?
Regarding the filtering criteria: I think the last three lines (after //available time) are causing the issues. Based on the if formula you posted initially, I would assume that you would have to include some AND operators.
The equivalent of your if formula should be something like
Or(And(DropdownAvailableTime.Selected.Value = "0", Value(ExpectedFinishDate - Today()) =7),And(DropdownAvailableTime.Selected.Value = "<2", Value(ExpectedFinishDate - Today())<=14),And(DropdownAvailableTime.Selected.Value = "<4", Value(ExpectedFinishDate - Today())<=28))

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

no idea, but still not working and with delegation warning... 😞

Was this reply helpful? Yes No