cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dr_David_Banner
Helper I
Helper I

Possible to use "or" in a filter condition in List Property

Hi 

 

I'd like to try and use an "or" in a filter on a gallery, example: 

 

Filter

     (DATASOURCE, Field1 in OK or WARNING, field2 in CLIENT)

 

Does anyone know how I would do this?

 

Thanks in advance 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Dr_David_Banner 

Like this:

Filter(Datasource, Field1 = ["OK","WARNING"] Or Field2 = "CLIENT")

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
mdevaney
Super User
Super User

@Dr_David_Banner 

Like this:

Filter(Datasource, Field1 = ["OK","WARNING"] Or Field2 = "CLIENT")

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Lovely, thanks so much

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,716)