Hello everyone, does anyone of you know how can I filter with 2 dropdowns if the value of the choice column is "Yes". As you can see below, I am filtering based on their area of knowledge and the value of the dropdowns are hard coded because it will not look good as my SharePoint list column name is like WindTurbine_1 and so on. For now, it is filtering as one to one together with the willingness to travel location and I want them to be filtered if they are both selected.
I have used switch case for now as a filter with my gallery but again I want my gallery to be filtering based on the selected area of knowledge and travel. How can I do this, below is my current formula for filtering as one to one.
If(
dd_AOK.Selected.Value = "Wind Turbine",
Filter(
'db-Consultants-AOK',
WindTurbines.Value = "Yes"
),
dd_AOK.Selected.Value = "Cable",
Filter(
'db-Consultants-AOK',
Cable.Value = "Yes"
),
dd_AOK.Selected.Value = "Foundation",
Filter(
'db-Consultants-AOK',
Foundation.Value = "Yes"
),
dd_AOK.Selected.Value = "Substation",
Filter(
'db-Consultants-AOK',
Substation.Value = "Yes"
),
dd_AOK.Selected.Value = "Overall Project",
Filter(
'db-Consultants-AOK',
OverallProject.Value = "Yes"
),
dd_AOK.Selected.Value = "Marine Coordination",
Filter(
'db-Consultants-AOK',
MarineCoordination.Value = "Yes"
),
dd_AOK.Selected.Value = "Marine Operation",
Filter(
'db-Consultants-AOK',
MarineOperation.Value = "Yes"
),
dd_Willingness.Selected.Value = "Online",
Filter(
'db-Consultants-AOK',
WillingnessToTravel.Value = "Yes"
),
dd_Willingness.Selected.Value = "Inside Country",
Filter(
'db-Consultants-AOK',
WillingnessToTravel_Country.Value = "Yes"
and so on.....
