I have JobSummaryFilterByRadioControl that has three options.
I have CombBox2_1 with a Switch command that display a list of choice based on the option made in the radio control.
I have Gallery1 that displays the content based on the choice made in the ComboBox.
JobSummaryFilterByRadioControl
items: ["Company Name", "Technician Name", "Truck VIN Number"]
ComboBox2_1
Items:
Switch(
JobSummaryFilterByRadioControl.Selected.Value,
"Technician Name", RenameColumns( Distinct(EmployeeListCollection,Title), "Result", "Value"),
"Company Name", RenameColumns( Distinct(SchedulerDetailsListCollection,CustomerName), "Result", "Value"),
"Truck VIN Number", RenameColumns( Distinct(SchedulerDetailsListCollection,CustomerName), "Result", "Value")
)
Gallery1
Items:
If(IsBlank(JobSummaryFilterByRadioControl.Selected.Value),'Schedule Details List', Filter('Schedule Details List', CustomerName in ComboBox2_1.Selected.Value))
How do I update the Gallery Items formula so that it displays content based on the choice made in the ComboBox.
I can get it to display for one choice but can't figure out how to get it to change/switch the Gallery1 content when the ComboBox changes source?
