cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rianne1
New Member

How to solve delegation issue of filter with conditions?

Hi all,

 

Still new to Power Apps, and couldn't quite google myself out of this issue.

I have a gallery that I want to filter on partner name using text input, and using a toggle for optional inclusion of completed items.

By default the completed items are hidden.

Below code on items of BrowseGallery1 is working as intended, but has a delegation risk.

 

If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' <> "Completed",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',

StartsWith('Partner Name',TextSearchBox1.Text)))

 

Who can help me solve this?

 

Many thanks!

Rianne

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

@Rianne1 

Assuming that SharePoint is your data source, the problem is that the <> is not delegable.

There's no simple workaround except to use the = operator and to specify all the other status types other than "Completed".

If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' = "Started" || 'Demand Status2' = "In Progress" || 'Demand Status2' = "etc..",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',

StartsWith('Partner Name',TextSearchBox1.Text)))

View solution in original post

2 REPLIES 2
timl
Super User
Super User

@Rianne1 

Assuming that SharePoint is your data source, the problem is that the <> is not delegable.

There's no simple workaround except to use the = operator and to specify all the other status types other than "Completed".

If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' = "Started" || 'Demand Status2' = "In Progress" || 'Demand Status2' = "etc..",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',

StartsWith('Partner Name',TextSearchBox1.Text)))
Rianne1
New Member

@timl That was an easy fix, thank you!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,746)