Below code will help us on below scenerios:
- Create a new list in SharePoint using powershell
- Check whether the list exits or not?
- Create a new field in SharePoint list using powershell
- Add items to the list in SharePoint using powershell?
Please correct the syntax as below for the scripts.
e.g: Replace displayname=""+ $DisplayName +"" to DisplayName='"+ $DisplayName +"'
================================================================================== $siteURL= "your site URL" $ListName ="List Name" ================================================================================== $docSite = new-object Microsoft.SharePoint.SPSite($siteURL) $docWeb = $docSite.OpenWeb() $TemplateType = $docWeb.ListTemplates["Custom List"] function Create-SPList([string]$listName, [string]$description) { $exLst = $docWeb.Lists[$listName] //Create new list if already doesn't exists if($exLst -eq $null) { Write-Host "`n List does not exist. Creating $listName list`n" [void]$docWeb.Lists.Add($listName, $description, $TemplateType) $docWeb.Update() } } ================================================================================== function Add-SPSingleLineOfTextField([string]$listName, [string]$DisplayName, [string]$Name, [string]$Required, [string]$DateType) { $OpenList = $docWeb.Lists[$listName] $firstNameColXml = "" $OpenList.Fields.AddFieldAsXml($firstNameColXml,$true, [Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView) } function Add-SPListItems([string]$listName, [string]$Name, [string]$Value) { $OpenList = $docWeb.Lists[$listName] $newItem = $OpenList.items.add() $newitem["Title"] = $Name $newitem["Value"] = $Value $newitem.update() } ================================================================================== //To create a new list name Write-Host "`n create $ListName list `n" Create-SPList -listName $ListName -description "List Description" //To create a new field name in list Write-Host "`n Adding fields to the $ListName list `n" Add-SPSingleLineOfTextField -listName $ListName -Name Value -DisplayName Value -Required FALSE //To add items to the list Write-Host "`n Adding items to the $ListName list `n" Add-SPListItems -listName $ListName -Name "Name1" -Value "Value1" Add-SPListItems -listName $ListName -Name "Name2" -Value "Value2" ===================================================================================
Please let me know if faced any issues while using the above scripts and provide your valuable feedback
Thanks,
Sasi Kumar Reddy
No comments:
Post a Comment