Filter gallery with search box alongside other components

(0) Share

Report

Posted on by JimboSey

321

Hi,

So I have an App, within that I have a gallery of items, the gallery can be filtered by the following

Text search box, radio buttons, checkboxes and a combobox. This works fine, but for the code specifically relating to the text search box I have used Startswith, is there anyway I can adapt my code so that the code uses 'Search' instead of StartsWith' as I want users to be able to type any term in rather than specifically what it starts with. I have included my existing code below.

Filter(

MaintRequests,

StartsWith(

Title,

TextBox_1.Text

) && (Status.Value = Status_Radio_1.Selected.Value || Status_Radio_1.Selected.Value = Blank())

&& ((Checkbox_Me_1.Value && Owner.Email = User().Email) || Checkbox_Me_1.Value = false && Checkbox_Other_1.Value = false) || (Checkbox_Other_1.Value && Owner.Email = Resource_ComboBox_1.Selected.Email))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

The below should work, the search or in function is not delegable, but it looks like the 2nd filter function (your original code) is this means it should retrieve the data from the database, processing the query on the server, then carry out the 'in' search once the data is collected within PowerApps. fyi - i have not adjusted the rest of your code if it works.

Filter(

Filter(MaintRequests,

(Status.Value = Status_Radio_1.Selected.Value

||

Status_Radio_1.Selected.Value = Blank())

&&

((Checkbox_Me_1.Value && Owner.Email = User().Email)

||

Checkbox_Me_1.Value = false && Checkbox_Other_1.Value = false)

||

(Checkbox_Other_1.Value && Owner.Email = Resource_ComboBox_1.Selected.Email))

,

TextBox_1.Text in Title)

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JimboSey ,

I have made the above Delegable (sort of) as the in Filter is not - the top filter needs to return less than your Delegation limit for you to get the full results

With( { wList: Filter( MaintRequests, ( Len(Status_Radio_1.Selected.Value) = 0 Status.Value = Status_Radio_1.Selected.Value || ) && ( !Checkbox_Me_1.Value || Owner.Email = User().Email) || ) && ( !Checkbox_Other_1.Value || Owner.Email = Resource_ComboBox_1.Selected.Email ) ) }, Filter( wList, TextBox_1.Text in Title ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JimboSey ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
JimboSey 321 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, firstly thanks for your reply. I got an error with the code you provided (I can share once I log on). But the previous suggestion worked a treat.

Thanks again

Was this reply helpful? Yes No
JimboSey 321 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much, worked great.

Was this reply helpful? Yes No