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)
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
)
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"
User | Count |
---|---|
261 | |
130 | |
99 | |
48 | |
47 |