Toggle filter

[roncam]

I have a gallery filter with items = SortByColumns(Filter(Clients, StartsWith(Title,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

the above is working and it gives me all the projects but now I need to add a toggle filter so that from the above result I filter again if the projects are assigned.

can you help me on how to do it please ?

thanks

[dinusc]

Hello @roncam,

I assume you want to add a new filter by changing the value of a toggle control. Let's assume that you also want to filter by "Heading" using the value from TextInput2. In this case you can modify your formula as following:

SortByColumns(Filter(Clients, If(Toggle1.Value=true, StartsWith(Title,TextSearchBox1.Text), StartsWith(Heading,TextSearchBox2.Text))), "Title", If(SortDescending1, Descending, Ascending))

[roncam]

what settings I need to put into the toggle please ?

[roncam]

my IsAssigned? a calculated formula column returning Yes or No

[Drrickryp]

The filtering is done in the items property of the gallery.

SortByColumns(Filter(Clients, If(Toggle1.Value=true, StartsWith(Title,TextSearchBox1.Text)
 && IsAssigned=“Yes”,StartsWith(Title,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

[dinusc]

In this case you can use this:

SortByColumns(Filter(Clients, If(isAsigned="Yes", StartsWith(Title,TextSearchBox1.Text), StartsWith(Heading,TextSearchBox2.Text))), "Title", If(SortDescending1, Descending, Ascending))

Please double check the value in your "IsAssigned" column to ensure it is really "Yes" and "No" and adjust the formula accordingly.

[roncam]

instead of the TextSearchBox2.Text can i have a toggle switch for yes or no ?

[dinusc]

Do you mean that you want to filter by a column (Heading in my example) that contains true/false values? If so then something like the following should work:

SortByColumns(Filter(Clients, If(isAsigned="Yes", StartsWith(Title,TextSearchBox1.Text), Heading = Toggle1.Value))), "Title", If(SortDescending1, Descending, Ascending))

[roncam]

the column is a calculated column returning Yes or No.

I have the searchbox searching in the title but then i have a toggle switch that i want to filter again the search on if it is assigned or no

[dinusc]

Is this what you're looking for?

SortByColumns(Filter(Clients, If(Toggle1.Value=false, StartsWith(Title,TextSearchBox1.Text), Lower(isAsigned)="yes", "Title", If(SortDescending1, Descending, Ascending))

If no then can you please provide the respective column names along with types?

Thank you