So i made a filtering screen with 2 dropdown lists. I want that I will have the option to not fill the 2 of them so I could filter by only 1 dropdown if I will want.
The problem is that when the dropdown is blank it searches for blank content and its giving me nothing.
How can I make blank dropdown to just not filter?
This is an example of my function:
Thank you in advance.
Please consider changing your Formula to the following:
Filter(Data, (IsBlank(dropdown1.Sselected.qqq) || column1=dropdown1.Selected.qqq) && (IsBlank(dropdown2.Sselected.www) || column2=dropdown2.Selected.www) )
I hope this is helpful for you.
Filter( Data, IsBlank(Dropdown1.Selected.Value) ||qqq = Dropdown1.Selected.Value, IsBlank(Dropdown2.Selected.Value) ||www = Dropdown2.Selected.Value )
You can just use "In" instead "="
Filter(Data,dropdown1.selected.qqq In column1, dropdown2.selected.www In column2)
blank is in every content that is how I usually filter
Are those Choice columns in your datasource? If so, then append a .Value at the end of your column name in the formula.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!