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!
Solved! Go to Solution.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.