Power Platform Community Forum Thread Details

Hello everyone,

I'm building an App with a Connection to Azure DevOps, where I get all the Work Items I need from a Query.

I have built an "Assigned to Me"-Filter, but the problem is that I can only apply the filter in the positive direction.

Means I can filter the gallery by Me but can't "clear" the filter so that I can see all Work Items from other users and unassigned Work Items.

Here is what the filter kinda looks like:

Filter(Condition1 And Condition2 And PlainText('System.AssignedTo') = If(Checkbox1.Value = true, User().FullName),...))

So what I can't figure out is the Else Case. If I just put "" in, I get an error and if I put Blank() in, I just get the unassigned Items.

(Condition1 and 2 are filter for status code etc.)

Long Story short, here my Question:

Is there a way to say "if last AND Case is false, just ignore it" or to clear just a part of a gallery filter?

Please don't hesitate to ask me if something is not understandable.

Thanks in advance!

Categories:

Clear Last/Current AND in Filter