I want to enable the users to select which view they want to see for my gallery. To filter for a specific view, I know that we can simply filter the gallery by Filter( Leads, 'Leads (Views)'.'Active Leads' ). To enable selection, I inserted a drop down box with Choices ('Leads (Views)') to provide the users all Lead views available to choose from. However, I can't find a way to pass the drop down value back to the filter and make the filter work. I tried something like:
- Filter( Leads, 'Leads (Views)'.(LeadViewsDropDown.Selected.Value) )
- Filter( Leads, LeadViewsDropDown.Selected )
But none of above work. I thought of using a Switch to do that, but that'd be complicated and hardcoded and if we add or delete any views we'll have to edit the Switch again. Anyone knows a way that we can apply the selected view from dropdown toward the Filter of the gallery?
Thanks in advance!
