15
How do you handle the default of a drop down when you want it to always be blank when opening? I have played with the default value and it always loads the first item no matter what I do. The Items are coming up from an on-premise SQL database. Example: I have 4 drop downs for staff members that maybe on a truck, only the first one will be required and I want the app user to start with all blanks and fill in as needed
Another solution is available without having to create and clear collections.
AllowEmptySelection – Whether the control shows an empty selection if no item has been selected. App users can also clear their choices by selecting the blank item.
found Drop down control in Power Apps - Power Apps | Microsoft Docs
Set the Default to "0" instead of "1"
Hello,
I was looking for a similar solution and found out this is pretty simple to solve.
Just put Zero in Properties > default and put True in 'Allow empty selection' , your drop down will show an empty value as default.
I hope this works for you also.
Dear Carlos,
the solution you propose has a strange side-effect in my app: the drop-down box will NOT select the default value automatically maybe because employeesWithBlank is a collection and not a Table. When I use the Table the drop-down selects the Parent.Default value correctly. In case of the collection it selects the 'empty' value.
Any hints to correct this?
Thanx fro your support.
Ciao,
reinvdo
Dear Carlos,
your example works fine in case the table Employees has ONLY a Name column.
A generally correct formula would be:
Share
Report
All responses (
Answers (
ClearCollect(employeesWithBlank,{Name:Char(160)}); Collect(employeesWithBlank,ShowColumns(Employees, "Name"))It took me some time to figure that one out 😃
Ciao,
reinvdo
Hi all
Just a quick sidenote. The property is called AllowEmptySelection and not AllowUnsetSelection.
But after posting this I saw that someone already mentioned this. Dope 😉
Dawid van Heerden
Follow on Twitter: @DavesTechTips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
**If you found this reply helpful, please give it a thumbs up and Accept as Solution to close the topic and make it easier to find for other people with similar questions.
I am struggling with this as well. I am using a dropdown control, and if I *change* either the Default or Reset, then I am presented with a drop down with nothing selected. But once I select something, and stop and restart the App, the previous selection persists. I think I need to start with the empty control, because I'm loading a gallery once the dropdown item is selected. I don't want to load the gallery with the previously selected item.
The old Advanced Property in DropDown DataCardValues named "AllowUnsetValue" has been renamed to "AllowEmptySelection"
On Dropdown-DataCardValues you can set this "AllowEmptySelection" property to value "true" and the Default-Property to "" then you will have a blank default value in the Dropdowns. For all FormModes, of course
It makes sense to set this Default-Blank only to FormMode.New otherwise each edit will update with blanks:
Not available for Combo Boxes
#1
WarrenBelz
146,700
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
