Filtering on multiple fields

[RussellGove]

Hi ,

I have a gallery and i'm trying to give users several ways to filter it. I have controls above the gallery to let the user select a Year, region, customer or keyword to filter on. I want to use only the filters the user has selected. 

My script ends up looking like this (this represents just the conditions, not the actual filters):

After adding the actual filtering logic for each condition (and god forbid an other condition) this ends up being hundreds of lines of script that are largely incomprehensible, even to the author!

Is there a better way to do this?

What we really need is a real code editor! If i could edit this script in an intelligent VSCode editor I'd have this done in minutes. The way it is it's taking days!

Please give me back my curly braces!

[mdevaney · Accepted solution]

@RussellGove 

Here's my pattern for filtering on multiple fields.  Put this code in the Items property of your gallery.

Filter(
    FPARequests,
    If(
        IsBlank(tbYear.Text),
        true,
        Year = tbYear.Text
    ),
    If(
        IsEmpty(cbxRegion.Selected),
        true,
        Region = cbxRegion.Selected
    ),
    If(
        IsBlank(tbCustomer.Text),
        true,
        Customer = tbCustomer.Text
    ),
    If(
        IsBlank(tbKeyword.Text),
        true,
        Keyword = tbKeyword.Text
    )
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[RussellGove]

Does that work with a sharepoint list?

[mdevaney]

Yes, it works with any datasource.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[RussellGove]

And can it be delegated?

[mdevaney]

@RussellGove
Yes.

[RussellGove]

I just get  a bunch of red squiggles when i paste in that code. Do you have a working example somewhere?

Can you explain how it works? I  don't see, for example, how it could possibly know what field in my datasource  should be compared with tbYear.Text

[mdevaney]

@RussellGove 

I've updated my code in the original post.  See below for response to your questions.

"I just get a bunch of red squiggles when i paste in that code"

I missed typing commas after "true" on each line.

"How it could possibly know what field in my datasource  should be compared with tbYear.Text"

I didn't put in this comparison initially as I did not see any in your original code.  I have now put in Year, Region, Customer and Keyword.  These names must match the column name in SharePoint.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[IvanZ]

Check out this video, it demo a fully multiple filtering gallery.

https://www.youtube.com/watch?v=pn50AKn3Q1Y&t=82s

[RussellGove]

Thanskyou. This saved me hours and hours of work trying to do all those nested ifs and elses.