Hi, I am looking for help with filtering gallery with 2 toggle buttons . I am able to filter with 1 button but not able to add second to filter records for a different column. both the columns are yes/No type in same column
This filter works :
If(Toggle1.Checked,Filter(Mycollection,isRegistered='isRegistered (TableName)'.Yes),If(!Toggle1.Checked,Filter(Mycollection,isRegistered='isRegistered (TableName)'.No),Mycollection))
I want to add another filter to same gallery now using a diff toggle button and diff column but i am getting error when i use && to combine 2 queries.
If(Toggle2.Checked,Filter(Mycollection,isAssigned='isAssigned (TableName)'.Yes),If(!Toggle1.Checked,Filter(Mycollection,isAssigned='isAssigned (TableName)'.No),Mycollection))