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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
Charles-v-D 280 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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...

Was this reply helpful? Yes No