Hi @gnorman ,
Yes this is possible with either a Combo Box control or a Dropdown control.
For example, in the Items property of the Dropdown or Combo Box control, use:
Sort(
Ungroup(
Table(
{
DropdownOptions: Distinct(
'Your Data',
'Your Field'
)
},
{DropdownOptions: ["#All"]}
),
"DropdownOptions"
),
Value
)
In the Items property of your Gallery, use:
Filter(
'Your Data',
//Dropdown1.SelectedText.Value = "#All" || 'Your Field' = Dropdown1.SelectedText.Value //use for a dropdown control
ComboBox1.Selected.Value = "#All" || 'Your Field' = ComboBox1.Selected.Value //use for a combo box control
)
Given there are multiple Solutions to different questions in this thread, please mark them as Solved if they answered your questions. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
