Combining Filter and Search!

[BenGillard]

I currently have this formula which works:
SortByColumns(Search(DS_FAQ,TextInput1_1.Text,"{Name}","Answer"),"Modified",Descending)

I am using a Global Variable to avoid the delegation warning.

Am i able to somehow combine something along the lines of the below filter to the above. I am struggling to make it work as one Formula.

DS_FAQ,Filter(FAQ,!IsBlank(Answer))

Thanks in advance

[timl · Accepted solution]

Hi @BenGillard

I think something like this should work for you:

SortByColumns(
              Search(Filter(DS_FAQ, !IsBlank(Answer)),
                     TextInput1_1.Text, 
                     "Answer",
                     "{Name}"
              ),
              "Modified",
              "Descending"
)

If not, let us know what error you get.