This is my code below. Am I just putting it in the wrong format? The gallery still goes blank when I try to add the search box filter.
Switch(
btnChoice,
Vertical,
Filter('Production Stoppage - DRAFT 1', "Vertical" in Area.Value),
Modified,
Filter('Production Stoppage - DRAFT 1', "Modified" in Area.Value),
'Quick Ship',
Filter('Production Stoppage - DRAFT 1', "Quick Ship" in Area.Value),
Machining,
Filter('Production Stoppage - DRAFT 1', "Machining" in Area.Value),
Repairs,
Filter('Production Stoppage - DRAFT 1', "Repair" in Area.Value),
Horizontal,
Filter('Production Stoppage - DRAFT 1', "Horizontal" in Area.Value),
Shipping,
Filter('Production Stoppage - DRAFT 1', "Shipping/Receiving" in Area.Value),
'Material Handling',
Filter('Production Stoppage - DRAFT 1', "Material Handling" in Area.Value),
'Paint Booth',
Filter('Production Stoppage - DRAFT 1', "Paint Booth" in Area.Value),
ORE,
Filter('Production Stoppage - DRAFT 1', "ORE" in Responsible.Value),
Logistics,
Filter('Production Stoppage - DRAFT 1', "Logistics" in Responsible.Value),
Purchasing,
Filter('Production Stoppage - DRAFT 1', "Purchasing" in Responsible.Value),
Quality,
Filter('Production Stoppage - DRAFT 1', "Quality" in Responsible.Value),
'Production Stoppage - DRAFT 1'
); Filter('Production Stoppage - DRAFT 1','Order No' in SearchBox_2.Text)