web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to solve delegatio...

Power Apps

Answered

How to solve delegation issue of filter with conditions?

(0) Share

Report

Report

Posted on by Rianne1

6

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

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

timl 37,374 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@timl That was an easy fix, thank you!

Join the conversation