Sequence of the Sharepoint column activities

Question

Hi All,

Hope you are doing well!

I am working on one SharePoint clean-up activity and I have to run few PowerShell scripts to perform some column operations activities like renaming the column, making it multiline etc.. At the content type hub level or at site level, it will be great if you guys can suggest me the order of these activities in which I have to run the PS, below are the operations that I will be doing.

Create new columns
Rename columns
Set column as multivalue
Add new column to CT
Set column as optional in CT
Set column as required
Set column as hidden
Rename CT at CT hub
Rename CT at library level
Add CT if old CT exists
Update list properties
Update failed list items
Delete column in CT
Remove old CT from library
Hide taxonomy

From above activities which activity I will have to do first and which one I have to do secondly, etc

Please suggest on sequencing.

Answer 1

Hi @Sunny Rastogi ,
I will recommend you to set CT first then to add or remove column and finally set the properties of columns.
The first step should be following to remove CT first then create or rename CT

Remove old CT from library  
Rename CT at CT hub  
Rename CT at library level  
Add CT if old CT exists  
Update list properties  

Then you can update the columns in CT

Delete column in CT  
Create new columns  
Add new column to CT  
Rename columns  
Set column as multivalue  
Set column as optional in CT  
Set column as required  
Set column as hidden  

Finally you can update the item level and Hide taxonomy

Update failed list items  
Hide taxonomy  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---