Forum Discussion
After changing choice column type from multi choice to choice back I have lost all values
Dear Ladies and Gentlemen,
after changing choice column type from multi choice to choice back I have lost all values in a SharePoint online list.
Originally the type was choice and there were single values in the list items.
Then later the type has been changed into multi choice.
Then I have changed it back to choice.
After that I have lost all values in all items.
Is this the expected behavior?
In case yes, could it be changed, that the original single values will sustain after such change?
Thank you for your answer.
With best regards
Ladislav Stupak
1 Reply
I am not sure that changing the column back to a single-choice column would automatically make all values blank. Could you please share a screenshot showing how the column and data look now?
Based on my experience, when a Choice column is changed from single-select to multi-select, or from multi-select back to single-select, the column values do not typically disappear completely. In some cases, the values may still exist in the underlying data, but the relationship between the stored values and the available choices can break, causing the values not to be displayed correctly in the SharePoint UI.
Example:
It would be helpful to see a screenshot of the column settings and a few sample list items so I can better understand what happened and determine whether the data is actually missing or simply not being displayed as expected.
