Announcements
Hello,I need help to create a dropdown list not combobox with the option to show blank values when blank is selected from dropdown options as well as to show all values when the dropdown list is empty (I could not use empty expression with dropdown list) hence am wondering how can this be done.Thanks,
Hi @MSDigitalUser ,
Two things - set AllowEmptySelection to true and then in the Items - you did not post your existing Items but as an example if the output is .Value
Ungroup( Table( {Menu: {Table({Value:""})}, {Menu: YourExistingItemsHere} ), "Menu" )
You can call Menu whatever you want.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Unfortunately I am getting the below errors (it is value)
and how can this expression differntiate later if the dropdown list is blank or empty?
@MSDigitalUser ,
Just missing a bracket - now fixed - also what is 'EM_ID' ?
Sorry - I do not understand the second question.
Hi @WarrenBelz EM ID is my column where I need to add in the dropdown list.my 2nd question was how will I filter the gallery to return blank values from the dropdown, and how to get all values when it is empty? because now when we add "" it will consider it as blank not empty
I would need the Items of the gallery for that.
Sorry @WarrenBelz I got confused, the above expression for the dropdown list is also showing error, I used before distinct(SPL,EM ID)my gallery items:Filter(AddColumns('SPL',"Quarters","Q" & RoundUp(Month('Planned Date') / 3,0)),Len(DropEM.Selected.Value) = 0 || 'EM ID' = DropEM.Selected.Value,Len(DropStatus.Selected.Value) = 0 || Status.Value = DropStatus.Selected.Value)
The Len( . . .) = 0 syntax covers both Blank or Empty. I also think you are missing the quotes off 'EM_ID' in the Distinct formula, but am still not totally clear on your question.
Hi @WarrenBelz , I used the below and it worked, doesnot know if this will continue to work:If(Or(DropEM.Selected.Value=Blank()), Len(DropEM.Selected.Value) = 0, DropEM.Selected.Value in 'EM', 'EM' = DropEM.Selected.Value, (DropEM.Selected.Value=""), Len(DropEM.Selected.Value) = 0 ),
Now, if no selection, it returns all gallery items, if blank is selected, it brings only blank items.
You do not need all of that - just this assuming EM is a Text field
Filter( DataSource, Or( Len(DropEM.Selected.Value) = 0, DropEM.Selected.Value in 'EM' ) )
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
