I have a gallery linked to a list in sharepoint and, I already have it previously sorted by priority in descending order.
(Like this: Sort('Matriz de necesidades(Building)';Prioridad;Descending))

But I need to create a series of filters and a search bar and, therefore, I need to combine the formulas and, I don't know exactly how to do it, every time I try to implement it I get errors. I need to implement a search bar to search for specific items and, additionally, I need to make 3 filters, one of employees, one by project status and one by date range but, I don't know how to combine the formulas into one to put it in the "items" formula of the gallery.