Add search field to my search button

[Fnavarro]

Hey!

I'm actually using this querry to use my Search button, as you can see, right now is only looking for column "descripción", I want to search in 2 columns, but this DON'T work.

Please can u help me?

wrong: SortByColumns(Search(Filter([@Helpdesk_BD],Mail = User().Email),tbBuscar_1.Text,"Descripcion","ID"), "Created", Descending)

SortByColumns(Search(Filter([@Helpdesk_BD],Mail = User().Email),tbBuscar_1.Text,"Descripcion"), "Created", Descending)

[Drrickryp]

@Fnavarro 

Search only works on Text type fields:

SortByColumns(
         Filter(
              [@Helpdesk_BD], Mail = User().Email) && 
                              tbBuscar_1.Text in Descripcion||ID = tbBuscar_1.Text), "Created", Descending
)

[Fnavarro]

Thanks for your response but Is not working.

I'm actually using

SortByColumns(Search(Filter([@Helpdesk_BD],Mail = User().Email),tbBuscar_1.Text,"Descripcion"), "Created", Descending)

and is working fine, but only for 1 columns, I have to add another column to the "search"