Sort by multiple columns

[Boelebroer]

Hello, I have a sharepointlist with multiple colums. I want to search those colums but I can only search "Title" for now. 

The other column I want to search is IcaoType. How can I adjust the formula below to do that?

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

Best regards,

René

[WarrenBelz · Accepted solution]

Hi @Boelebroer ,

Something like this

SortByColumns(
   Filter(
      [@Aircrafts]; 
      StartsWith(
         Title; 
         TextSearchBox1.Text
      ) ||
	  StartsWith(
         IcaoType; 
         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

[Boelebroer · Accepted solution]

Thanks Warren for the fast reply and solution!