Filter Gallery with multiple Checkboxes (boolean)

[SalvoTr]

Hi, 

I have an App that stores potential Interviewees in a MS SQL Server database.

In the SQL database we collect peoples' names and their availability (which day of the week & during which time of the day --> as booleans) 

Now, I represent the data in a Gallery & want to filter people using a searchbar (which already works).

However, I am stuck at the following:

- The database has 9 boolean values (avail_monday, ..., avail_friday, avail_morning, ..., avail_evening)

- I want to have a checkbox for each weekday & each time-range (e.g. morning, noon,..) so that it filters exactly what person is when available

I have tried a lot of possibilities but I haven't figured it out

Also wanted to try with a combobox but I don't know how I would implement it..

this does not work (and neither with "And")

Thank you in advance!

[NurSabrina24]

Hi, 

Sorry, but could you provide some screenshots for the steps of your app. Few pictures might help you if they understand from your picture. 

[SalvoTr]

This is what the gallary looks like: 

I want these Checkboxes to be functional (they are currently not) 

For instance, if I check the box "Montag" I want to see all people that are available on monday (--> all entries in the SQL database that have avail_mo=true)

[SalvoTr]

Hi Sabrina, I replied to my comment with a screenshot. Hope it's clearer 🙂

[NurSabrina24]

Hi,

How about you try to follow these two or either one? It kind of similar to yours..

Filter gallery through checkboxes - Power Platform Community (microsoft.com) 

or this,

Solved: Filter Gallery from multiple checkbox - Power Platform Community (microsoft.com)

post - credit to owner 

[v-jefferni · Accepted solution]

Hi @SalvoTr ,

The logic for your scenario will quite complicated if you think with a positive mindset, but imagine think with the negative mindset, that is, to exclude items those not meet the checked values, things seemed to be more clear.

So the function would be:

Filter(
    SQLTable, 
    If(
        Montag_Checkbox.Value = true, 
        Not(avail_mo = false)
    ) && 
    If( 
        Dienstag_Checkbox.Value = true, 
        Not(avail_tu = false)
    ) && 
    If(
        Mittwoch_Checkbox.Value = true, 
        Not(avail_we = false)
    ) && 
    ...
)

Hope this helps.

Best regards,