SharePoint 2010: PowerShell Script – Create List / Add Column in Custom List / Add Column in the View

Scenario:

We need to create PowerShell script to create a custom list and a column in the list

Script:

try

{

$weburl = Read-Host “Please enter web url (like : http://sharepoint.ffaiz.com)”

$spweb = Get-SPWeb $weburl

$listTemplate = [Microsoft.SharePoint.SPListTemplateType]::GenericList

$spweb.Lists.Add(“My List”,”My list description”,$listTemplate)

write-host “List added in the Web : ” $spweb -foregroundcolor Yellow

 

$spList = $StartSite.Lists[“My Lists”]

$spFieldType = [Microsoft.SharePoint.SPFieldType]::Text

$spList.Fields.Add(“My Column”,$spFieldType,$false)

write-host “Column added in the list”

 

$spView = $spweb.GetViewFromUrl(“/Lists/”+ $spList.Name + “/AllItems.aspx”)

$spField = $spList.Fields[“My Column”]

$spView.ViewFields.Add($spField)

$spView.Update()

 

$spweb.Dispose()

}

catch [System.SystemException]

{

write-host “Execution stopped due to: “+$_.Message -foregroundcolor Red

}

Advertisements

2 Comments »

  1. Naganathan said

    We had some issue while using the above code
    1. $StartSite is null-referenced
    2. $spView = $spweb.GetViewFromUrl( “/Lists/”+ $spList.Name + “/AllItems.aspx) is not working

    so we have modified the above code as follows
    ————————————————————
    $spweburl = Read-Host “Please enter web url (like : http://sharepoint.ffaiz.com)”
    $spweb = Get-SPWeb $SiteUrl
    $docLibrary = $spweb.Lists[$Library]
    $spweb = Get-SPWeb $SiteUrl
    $spList = $spweb.Lists[$docLibrary ]
    $spFieldType = [Microsoft.SharePoint.SPFieldType]::Text
    $spList.Fields.Add(“ColumnNew”,$spFieldType,$false)
    write-host “Column added in the list”
    $spView = $spweb.GetViewFromUrl( $spweburl +“/Lists/”+ $spList.Name + “/AllItems.aspx)
    $spField = $spList.Fields[“ColumnNew”]
    $spView.ViewFields.Add($spField)
    $spView.Update()
    $spweb.Dispose()
    ———————————————————–

  2. Please refer my post to create list, fields and view SharePoint list using powershell script:
    http://sharepointquicksolutions.blogspot.in/2014/06/create-sharepoint-list-using-powershell.html

    http://sharepointquicksolutions.blogspot.in/2014/06/create-view-in-list-using-powershell.html

    Please provide your valuable feedback.

RSS feed for comments on this post · TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: