Filter gallery and search filter

(0) Share

Report

Posted on by Matt383

407

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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) ) )

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Matt383

It is probably because Description is either a lookup or choice field.

Was this reply helpful? Yes No