Filter into an OR statement

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Is there a way to turn this Filter into an OR statement on the criteria ?

DUNS_NAME =TextInput21.Text && SELLER_NAME = ComboBox4_1.Selected.Result

Current Filter :

Filter('[dbo].[Entity_Location_Facility_Emp_Base]', DUNS_NAME =TextInput21.Text && SELLER_NAME = ComboBox4_1.Selected.Result)

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

Filter( '[dbo].[Entity_Location_Facility_Emp_Base]', DUNS_NAME =TextInput21.Text || SELLER_NAME = ComboBox4_1.Selected.Result )

I hope this is helpful for you.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
To switch it to an 'OR' you just need to change the && to a ||.

Filter('[dbo].[Entity_Location_Facility_Emp_Base]', DUNS_NAME =TextInput21.Text || SELLER_NAME = ComboBox4_1.Selected.Result)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

When i add the || it is bring back the whole dataset ?
Dave

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

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Can you provide a sample of a record that you know should not be returned?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Randy, I guess what i'm trying to say is if i make a choice in the first dropdown, filter the records...after i make a choice in the second dropdown , filter again..

Dave

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

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Okay, but your original post mentioned a ComboBox and a TextInput control. So if it is two ComboBoxes you are working with, then your formula would be more like this:

Filter( '[dbo].[Entity_Location_Facility_Emp_Base]', DUNS_NAME =TextInput21.Text || ( (IsBlank(ComboBox4_1.Selected.Result) || SELLER_NAME = ComboBox4_1.Selected.Result) && (IsBlank(yourOtherCombo.Selected.Result) || AnotherColumn = yourOtherCombo.Selected.Result) ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks Randy, exactly what I needed.
Dave

Was this reply helpful? Yes No