cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasVDS
Level: Powered On

Can not empty dropdown field after field has been selected using SQL

Hi, 

 

I have issues to empty a not required dropdownfield which has been selected before.

I already changed to property 'AllowEmptySelection' to true.

It is a lookup field from the Customers table.

 

I assume using a combobox would solve the issue because there you have the cross to empty.

But I guess there should be another solution for dropdown fields?

 

How can I empty the field? Thanks!

 

Kr

Empty dropdown NOK.PNGdropdownfield_settings.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Can not empty dropdown field after field has been selected using SQL

If you want the option to select nothing you will need to change it to a combo box. That is one of the deciding factors for me when using a Dropdown or a Combobox. 

 

Also, that Combobox allows for searching and Dropdown does not. 

3 REPLIES 3
Highlighted
Super User
Super User

Re: Can not empty dropdown field after field has been selected using SQL

If you want the option to select nothing you will need to change it to a combo box. That is one of the deciding factors for me when using a Dropdown or a Combobox. 

 

Also, that Combobox allows for searching and Dropdown does not. 

Community Support Team
Community Support Team

Re: Can not empty dropdown field after field has been selected using SQL

Hi @ThomasVDS 

 

If you want the Dropdown's default as blank, you can try the next workaround.

Add one Button, Button.OnSelect=ClearCollect(dropdownwithblank,{Value:" "});Collect(dropdownwithblank,Choices(DataSource.lookupColumnName))

Dropdown.Items=dropdownwithblank.Value

dropdownwithblank.gif

 

Best Regards.

Yumia

 

ThomasVDS
Level: Powered On

Re: Can not empty dropdown field after field has been selected using SQL

@v-yuxima-msft @rebeccas 

Thank you for your help.

I solved it by using the combobox.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 247 members 5,324 guests
Please welcome our newest community members: