Radio button filter, and Search on Gallery

[Anonymous]

I want to add radio button filter to my gallery. But dont know how to add it to Items of gallery, which already contains stuff for search.

Gallery Items: SortByColumns(Search([@'[dbo].[PaymentVaucher]'], TextSearchBox1.Text, "RequestedBy","AccountingApproval"), "ID", If(SortDescending1, Descending, Ascending))

Value for radio button that I want to add to Items of gallery: If(!IsBlank(Radio2.Selected.Value), Filter('[dbo].[PaymentVaucher]', AccountingApproval = Radio2.Selected.Value), '[dbo].[PaymentVaucher]')

How would I combine both together?

[timl · Accepted solution]

@Anonymous 

You should be able to combine the two formulas like so:

SortByColumns(Search(
              If(!IsBlank(Radio2.Selected.Value), 
                 Filter('[dbo].[PaymentVaucher]', 
                        AccountingApproval = Radio2.Selected.Value), 
                 '[dbo].[PaymentVaucher]'
              ), 
              TextSearchBox1.Text, 
              "RequestedBy","AccountingApproval"), 
              "ID", 
              If(SortDescending1, Descending, Ascending)
)