cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jason_Hough
Resolver I
Resolver I

Filter Gallery Help

hi there, 

I have a CDS that i use ClearConnect to get a local copy - all working fine. 

 

I need to do a filter and the filter is : If businessGroup = Variable and Criticality = Varible and this works perfectly by : 

 

Filter(ContactListLocal, BusinessGroup=BG, Severity=Criticality)

 

but if i want to add another filter : 

 

Filter(ContactListLocal, BusinessGroup=BG, Severity="ALL") - that works perfectly as well - so it shows rows when severity is ALL. but how do i combine them together - so it shows the rows with severity of Criticality and ALL ? 

 

Multiple filters do not work for me, any help would be fab. 

1 ACCEPTED SOLUTION

Accepted Solutions
CarlosFigueira
Power Apps
Power Apps

You can use the Or operator to combine the two expressions:

Filter(
    ContactListLocal,
    BusinessGroup = BG,
    Severity = Criticality Or Severity = "ALL")

That will give you the contacts in the business group that have the severity either the value of the Criticality variable, or the value "ALL".

View solution in original post

1 REPLY 1
CarlosFigueira
Power Apps
Power Apps

You can use the Or operator to combine the two expressions:

Filter(
    ContactListLocal,
    BusinessGroup = BG,
    Severity = Criticality Or Severity = "ALL")

That will give you the contacts in the business group that have the severity either the value of the Criticality variable, or the value "ALL".

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

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