We have a document library with thousands of files that are not properly categorized. On of the main reasons this happened is because the columns are not required to contain information.

Is it possible to go to these existing Columns and change them from Yes/No type information to choice type information that has "Require that this column contains information" enabled.

Is there any other option that I would go on to properly re-categorize these files ?

1 Answer 1


Yes you can change the required field at any point. It will not affect the existing documents until after someone tries to edit them, only at this point Sharepoint will force user to enter data for required fields.

If you have some pattern you can follow you could write PowerShell script to loop over the items and update the metadata (sometimes you can have indication of the metadata in the document name, sometimes info in different field may inform what other metadata should be)

Changing the boolean type to column is more problematic. Not sure if even supported after the creation. But you can deal with it differently. Create new column as choice enter whatever values you want (I guess Yes/No will still be an option) Then use either PowerShell/Designer Workflow/Flow to copy the values from the boolean to choice column. After that validate that everything is as you expect it, if yes then you can delete that boolean column.

  • I'm scared that something might go wrong or the document library will become a mess if I go and change a coulmn from Yes/No format to Choice format and enable the option for "Require that this column contains information" enabled"
    – Ed1995
    Commented Jun 12, 2019 at 15:17
  • Missed the point you want to change the type of the column, in that case yes you will loose the data you had in the column. I update my answer. Commented Jun 13, 2019 at 12:45

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.