Problem with filtering based on multiple conditions

[Z_Lukowski]

Hello,

I have Data table (Badges) and  2x Listbox

In datatable items Im filtering based on:

Filter('Badges',Name in ListBox1var)     listbox1var is onSelect argument from listbox1

when I filter based on this formula, it works fine: 

But when trying to add second condition it fails:

Filter('Badges',Name in ListBox1var And 'Badges',SubTitle in listBox2var)

[gabibalaban · Accepted solution]

Hi @Z_Lukowski,

Try:

Filter('Badges',Name in ListBox1var && SubTitle in listBox2var)

Hope it helps !