Sequence of the Sharepoint column activities

Sunny Rastogi 106 Reputation points
2022-04-19T06:43:18.457+00:00

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.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,074 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,767 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,591 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,435 questions
0 comments No comments
{count} votes

Accepted answer
  1. RaytheonXie_MSFT 32,801 Reputation points Microsoft Vendor
    2022-04-19T08:55:38.33+00:00

    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.


    0 comments No comments

0 additional answers

Sort by: Most helpful