Unanswered

Choice fields not updating if choice value removed

(0) Share

Report

Posted on by cheezy

148

I have an app with 4 choice fields writing back to a sharepoint list. If a user selects any value within any of the choice lists and submit form, the values are stored in sharepoint, similarly if they are updated with other choice values. All good.

However all my choice fields behave in same way. If the user removes the choice value all together (returns the field to blank) and submit the form, the value previously written is retained.

this is a sample of the choice lists i have created in sharepoint for this app

this is what happens

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @cheezy ,

After submitting is the value added in the backend also ?
If so would you please share the onChange property of the dropdown.

After submitting if value is not added into the database but showing in the dropdown value than it must be because of Reset and Default property. If this is the case would you please share your Reset and Default property of the dropdown ?

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.

Was this reply helpful? Yes No
cheezy 148 on at

Like (0)

Report

If i submit with any choice in the dropdown list then the value updates ok in sharepoint list. I can go back and change this value and it also updates ok.

It is just when the value is removed entirely (so blank value) , this doent get updated.

Reset = false
Default property has no value.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @cheezy ,

Just to be sure is it dropdown or ComboBox. Could you please show the Patch method used for patching this value ?

Was this reply helpful? Yes No
cheezy 148 on at

Like (0)

Report

sorry they are combo boxes.
the form is submitted via the standard : SubmitForm(ContentForm1)

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @cheezy ,
Could you please show the on change property of the combo box and also if you could try adding a label and printing the value of the comboBox in it to check when you remove the item what happens with combobox selected item.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (1)

Report

Looks like the blank option isnt part of the Items property of your combobox. If your default is set to the value of the column, it won't be able to find that value in the items in your combobox.

Was this reply helpful? Yes No
cheezy 148 on at

Like (1)

Report

in the end i have changed my combo boxes to dropdowns and added a "-" value - that seems to do the trick.

Was this reply helpful? Yes No