Set DropDown value back to blank when using Azure SQL

(0) Share

Report

Posted on by mfcalmeida

Hi Everyone!

I'm having some issues with DropDowns and blank values...

I have a DropDown, in my data form, that is connected to an Azure SQL data source which has an empty row that is displayed by default (as blank).

If I change the DropDown value to something other than blank and submit the form, it works perfectly. When I open back the form, the value is loaded correctly and I can change it to any other value except to blank.

Once the DropDown is set to something else other than blank I can't seem to be able to set it back to blank again.

I've tried the Patch function but I get an error message saying that a value is expected, although my column, in SQL, allows null values.

Any thoughts?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @mfcalmeida ,

The reason why you met this problem is that blank value do not meet the requirement of this field's data type, powerapps will check this before you update.

So you could turn this setting on to avoid this:

Best regards,

Was this reply helpful? Yes No
mfcalmeida 28 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,

Thanks for your input, however, the feature is already off and I still can't set the blank...

Cheers

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @mfcalmeida ,

I mean that please turn this setting on.

If you turn this setting on, then you could update with blank value.

Best regards,

Was this reply helpful? Yes No
mfcalmeida 28 on at

Like (0)

Report
Copy link

Link copied!

My bad! Thanks a lot, it worked!

Cheers

Was this reply helpful? Yes No