cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Filter with grouped condition

I was wondering if there is a way to group a filter condition. 

 

EX: I have a gallery that needs to exclude certain materials. For that I have the following:

Filter(RPTDLOADS, RPT<>"RPT", Material <> "DEL", Material <>"TCH", Material <>"RNT")

 

Is there any way to combine the Material conditions? The closest I got was the following, without any errors or warnings, but it does not filter at all. 

Filter(RPTDLOADS, RPT<>"RPT", Material <> "DEL"||"TCH"||"RNT")

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps
Power Apps

You can use the in operator for this:

Filter(RPTDLOADS, RPT <> "RPT", Not(Material in ["DEL","TCH","RNT"]))

Notice that depending on the data source for RPTDLOADS this may generate a delegation warning. If this is not a problem, then you can use this solution.

View solution in original post

2 REPLIES 2
Power Apps
Power Apps

You can use the in operator for this:

Filter(RPTDLOADS, RPT <> "RPT", Not(Material in ["DEL","TCH","RNT"]))

Notice that depending on the data source for RPTDLOADS this may generate a delegation warning. If this is not a problem, then you can use this solution.

View solution in original post

Thanks! Worked Perfectly!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,518)