Filter gallery by multiple buttons

[MalyMajo]

Hello all,

I have a gallery with billing tracker, which I would like to filter based on "quick" filters - buttons below the gallery.

In buttons I have set 2 boolean context variables filterOpen (for not sent invoices) and filterMyRequests to filter only requests by current user. Buttons Onselect properties are set as following:

UpdateContext({filterOpen: !filterOpen})

UpdateContext({filterOpen: !filterOpen})

I am struggling with setting the Gallery Items to show correct result. Below code is bet what I got, but it does not work as expected. When I select only one button, it works. But when I select both, result is whole table 

Filter(
    colBillings,
    If(
        filterOpen,
        DocumentStatus <> "Sent"
    ) || If(
        filterMyRequests,
        varUser.Email = RequestedBy.Email
    )
)

[Nogueira1306]

See if this helps:

https://www.youtube.com/watch?v=SJqbYa8Tqpk&t=58s

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!