Creating Site Column add to Contenttype(Creation) add to list(Creation) from CSV file

######################### Add SharePoint PowerShell Snapin ###############################################
 
 if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )
 
 {
 
 Add-PSSnapin Microsoft.SharePoint.Powershell
 
 }
 


 ########################### End of Add SharePoint PowerShell Snapin ##################################
 
 ######################## Set Execution Path ################################################
 
 $scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent
 
 Set-Location $scriptBase
 
 ################################# End of Set Execution Path #################################
 
 ################################# Functions #####################################################
 
  #$myCType = $null


 function CreateField([string]$ColumnName, [string] $ColumnInternalName, [string] $DataTypes, [string] $DatatypeOptions, [string] $LookupListNM, [string] $LookupColumnNM)
 
 {

 try{




 if($DataTypes-eq "singleline")
{

#SingleLine
$singleline=$fields.AddFieldAsXml("<Field Type='Text' DisplayName='$ColumnName' Required='False' MaxLength='255' Name='$ColumnInternalName' />",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($singleline)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: SingleLine of Text field created successfully"

}
if($DataTypes-eq "multipleline")
{

#MulipleLine
if($DatatypeOptions -eq "plaintext")
{
#PlainText
$plaintxt=$fields.AddFieldAsXml("<Field Type='Note' DisplayName='$ColumnName' Required='FALSE' NumLines='6' RichText='FALSE'
Sortable='FALSE' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($plaintxt)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: MultiLine of Plain Text field created successfully"

}
if($DatatypeOptions -eq "richtext")
{
#RichText
$richtxt=$fields.AddFieldAsXml("<Field Type='Note' DisplayName='$ColumnName' Required='FALSE'   NumLines='6'
RichText='TRUE' RichTextMode='Compatible' Sortable='FALSE' Name='$ColumnInternalName' />",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($richtxt)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: MultiLine of Rich Text field created successfully"

}
if($DatatypeOptions -eq "enhancedrichtext")
{
#EnhancedRichText
$enhancetxt=$fields.AddFieldAsXml("<Field Type='Note' DisplayName='$ColumnName' Required='FALSE'  NumLines='6' RichText='TRUE'
RichTextMode='FullHtml' IsolateStyles='TRUE' Sortable='FALSE' Name='$ColumnInternalName' />",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($enhancetxt)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: MultiLine of EnhancedRich Text field created successfully"

}

}

#Choice
if($DataTypes -eq "choice")
{
if($DatatypeOptions -eq "Dropdown")
{
#echo dropdown
#Dropdown
$dropdownfld=$fields.AddFieldAsXml("<Field Type='Choice' DisplayName='$ColumnName' Required='FALSE' Format='Dropdown'
FillInChoice='FALSE' Name='$ColumnInternalName'>
            <Default>MyChoice1</Default>
            <CHOICES>
                <CHOICE>MyChoice1</CHOICE>
                <CHOICE>MyChoice2</CHOICE>
            </CHOICES>
           </Field>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($dropdownfld)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Choice field in Dropdown created successfully"

}
if($DatatypeOptions -eq "Radiobutton")
{
#echo "radio"
#Radiobutton
$radiobut=$fields.AddFieldAsXml("<Field Name='$ColumnInternalName' Type='Choice' DisplayName='$ColumnName' Format='RadioButtons'
        FillInChoice='FALSE' >
            <Default>MyChoice1</Default>
            <CHOICES>
                <CHOICE>MyChoice1</CHOICE>
                <CHOICE>MyChoice2</CHOICE>
            </CHOICES>
        </Field>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($radiobut)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Choice field in RadioButton created successfully"

}
if($DatatypeOptions -eq "Checkboxes")
{
#echo "Check"
#Checkboxes(allow multiple selection)
$checkbxfld=$fields.AddFieldAsXml("<Field Name='$ColumnInternalName' Type='MultiChoice' DisplayName='$ColumnName' FillInChoice='FALSE'>
                    <Default>MyChoice1</Default>
                    <CHOICES>
                        <CHOICE>MyChoice1</CHOICE>
                        <CHOICE>MyChoice2</CHOICE>
                    </CHOICES>
                </Field>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($checkbxfld)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Choice field in Checkbox created successfully"

}

}
if($DataTypes -eq "number")
{
#Number Field
$numfld=$fields.AddFieldAsXml("<Field Type='Number' DisplayName='$ColumnName' Required='FALSE' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($numfld)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Number field created successfully"

}
#Date&Time
if($DataTypes -eq "datetime")
{
if($DatatypeOptions -eq "Dateonly")
{
#DateOnly
$dateoly=$fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='$ColumnName' Format='DateOnly'   Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($dateoly)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Date Only field created successfully"

}
if($DatatypeOptions -eq "Date&Time")
{
#DateandTime
$datetime=$fields.AddFieldAsXml("<Field Type='DateTime' DisplayName='$ColumnName' Format='DateTime'   Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($datetime)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Date and Time field created successfully"
}

}
if($DataTypes -eq "yesrno")
{
#Yes r No
$yrnfld=$fields.AddFieldAsXml("<Field Type='Boolean' DisplayName='$ColumnName' Name='$ColumnInternalName'>
           <Default>1</Default>
           </Field>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($yrnfld)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Yes or No field created successfully"

}
if($DataTypes -eq "peoplergroup")
{
#People or Group
if($DatatypeOptions -eq "PeopleOnly")
{
#PeopleOnly
$peoponly=$fields.AddFieldAsXml("<Field Type='User' DisplayName='$ColumnName' List='UserInfo' ShowField='ImnName'
UserSelectionMode='PeopleOnly' UserSelectionScope='0' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($peoponly)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: People Only field created successfully"

}
if($DatatypeOptions -eq "People&Group")
{
#People&Group
$peopgrp=$fields.AddFieldAsXml("<Field Type='User' DisplayName='$ColumnName' List='UserInfo' ShowField='ImnName'
UserSelectionMode='PeopleAndGroups' UserSelectionScope='0' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($peopgrp)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: People and Group field created successfully"

}

}
if($DataTypes -eq "hyperlinkRpicture")
{
if($DatatypeOptions -eq "Hyperlink")
{
#Hyperlink
$hyperlnk=$fields.AddFieldAsXml("<Field Type='URL' DisplayName='$ColumnName' Format='Hyperlink' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($hyperlnk)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Hyperlink field created successfully"

}
if($DatatypeOptions -eq "Picture")
{
#Picture
$picturefld=$fields.AddFieldAsXml("<Field Type='URL' DisplayName='$ColumnName' Format='Image' Name='$ColumnInternalName'/>",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($picturefld)
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Picture field created successfully"

}

}
if($LookupListNM -ne $null)
{

try{
$LookupLisNamecon = $Context.Web.Lists.GetByTitle($LookupListNM)
$Context.Load($LookupLisNamecon)
$Context.ExecuteQuery()
}
catch
{

}

if($DataTypes -eq "lookup")
{

 try
            {
          
  $field = $fields.GetByInternalNameOrTitle($ColumnName)
  $Context.Load($field)
  $Context.ExecuteQuery()

  Write-Host "Exception calling "ExecuteQuery" with "0" argument(s): "A duplicate field name "$ColumnName" was found."so create site column in different name" -ForegroundColor Red

  }
 catch
   {
#Lookup
$castToMethodGeneric = [Microsoft.SharePoint.Client.ClientContext].GetMethod("CastTo")
$castToMethodLookup = $castToMethodGeneric.MakeGenericMethod([Microsoft.SharePoint.Client.FieldLookup])

#$internalName = "LookupWithStaticName"
$displayName = $ColumnName
$displayFieldForLookup = $LookupColumnNM

$newLookupField = $fields.AddFieldAsXml("<Field DisplayName='$ColumnInternalName' Type='Lookup' Mult='FALSE' />",$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView)
$Context.Load($fields)
$Context.Load($newLookupField)
$lookupField = $castToMethodLookup.Invoke($Context, $newLookupField)
$lookupField.Title = $displayName
$lookupField.LookupList = $LookupLisNamecon.Id
$lookupField.LookupField = $displayFieldForLookup

$lookupField.Update()
$Context.ExecuteQuery()
Write-Host "ColumnName:" $ColumnName "Type: Lookup field created successfully"
        return
   }
}

}


}
catch
{
Write-Host ($_.Exception.Message + "so create site column in different name") -ForegroundColor Red

}
}






 function contenttypecreation([string]$ContentTypeNM, [string]$ContentGroupNM )
 {
 try{



 # add a new content type - first, let's get all current ctypes
$web = $Context.Web     
$contentTypes = $web.ContentTypes     
$Context.Load($web)    
$Context.Load($contentTypes)
$Context.ExecuteQuery()
          
# create a new content type object
$cType = New-Object Microsoft.SharePoint.Client.ContentTypeCreationInformation      
$cType.Name = $ContentTypeNM
$cType.ParentContentType = $Context.Web.ContentTypes.GetById("0x01")

$cType.Group = $ContentGroupNM
$myCType = $contentTypes.Add($cType)
#$Context.ExecuteQuery()

$Context.Load($myCType)
$Context.ExecuteQuery()
Write-Host "Content Type " $ContentTypeNM " has been added to " $SiteURL

}
catch
{
 Write-Host $_.Exception.Message "try to create the content type in different name" -ForegroundColor Red
}

 }

 
 function AddSiteColumnsToContentTypes([string]$ColumnName, [string]$ContentTypeNM)
 
 {

   try
        {

  #Check whether site column exists in site collection columns

  try
            {
          
  $field = $fields.GetByInternalNameOrTitle($ColumnName)
  $Context.Load($field)
  $Context.ExecuteQuery()
  #Write-Host "Site column" $ColumnName "exist" -ForegroundColor Cyan
 
 
   }
 catch
   {
        return
   }
   #Getting content types from the root site
  $contentTypes = $Context.Site.RootWeb.ContentTypes
  $Context.Load($contentTypes)
  $Context.ExecuteQuery()

   #Getting specified content type in which we need to add a column
   $contentType = $contentTypes | Where {$_.Name -eq $ContentTypeNM}

   #Get Fields from the content type
   $fieldCollection = $contentType.Fields
   $Context.Load($fieldCollection);
   $Context.ExecuteQuery();

   #Check if field already exists in content type or not
   $IsFieldExists = $false
            foreach($fld in $fieldCollection)
            {
               # Write-Host $fld.get_InternalName()
                if($fld.get_InternalName() -eq $ColumnName){
                    $IsFieldExists = $true
                }
            }
    if($IsFieldExists -eq $false)
            {
                #Get all the columns associated with content type
   
                $fieldRefCollection = $contentType.FieldLinks;
                $Context.Load($fieldRefCollection);
                $Context.ExecuteQuery();
               
                #Add a new column to the content type

                Write-Host "Adding site column " $ColumnName "to the content type" -ForegroundColor Cyan
                $fieldReferenceLink = New-Object Microsoft.SharePoint.Client.FieldLinkCreationInformation
                $fieldReferenceLink.Field = $field;
                $contentType.FieldLinks.Add($fieldReferenceLink);
               
               
                $contentType.Update($true)
                $Context.Load($contentType)
                $Context.ExecuteQuery()
               
                Write-Host "Field added successfully" -ForegroundColor Green
            }
            else
            {
                Write-Host "Site Column " $ColumnName " already exists in content type" -ForegroundColor Red
            }
          }
        catch
        {
            Write-Host ("Error while adding field in contet type. Error -->> " + $_.Exception.Message ) -ForegroundColor Red
        }
 
 }

 function CreatingList([string] $ListName)
 {
 try{
 $ListInfo = New-Object Microsoft.SharePoint.Client.ListCreationInformation
$ListInfo.Title = $ListName
$ListInfo.TemplateType = "100"
$List = $Context.Web.Lists.Add($ListInfo)
$List.Description = $ListName
$List.Update()
$Context.ExecuteQuery()
Write-Host "List Name:" $ListName "created successfully"
}
catch{

Write-Host $_.Exception.Message -ForegroundColor Red
}

 }
 function AddingCTtoList([string] $ListName, [string] $ContentTypeNM)
 {

 try
     {
 #Getting content types from the root site
  $contentTypes = $Context.Site.RootWeb.ContentTypes
  $Context.Load($contentTypes)
  $Context.ExecuteQuery()

   #Getting specified content type in which we need to add a column
   $contentType = $contentTypes | Where {$_.Name -eq $ContentTypeNM}
   $CTID=$contentType.Id

   #Load List

  $Context.Load($Context.Web.Lists)
  $Context.ExecuteQuery()

 $contentType=$Context.Web.ContentTypes.GetById($CTID)

  $Context.Load($contentType)

  $contentType.Id

 $ll=$Context.Web.Lists.GetByTitle($ListName)
 $Context.load($ll)
 $Context.load($ll.ContentTypes)
 $Context.ExecuteQuery()
  $ll.ContentTypesEnabled=$true
 $AddedContentType=$ll.ContentTypes.AddExistingContentType($contentType)
 $ll.Update()
 
      
         $Context.ExecuteQuery()
         Write-Host "Adding content type " $contentType.Name " to " $ll.Title
     }
     catch
     {
        Write-Host "This content type already exists, "$_.Exception.Message "so choose another content type" -ForegroundColor Red
     }

 }

 function ReorderContentTypesInList()
{
    param(
       
        [Parameter(Mandatory=$true)][string]$listName,
        [Parameter(Mandatory=$true)][string]$ContentTypeNM
    )

    begin{
        try
        {

        $ContentTypeNamesInOrder= $ContentTypeNM
      
            #Retrieve List
            #
            $list = $Context.Web.Lists.GetByTitle($listName)
            $Context.Load($list)
            $Context.ExecuteQuery()


            #Get Content Types from a list
            #
            $contentTypes = $list.ContentTypes
            $Context.Load($contentTypes)
            $Context.ExecuteQuery()

           # Write-Host $contentTypes.Name
        }
        catch{
            Write-Host "Error while getting context. Error -->> "  + $_.Exception.Message -ForegroundColor Red
        }
    }
    process{
        try
        {

            #Making generic list of content type ids in passed order
            #
            $ctList = New-Object System.Collections.Generic.List[Microsoft.SharePoint.Client.ContentTypeId]
            Foreach($ct in $ContentTypeNamesInOrder){
                $ctToInclude = $contentTypes | Where {$_.Name -eq $ct}
                $ctList.Add($ctToInclude.Id)
            }


            #Updating content type order
            #
            $list.RootFolder.UniqueContentTypeOrder = $ctList
            $list.Update()
            $Context.Load($list)
            $Context.ExecuteQuery()

            Write-Host "Content Type is set to default successfully!!!" -ForegroundColor Green

        }
        catch
        {
            Write-Host ("Error while reordering content types in a list. Error -->> " + $_.Exception.Message) -ForegroundColor Red
        }
    }
    end{
        $Context.Dispose()
    }
}



 ################### End of Functions ###############################################


 #Add references to SharePoint client assemblies and authenticate to Office 365 site - required for CSOM
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Taxonomy.dll"

 $question = Read-Host "Are you proceed with On-Premises or Office365? If On-Premises Type ON Else Type OFF for Office365"


 If (($question -eq "ON") -or ($question -eq "on") -or ($question -eq "On") -or ($question -eq "oN"))
{

$SiteURL = Read-Host -Prompt "Please enter the Site URL"
$CSVFileName=Read-Host -Prompt "Please enter Your CSV file Name"
#Bind to site collection
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)


if (!$Context.ServerObjectIsNull.Value)
{
    Write-Host "Connected to SharePoint On-Premises site: '$siteUrl'" -ForegroundColor Green
   
    $web = $Context.Web  
    $Context.Load($web)  
    $Context.ExecuteQuery()
 
}
# retrieve all site columns (fields)
$web = $Context.Web   
$fields = $web.Fields        
$Context.Load($web)       
$Context.Load($fields)
$Context.ExecuteQuery()

}



Elseif (($question -eq "OFF") -or ($question -eq "off") -or ($question -eq "Off") -or ($question -eq "oFF"))
{


$User = Read-Host -Prompt "Please enter your Login Name"
$Password = Read-Host -Prompt "Please enter your password" -AsSecureString
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($User,$Password)
$SiteURL = Read-Host -Prompt "Please enter the Site URL"
$CSVFileName=Read-Host -Prompt "Please enter Your CSV file Name"

#Bind to site collection
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($User,$Password)
$Context.Credentials = $Creds

if (!$Context.ServerObjectIsNull.Value)
{
    Write-Host "Connected to SharePoint Online site: '$siteUrl'" -ForegroundColor Green
   
    $web = $Context.Web  
    $Context.Load($web)  
    $Context.ExecuteQuery()
 
}
# retrieve all site columns (fields)
$web = $Context.Web   
$fields = $web.Fields        
$Context.Load($web)       
$Context.Load($fields)
$Context.ExecuteQuery()

}
Else
{
    Write-Host -BackgroundColor White -ForegroundColor Red "INVALID ENTRY! Please try again."
    Break
    #Exit
}


 #################Creating Site columns##########################################################
 
 $SiteColumnCreationDetailsCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $SiteColumnCreationDetailsCSV | where {
 
 CreateField $_.ColumnName $_.ColumnInternalName $_.DataTypes $_.DatatypeOptions $_.LookupListNM $_.LookupColumnNM

 }


 #################Creating Content Type#########################################################

 $contenttypeCreationCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $contenttypeCreationCSV |select -first 1 | where {
  if(($_.ContentTypeNM -ne $null) -and ($_.ContentGroupNM -ne $null))
  {
 contenttypecreation $_.ContentTypeNM $_.ContentGroupNM
 }
 }


 #################Adding site column to content type#############################################
 
 $SiteColumnReferencedContentTypesCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $SiteColumnReferencedContentTypesCSV | where {
 
 AddSiteColumnsToContentTypes $_.ColumnName  $_.ContentTypeNM
 
 }
 

###################Creating List##################################

 $creatinglistCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $creatinglistCSV |select -first 1 | where {
 
 CreatingList $_.ListName
 
 }


 #################Adding Content Type to List#####################

$addingCTtolistCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $addingCTtolistCSV |select -first 1 | where {
 
 AddingCTtoList $_.ListName $_.ContentTypeNM
 
 }


 #################Reordering Content Type in the List#####################

$reorderingCTinlistCSV = $scriptBase + "\" + $CSVFileName
 
 import-csv $reorderingCTinlistCSV |select -first 1 | where {
 
 ReorderContentTypesInList $_.ListName $_.ContentTypeNM
 
 }

Sample CSV: