I have a gallery that is filtered by 2 values "Active" and "Pending"
Filter ('SP Job Request',Status.Value="Active" || Status.Value="Pending")
I also want to be able to search by company name. This works on its own
SortByColumns(Filter([@'KBX Job Request'], StartsWith(Company, TextSearchBox1.Text)), "Company", If(SortDescending1, Descending, Ascending))
I am trying to combine the two formulas so that the gallery still only shows active and pending but also have the option to search by company name. Something like below
Filter ('KBX Job Request',Status.Value="Active" || Status.Value="Pending");
SortByColumns(Filter([@'KBX Job Request'], StartsWith(Company, TextSearchBox1.Text)), "Company", If(SortDescending1, Descending, Ascending))
any assistance would be much appreciated
It is probably because Description is either a lookup or choice field.
I am also getting a delegation warning on another app with this
SortByColumns(Filter([@'KAS Reimbursement'], StartsWith(Description.Value, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
Is there another way to rewrite without delegation warning?
With({
fltd: Filter (
'KBX Job Request', OR(Status.Value="Active" , Status.Value="Pending"
)
)
},
SortByColumns(
Filter(
fltd, StartsWith(
Company, TextSearchBox1.Text
)
), "Company", If(SortDescending1, Descending, Ascending)
)
)