Unanswered

OR Filter

(0) Share

Report

Posted on by DarkStranger

Is there a way to have an "Or" filter, so something like...

Filter(CollectionName, CollectionColumn = DropDown1, CollectionColumn = DropDown2, etc.) OR Filter(CollectionName, CollectionColumn = DropDown3, CollectionColumn = DropDown4, etc.)

If so, I just cant figure it out.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@DarkStranger

Please consider changing your Formula to the following:

Filter(CollectionName, (CollectionColumn = DropDown1.Selected.Column && CollectionColumn = DropDown2.Selected.Column) || CollectionColumn = DropDown3.Selected.Column && CollectionColumn = DropDown4.Selected.Columns) || ..etc.. )

I hope this is helpful for you.

Was this reply helpful? Yes No
DarkStranger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for taking the time to answer. I tried the following...

Filter(
PatchingInventory,
(Floor_x0020_ = 'CB_Floor_Filter Input_1'.Selected.Result && Room_x0020_ID_x005c_Location = CB_RoomID_Loc_Filter_Input_1.Selected.Result && Switch_x0020_Name = CB_Switch_Name_Filter_Input_1.Selected.Result && Switch_x0020_Unit_x0020_No_x002e = CB_Unit_Filter_Input_1.Selected.Result) || (Floor_x0020_Port_x0020_No_x002e_=CB_Floor_Port_No_Filter_Input_1.Selected.Result))

If I enter details for the blue filter the gallery doesn't update. If I enter details for the red filter, that will update the gallery containing the red filter values. The only way to get the blue filter updating the gallery, is to also run the red filter and then the gallery will show values for both filters, so 2 sets of results, the blue results and the red results. I was hoping to be able to filter the gallery separately, so galley results for the the blue filter or the red filter. I hope that makes sense.

I would also like to maybe put a 3rd filter that would work independently from the others.

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

Like
a
(0)

Report
Copy link

Link copied!
@DarkStranger

So the formula should be producing what you want as it is written.

Essentially, your formula reads to filter the table be either Blue OR Red being true.

So, for Blue to be true, all of the fields and selection values must match and result in true for the record to be included. The same for Red except with the column and control selection for the red part. If either is true, then the record will be included in the resulting table.

There seems to be an issue from the blue filter.

What happens if you split out the red filter part at the moment to test?

Filter(PatchingInventory, ( Floor_x0020_ = 'CB_Floor_Filter Input_1'.Selected.Result && Room_x0020_ID_x005c_Location = CB_RoomID_Loc_Filter_Input_1.Selected.Result && Switch_x0020_Name = CB_Switch_Name_Filter_Input_1.Selected.Result && Switch_x0020_Unit_x0020_No_x002e = CB_Unit_Filter_Input_1.Selected.Result ) )

Was this reply helpful? Yes No
DarkStranger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

That works as expected...

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

Like
a
(0)

Report
Copy link

Link copied!
@DarkStranger

And the other condition?...

Filter( PatchingInventory, (Floor_x0020_Port_x0020_No_x002e_=CB_Floor_Port_No_Filter_Input_1.Selected.Result) )

Was this reply helpful? Yes No
DarkStranger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

And that also works, but they just wont work together 😐
unsure if this would make a difference, but the filter highlighted in blue in the previous comments, the 4 filter boxes all depend on each other being completed.

and thanks for trying to help me figure this out.

Was this reply helpful? Yes No