Answered

Combining filters

(0) Share

Report

Posted on by Nogsthenog

I have three filters i would like to apply. I can get them to work individually but cant work out how to combine them (newbie :-)). It either doesn't work at all or I end up with one overiding the other rather than combining.

Text field search - Filter(ExportBookings,StartsWith(Title,TextSearchBox1_1.Text))

Check box - If(CheckboxToday_1.Value=false, ExportBookings, Filter(ExportBookings,InspectionDate=Today()))

Choice drop down - If(IsBlank(AllocatedPersonDropdown.Selected.Value),ExportBookings, Filter(ExportBookings,AllocatedPerson.Value = AllocatedPersonDropdown.Selected.Value))

Any assistance gratefully received.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Nogsthenog

You can use the And and Or operators.

Filter( ExportBookings, StartsWith(Title, TextSearchBox1_1.Text) &&
(CheckboxToday_1.Value || InspectionDate = Today()) &&
(IsBlank(AllocatedPersonDropdown.Selected.Value) || AllocatedPerson.Value = AllocatedPersonDropdown.Selected.Value) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

Nogsthenog 23 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the response.

It doesn't quite work as the checkbox is the wrong way around (when selected it displays 'all' instead of just 'today') but I can either have a go at sorting that bit out myself or just change the label on my checkbox. Either way, you have really helped so thank you.

Was this reply helpful? Yes No