Need dropdowns coming from Azure SQL to have a blank first value

[DS2]

Hi All,

I have a number of dropdown controls in my PowerApp, the end user will make a choice and that choice will be written back to Azure SQL. 

However, the dropdown defaults to the first in the list. I currently have it so that it sorts those items for the dropdown's Items field, as so:
Sort(Filter('[SQL.[SQL PickList Data]', 'Entry Type' <> ""), 'Entry Type', Ascending)

I would like the value to be null at start out for these dropdowns. I saw this entry in the forums:

"The dropdown control now has a new property that allows it to have empty defaults. Check for the AllowUnsetValue property in the control, and if you set it to true, you should be able to set the Default property to a blank value, and you'll start the dropdown without a selection."

I cannot find the "AllowUnsetValue" property anywhere in the dropdown control properties, would this work and if so, where is it, please?

Thanks!

[Jeff_Thorpe]

If it is a drop down control then try setting the "AllowEmptySelection" value to "true" in the advance tab under data.

[DS2 · Accepted solution]

Hmmm...that by itself didn't do it, but you set me on the right (I hope?) track, @Jeff_Thorpe  - Thanks!

I set to true, but also needed to change the default from "1" to "0" - it needed both settings to show the blank. 

Hope that won't affect anything else. 

[v-xida-msft]

Hi @DS2 ,

Have you solved your problem?

Actually, when you change the AllowEmptySelection property of the Dropdown control to true, the effect would not be taken immediately within your ComboBox. You need to remove the formula from the Items property of the ComboBox, then re-type again.

As an another solution, I think the ComboBox control would be a better choice for you. In default, the ComboBox control would display blank value rather than first value from your formula.

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,