can I have 2 filters on one Screen?

(0) Share

Report

Posted on by Charles-v-D

280

I would like to have 2 filters in my screen (see below)

The formula for filtering is in the ITEM section of my BrowseGallery and reads:

SortByColumns(Filter('LPS EMEAI Requests'; StartsWith(Title; 'TextSearchBox1-Deals'.Text)); "Title"; If(SortDescending1; Descending; Ascending))

if I want it to work for the other filter I change it into:

SortByColumns(Filter('LPS EMEAI Requests'; StartsWith(Title; 'TextSearchBox1-LPS'.Text)); "LPS"; If(SortDescending1; Descending; Ascending))

but can I combine into a single formula for the ITEM section??

Additionally; how can I modify my filter to select any string that hassearch string instead of "StartsWith"?

Thank you all

Regards

charles

All responses (4)

Answers (0)

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report

Re: can I have 2 filters on one Screen?

@Charles-v-D
When you get back, shoot a messge back with any error you are seeing or any issues that it is showing.

Also mention how big the datasource is in terms of number of records.

See ya in 4 weeks...
Charles-v-D 280 on at

Like (0)

Report

Re: can I have 2 filters on one Screen?

@v-yutliu-msft @RandyHayes

Gent's,
thank you for your input, but I'm not able to get it to work.. I have released the app with 1 search box for now. I'm on FTO for next 4 weeks might get back in touch with you on this after that!

Thanks again

Regards
Charles
v-yutliu-msft on at

Like (0)

Report
Re: can I have 2 filters on one Screen?

Hi @Charles-v-D ,
I find that the items sort by "Title" in situtiation1 and sort by "LPS" in situtiation2.
Could you tell me when both the two textinput is not blank, the items sort by which column?
What's more, if you want to modify filter to select any string that hassearch string instead of "StartsWith", I suggest you use "in" instead of "StartsWith".
Try this formula:
Filter('LPS EMEAI Requests'; If(!IsBlank('TextSearchBox1-LPS'.Text; 'TextSearchBox1-LPS'.Text in Title; true) && If(!IsBlank('TextSearchBox1-Deals'.Text;
'TextSearchBox1-Deals'.Text in Title;
true)
)
About how to sort, I need your reply.

Best regards,
Community Support Team _ Phoebe Liu
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: can I have 2 filters on one Screen?

@Charles-v-D

Sure thing...just need to adjust your formula a bit. Consider the following:

SortByColumns( Filter('LPS EMEAI Requests'; If(!IsBlank('TextSearchBox1-LPS'.Text; StartsWith(Title; 'TextSearchBox1-LPS'.Text); true) && If(!IsBlank('TextSearchBox1-Deals'.Text;
StartsWith(Title; 'TextSearchBox1-Deals'.Text);
true)
); "LPS"; If(SortDescending1; Descending; Ascending))

That should give you what you are looking for. Try it out and post back if you have any issues.

I hope this is helpful for you.