Hi @Evan_S1,
It is difficult to achieve your need if you are not sure about it.😂
Okay, here is a situation for your reference:
If you want to filter the Order Number based on the Area filtering:
Switch('Production Stoppage - DRAFT 1',
btnChoice,
Vertical,
Search(Filter('Production Stoppage - DRAFT 1', "Vertical" in Area.Value),SearchBox_2.Text, "Order No"),
Modified,
Search(Filter('Production Stoppage - DRAFT 1', "Modified" in Area.Value),SearchBox_2.Text, "Order No"),
'Quick Ship',
Search(Filter('Production Stoppage - DRAFT 1', "Quick Ship" in Area.Value),SearchBox_2.Text, "Order No"),
Machining,
Search(Filter('Production Stoppage - DRAFT 1', "Machining" in Area.Value),SearchBox_2.Text, "Order No"),
Repairs,
Search(Filter('Production Stoppage - DRAFT 1', "Repair" in Area.Value),SearchBox_2.Text, "Order No"),
Horizontal,
Search(Filter('Production Stoppage - DRAFT 1', "Horizontal" in Area.Value),SearchBox_2.Text, "Order No"),
Shipping,
Search(Filter('Production Stoppage - DRAFT 1', "Shipping/Receiving" in Area.Value),SearchBox_2.Text, "Order No"),
'Material Handling',
Search(Filter('Production Stoppage - DRAFT 1', "Material Handling" in Area.Value),SearchBox_2.Text, "Order No"),
'Paint Booth',
Search(Filter('Production Stoppage - DRAFT 1', "Paint Booth" in Area.Value),SearchBox_2.Text, "Order No"),
ORE,
Search(Filter('Production Stoppage - DRAFT 1', "ORE" in Responsible.Value),SearchBox_2.Text, "Order No"),
Logistics,
Search(Filter('Production Stoppage - DRAFT 1', "Logistics" in Responsible.Value),SearchBox_2.Text, "Order No"),
Purchasing,
Search(Filter('Production Stoppage - DRAFT 1', "Purchasing" in Responsible.Value),SearchBox_2.Text, "Order No"),
Quality,
Search(Filter('Production Stoppage - DRAFT 1', "Quality" in Responsible.Value),SearchBox_2.Text, "Order No"),
Search('Production Stoppage - DRAFT 1',SearchBox_2.Text, "Order No")
)