Answered

How to search in only one category in excel collumn

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all!

I have a textsearch box connected to a gallery, with the following code:

SortByColumns(Search([@Table3], TextSearchBox1_1.Text,"Category" ,"Full_x0020_Name", "Shortname"), "Shortname", If(SortDescending1, Descending, Ascending))

I would like to only search through one specific category within the "category" collumn, (data from excel). How can I limit any results to this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@JosephineL

You can nest the call to Search inside a call to Filter. This formula will further filter the search results to only those that match category XYZ.

SortByColumns( Filter( Search([@Table3], TextSearchBox1_1.Text, "Category" ,"Full_x0020_Name", "Shortname" ), Category="XYZ" ), "Shortname", If(SortDescending1,Descending,Ascending) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It worked perfectly, thank you!
(And thanks for formatting my code, I should really work on that ;))

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You're welcome @JosephineL - glad that works!

Was this reply helpful? Yes No