cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BenGillard
Level: Powered On

Combining Filter and Search!

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


Accepted Solutions
Super User Rank
Super User

Re: Combining Filter and Search!

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.


All Replies
Super User Rank
Super User

Re: Combining Filter and Search!

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.