SOLVED

Unable to delete column default value

%3CLINGO-SUB%20id%3D%22lingo-sub-2486305%22%20slang%3D%22fr-FR%22%3EUnable%20to%20delete%20column%20default%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2486305%22%20slang%3D%22fr-FR%22%3E%3CP%3EWhen%20I%20go%20in%20''%20%3CSPAN%20class%3D%22Y2IQFc%22%3E%20default%20column%20value%20settings''%2C%20I%20am%20unable%20to%20delete%20a%20default%20value%20as%20I%20get%20this%20error%20message%3A%20%3CSPAN%3E%20%22Please%20enter%20a%20valid%20default%20value.%20It%20must%20not%20be%20blank%22.%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22Y2IQFc%22%3E%3CSPAN%3EI%20am%20also%20unable%20to%20unselect%20''use%20this%20default''.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22Y2IQFc%22%3E%3CSPAN%3EI%20have%20tried%20this%20way%20as%20well%2C%20but%20it%20doesn't%20work%20either%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3EIn%20the%20library%20parameters%2C%20click%20on%20the%20column%20name%20to%20edit%20the%20column%20settings.%3C%2FLI%3E%3CLI%3EDisable%20%22Require%20that%20this%20column%20contains%3CSPAN%3Einformation%22%20option.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3EErase%20the%20default%20value%20and%20click%20save.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%3EAny%20idea%20on%20how%20to%20remove%20the%20value%20once%20it%20is%20set%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2486305%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EDefault%20Value%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2487971%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20delete%20column%20default%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2487971%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20is%20the%20data%20type%3F%20It%20might%20be%20a%20temporary%20bug.%20Are%20you%20able%20to%20delete%20the%20column%20completely%20and%20create%20if%20from%20scratch%3F%3CBR%20%2F%3E%3CBR%20%2F%3EYours%20sincerely%2C%3CBR%20%2F%3EAref%20Halmstrand%3C%2FLINGO-BODY%3E
New Contributor

When I go in ''default column value settings'', I am unable to delete a default value as I get this error message: "Please enter a valid default value. It must not be blank". I am also unable to unselect ''use this default''.

 

I have tried this way as well, but it doesn't work either: 

  1. In the library parameters, click on the column name to edit the column settings.
  2. Disable "Require that this column contains information" option.
  3. Erase the default value and click save.

Any idea on how to remove the value once it is set?

7 Replies
Hello,

What is the data type? It might be a temporary bug. Are you able to delete the column completely and create if from scratch?

Yours sincerely,
Aref Halmstrand

@ArefHalmstrand 

They're text type columns. I got this problem with many columns in all librairies and sites using default colomn values, so I'm thinking it's a temporary bug. Hopefully it will get fixed soon!

 

Deleting columns and creating again from scratch isn't an option. I'd lose all the data and that'd take too much time.

Strange ! I hope it works soon enough!

Tip, if you would like to recreate the exact same scenario, you could use PnP PowerShell to clone your list with all data.

Yours sincerely,
Aref Halmstrand

@GailTremblay I'm also having this issue. Have you found a solution?

2021-07-05 08_22_31-Window.png

Doing research online I found the screen shot above showing the option "Do not specify a default value for this location". The screen shot below is from my library. It's in French, but you can clearly see that  option is missing.

2021-07-05 08_25_27-Window.png

Hopefully Microsoft will look into this soon!

best response confirmed by GailTremblay (New Contributor)
Solution

@GailTremblay I found the button! If you open the URL in Edge or Internet Explorer it will appear. Seems to be a bug affecting Chrome users (no big deal, we only represent 65% of all internet users......)

 

Screenshot 2021-07-07 114956.png

Awesome, it's working! Good job and thank you for your help! :)