Unanswered

Filter Gallery - my brain can't work out the logic

(0) Share

Report

Posted on by steshepherd

Hi,

Another missing piece of the jigsaw in my App

I have a simple Collection that I want the user to search. So I've created a gallery and two fields. SearchAll (Text control) and cbsearcharea (combobox)

So I have a filter of the collection, but I can't get the logic to work how I want it

If SearchAll finds matches in The Title/Description/ID, then show values

If cbsearcharea matches values, then show values

if cbsearcharea & searchall is used, the results of cbsearcharea need to be filtered by searchall

Filter(
 ColSearchRequests,
 IsBlank(SearchAll.Text) || SearchAll.Text in Name || SearchAll.Text in 'RIPS ID' || SearchAll.Text in Description,
 Service in cbsearcharea.SelectedItems
)

This isn't working...it does the combobox & text, but text on it's own isn't showing

My brain can't work out how to write the correct logic..

Thanks

Steven

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @steshepherd,

Try this out:

Filter( ColSearchRequests, IsBlank(SearchAll.Text) || SearchAll.Text in Name || SearchAll.Text in 'RIPS ID' || SearchAll.Text in Description, IsBlank(Dropdown1.Selected.Value) || Dropdown1.Selected.Value in Text(Service) )

I am using a dropdown control instead of a combobox.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!
Filter( ColSearchRequests, Or(StartsWith(Name, SearchAll.Text), StartsWith(Description, SearchAll.Text), StartsWith(Service.Value,cbsearcharea.Selected.Value))

Use the StartsWith with an Or
That will check both controls if you are using a dropdown control
If you are using a combobox it will be diff
steshepherd on at

Like
a
(0)

Report
Copy link

Link copied!
Hi
Yeah, I'm using a combo - trying to be helpful to the users
Not sure about this:
Dropdown1.Selected.Value in Text(Service)
What's the Text(Service) doing? Doesn't that just turn Service into a Text?
Service is what is in the combobox
Filter( ColSearchRequests, IsBlank(SearchAll.Text) || SearchAll.Text in Name || SearchAll.Text in 'RIPS ID' || SearchAll.Text in Description, IsEmpty(cbsearcharea.SelectedItems) || Service in cbsearcharea.SelectedItems )
This almost works - the only problem is the Text only search doesn't work (when the combox is empty)
steshepherd on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - yes, I'm using combobox. I'm also wanting to search the whole text not StartsWith

Could that be the same (using your Or) using Search instead?
steshepherd on at

Like
a
(0)

Report
Copy link

Link copied!
Hi
Still struggling to get the results I am looking for
These are the scenarios (I will just say 'true' for the filter results being found in the gallery to make life easier)
Combobox values + Textbox empty - true
Combobox values + Textbox values - true
Combobox empty + Textbox empty - false
Combobox empty + Textbox values - true

The code above works for 1, 2, 3 but not 4
Here are some screenshots
Scenario 1 - tick! (this works for multi-values too)
Scenario 2 - tick!
Scenario 3 - tick!
Scenario 4 - 😞
Any help?