Creating Search with filtered dropdown

[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?

[Drrickryp]

@JonRetro 

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

[WarrenBelz · Accepted solution]

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]

.