So please bear with me while I provide some context...
I have a Gallery on a Dashboard page that populates based on a 'type' variable.
Here is a snippet:
If(
type = "All",
Tickets,
If(
type = "Tickets older than 3 days",
Filter(
Tickets,
DateCreated <> datetype && DateCreated <> Text(Today()),
DateCreated <> Text(
DateAdd(
Today(),
-2
)
),
DateCreated <> Text(
DateAdd(
Today(),
-1
)
) || DateClosed <> datetype && DateClosed <> Text(Today()),
DateClosed <> Text(
DateAdd(
Today(),
-2
)
),
DateClosed <> Text(
DateAdd(
Today(),
-1
)
)
),
the Filter repeats for each of the pre-defined filters.
There is a FilterGallery on the Dashboard that the user clicks to set the 'type'.
I would like to add a Filter page where the user can choose values from dropdowns where the dropdowns are populated with distinct values from the Tickets table. Then once they've made their selections, return to the Dashboard showing the correct Tickets.
I know I can use a Gallery to retrieve and display the distinct values in dropdowns like this: Distinct(Tickets,Status). Then I can retrieve the selected value through Dropdown1.Selected.Value and I could use the OnChange property of the Dropdown to set a variable.
What I don't understand is the next few steps.
1. How do I combine multiple selections from individual dropdowns into a single query?
2. How do I modify the TicketGallery on the Dashboard page based on solving number 1?
What I need help with is the design and implementation of the rest of the solution. I know I can
