cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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.

1 REPLY 1
Super User
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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 272 members 5,224 guests
Please welcome our newest community members: