Power Apps Cheat Code- Filters DataSource by All but have extra condition

Submitted by leader on Mon, 05/26/2025 - 19:00

I need the filter to filter the datasource by status color and show me all records by default but only of the the Yellow color.

If (

    //This is for all and all

    DDLocations.Selected.Value = "All" And DDTimes.Selected.Value = "All", Filter('2025SummerGradCeremony',StatusColor.Value = "Yellow"),

    //This is for all locations and selected times

    DDLocations.Selected.Value = "All" And DDTimes.Selected.Value <> "All",

    Filter('2025SummerGradCeremony',  CeremonyTime.Value= DDTimes.Selected.Value && StatusColor.Value = "Yellow"),

 //This is for all times and selected Locations

    DDLocations.Selected.Value <> "All" And DDTimes.Selected.Value = "All",

    Filter('2025SummerGradCeremony',  CeremonyLocation.Value= DDLocations.Selected.Value && StatusColor.Value = "Yellow"),

    //This is filter by both

    DDLocations.Selected.Value <> "All" And DDTimes.Selected.Value <> "All",

    Filter('2025SummerGradCeremony',  CeremonyTime.Value= DDTimes.Selected.Value && StatusColor.Value = "Yellow" && CeremonyLocation.Value = DDLocations.Selected.Value)  

)

Blog Type: