cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiteshGovan
Post Patron
Post Patron

Adding multiple fields

Hi 

 

How do i add a search to multiple fields to the formula below?

 

I would like to add "Title" and "Brand" and "Description" in the TextSearchBox1

 

SortByColumns(Filter([@Pens], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @MiteshGovan ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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

View solution in original post

4 REPLIES 4
WarrenBelz
Super User
Super User

Hi @MiteshGovan ,

As below

SortByColumns(
   Filter([@Pens], 
      StartsWith(
         Title, 
         TextSearchBox1.Text
      ) ||
      StartsWith(
         Brand, 
         TextSearchBox1.Text
      ) ||
      StartsWith(
         Description, 
         TextSearchBox1.Text
      )
   ), 
   "Title", 
   If(
      SortDescending1, 
      Descending, 
      Ascending
   )
)

 

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

Hi 

 

I am receiving an error message below. Would i need to be concerned?

 

MiteshGovan_0-1653424012489.png

 

Hi @MiteshGovan ,

That is a Delegation warning, although you should not be getting it with that code unless Description a Multi-line Text column - is this the case ?

WarrenBelz
Super User
Super User

Hi @MiteshGovan ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,626)