Many checkboxes to filter gallary (SQL Server)

[SalvoTr]

Hello, 

I have a tool that should filter people (stored in SQL Server) based on their availability.

As you can see, there are many checkboxes (stored as boolean in the DB) that can be selected to narrow down the search

I have looked at so many solutions but was not able to get this to work

This is the database:

Thank you for your help

[v-bofeng-msft]

Hi @SalvoTr ,

Please try:

Filter(
  YourDataSource,
  first_name=TextInput.Text &&
  avail_mo=If(MoCheckBox.Value,1,0) &&
  avail_tu=If(DiCheckBox.Value,1,0) &&
  avail_we=If(MiCheckBox.Value,1,0) &&
……
)
  

Best Regards,

Bof

[SalvoTr]

Hi @v-bofeng-msft 

I greatly appreciate your help.

I tried both of these codes and none will work for some reason and I don't understand why.

The gallary simply remains empty. 

Filter(
mafo_interview_contacts;
avail_mo=If(Montag_Checkbox.Value;true;false) ||
avail_tu=If(Dienstag_Checkbox.Value;true;false) ||
avail_we=If(Mittwoch_Checkbox.Value;true;false) ||
avail_th=If(Donnerstag_Checkbox.Value;true;false) ||
avail_fr=If(Freitag_Checkbox.Value;true;false) ||
avail_morning=If(Morgen_Checkbox.Value;true;false) ||
avail_noon=If(Mittag_Checkbox.Value;true;false) ||
avail_afternoon=If(Nachmittag_Checkbox.Value;true;false) ||
avail_evening=If(Abend_Checkbox.Value;true;false) 
)


Filter(
mafo_interview_contacts;
avail_mo=If(Montag_Checkbox.Value;true;false) &&
avail_tu=If(Dienstag_Checkbox.Value;true;false) &&
avail_we=If(Mittwoch_Checkbox.Value;true;false) &&
avail_th=If(Donnerstag_Checkbox.Value;true;false) &&
avail_fr=If(Freitag_Checkbox.Value;true;false) &&
avail_morning=If(Morgen_Checkbox.Value;true;false) &&
avail_noon=If(Mittag_Checkbox.Value;true;false) &&
avail_afternoon=If(Nachmittag_Checkbox.Value;true;false) &&
avail_evening=If(Abend_Checkbox.Value;true;false) 
)

 (had to do some necessary adjustments --> semicolon and true/false)