Combining Filter and Search?

[BenGillard]

is it possible to combine the two Functions? I currently have a search that allows users to type what they are looking for across three columns which works and looks like this:

Search(AllResources,TextInput1.Text, "KeyWords","Style","{Name}")

I would like a formula that allows the exact same serahc funtion, but Filters the Gallery to only show items that are called QRG in my Style Column. I tried the below with no success. Any Help would be great.

Filter(Search(AllResources,TextInput1.Text, "KeyWords","Style","{Name}"),AllResources,"Style" = "QRG")

Thanks

[timl · Accepted solution]

Hi Ben,

Yes, this is possible. Something like this might work a bitter for you.

Search(Filter(AllResources, Style = "QRG"),
       TextInput1.Text, 
       "KeyWords",
       "Style",
       "{Name}"
)

[BenGillard]

Thank you so much!! That worked perfectly