sorting and filtering search based on 2 possible search columns in gallery

[Awad0367]

I am trying to search after 2 posssible columns 'RegNr' and 'Rekvistion Nummer'  gallery with sahrepint list  data source "Rekviistion"

I need to enter || function in the formula below 

SortByColumns(
Filter(Rekvisition; StartsWith('Reg.nr'; tbSearchRekv.Text)); "ID"; Descending)

like that

SortByColumns(
Filter(Rekvisition; StartsWith('Reg.nr'; || 'Rekvisition Nummer' ; tbSearchRekv.Text)); "ID"; Descending)

but it gives error . How can I adjust it 

[iAm_ManCat · Accepted solution]

I think something like this would work for your situation - we also should have a check there for when the text is blank so that we don't try filter when its blank:

SortByColumns(
   Filter(
      Rekvisition; 
      tbSearchRekv.Text=""
      ||
      (
         StartsWith('Rekvisition Nummer' ; tbSearchRekv.Text)
         ||
         StartsWith('Reg.nr'; tbSearchRekv.Text)
      )
   );
   "ID";
   Descending
)

[Awad0367]

It worked likea charm, Thanks for help.

[iAm_ManCat]

Excellent, glad I could help!