I am searching for a better way to reset/remove default column values from specific folders using PowerShell.

I realize that it can be done through the library settings but I need to do this for about 50 folders with 4+ values per folder. So manually is not a very good option.

Has anyone dealt with this before?

I considered using the cmdlet Set-PnPDefaultColumnValues and just leaving the value blank(""). It will not allow me to use "" I could use " " but that does not work for managed metadata. There must be better way to remove default column values. I find it hard to believe that it would be a one way road where you can set it with powershell but cannot reset/remove.


2 Answers 2


You could try Clear-PnPDefaultColumnValues

  • I did not even realize that one was available, for some weird reason it does not show up in the list when I am trying to use it in ISE, Thank you for making this aware to me. I am going to explore this option. Jun 3, 2019 at 23:40
  • No worries.It should work although I have come across and issue where it does not work when the field is a managed metadata one.
    – FizzyGood
    Jun 4, 2019 at 7:54
  • Okay, thank you, I am actaully trying to use it for managed metadata so I may have to explore another option for that column Jun 4, 2019 at 15:43

Set-PnPDefaultColumnValues seems the best way to go. Combine it with Get-PnPFolder and you're ready to go.

Your Answer

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

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