Forum Discussion
Solved
Unable to delete column default value
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:
- In the library parameters, click on the column name to edit the column settings.
- Disable "Require that this column contains information" option.
- Erase the default value and click save.
Any idea on how to remove the value once it is set?
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......)
GailTremblay I'm also having this issue. Have you found a solution?
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.
Hopefully Microsoft will look into this soon!
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......)
- 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 HalmstrandThey'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
