Answered

Creating Search with filtered dropdown

(0) Share

Report

Posted on by JonRetro

How do I implement search within my PowerApp? I have a drop-down that filters the location, I want the search to look for the first name or last name, and status.

The browse gallery formula is:

SortByColumns(
Filter(
[@'Leave Tracking'],
Campus = Dropdown1.Selected.Result,
StartsWith(
Title,
TextSearchBox1.Text
)
),
"Title",
If(
SortDescending1,
Descending,
Ascending
)
)

How do I add search function into there?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JonRetro

With({somelist: Filter( [@'Leave Tracking'], Campus = Dropdown1.Selected.Result ) }, SortByColumns( Search( somelist, TextSearchBox1.Text, "Title","LastName",FirstName" ), "Title", If(SortDescending1, Descending, Ascending) ) )
Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JonRetro ,

Try this (note I have assumed your field names and that they are all Single Lines of Text).

With( { wList: SortByColumns( Filter( 'Leave Tracking', Campus = Dropdown1.Selected.Result ), "Title", If( SortDescending1, Descending, Ascending ) ) }, Search( wList, TextSearchBox1.Text, "First Name", "Last Name", "Status", "Title" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
bapala 247 on at

Like
a
(0)

Report
Copy link

Link copied!

.