Announcements
Hi All
I have a gallery which I am filtering by a combo box selected value. Which works great but what I would like it to do is when no item is selected from the combo box is to show all items not a blank screen and only items when a election is made from the combo box. Is this achievable?
Please what is your current formula?
Try:
If(IsEmpty(Combobox2) Or IsBlank(Combobox2.Selected.Value), Datatsource, Filter(Datasource,Column=Combobox2.Selected.Value))
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Just another way to write that is:
Filter(Datasource,IsBlank(Combobox2.Selected.Value) || Column=Combobox2.Selected.Value)
---If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.
Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
Microsoft Certified Trainer MCT
Blog | Twitter | LinkedIn | Facebook | YouTube | Email
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 600
WarrenBelz 478 Most Valuable Professional
Valantis 322