My list has a drop down Site column. In the view you can see that most of the items has a value for this column. Even when you go to display item form you can see that the field has right value. However when I go to Edit Item, the value is gone and the field is empty.

1 Answer 1


I have seen this happen before (when a programmer without SharePoint knowledge 'fixed' a problem with imported/pasted data and emptied/deleted the existing definition of DropDown values

The underlying database stores anything that is written to it, so modern JSOM code can write values to a 'DropDown' field without checking those values actually match with the specified DropDown.

In other words, a DropDown field is only a DropDown field because the UI presents it as a DropDown, to the database it is just a textstring.

In SharePoint List Settings Check the Field/Column definition for this DropDown and see if it has all values.

One way to reconfigure is to edit the List in DataSheet View (or open in Excel) and select/copy/paste the values back into the Field/Column definition

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.