Empty value in choice column

Madhan Thurai

how to prevent empty value in choice column SharePoint modern page?,setting default value not working for hiding empty value in modern page

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arvind Kushwaha6y ago
You can go to edit choice column for which you need to have validation.Go to Column validation Add below formula

=ChoiceColumnName<>"Select"

Here 'ChoiceColumnName' is name of your column and 'Select' is you value which you don't want user to save. Add your custom message and save.

Hope this helps !!
0
Madhan Thurai6y ago
Still empty field appears :(
0
Dipa Mehta6y ago
Hello Madhan, Kindly try once this: Insert a “Blank Space” SharePoint choice fields do not save blank rows. What this means is that once a user has selected an item from the choice list and they want to now select a blank row they cannot! Blank rows are removed by SharePoint once a choice has been saved. This rather annoying situation can be resolved using the following steps: 1. Go to the column drop down list in question. 2. At the first entry on the list do a return to create a blank space. 3. Inside that blank space place your cursor and press and hold down the ALT key while typing 0129 on the NUMERIC KEYPAD. This will enter another type of “blank character” that SharePoint cannot wipe away. 4. In the Default Entry setting do the same. 5. Save and you are done. Hopefully it will works. Thanks.
+1