Introduction

In this blog we will about to add a column to a specific view in a specific list in multiple webs in SharePoint 2013 using PowerShell method. The list exists in every sub web. The view exists in every list. There are hundreds of sub webs that I need to traverse through and it will take time.

So for that I have created a small PowerShell script to work on this.

Steps

  1. Start your windows PowerShell on your computer.
  2. Right click and select Run as administrator option.
  3. Paste the below script on the PowerShell window and click the enter button.
  4. Check your SharePoint site page will be created successfully.
  1. # -------------------------------------------------------------------------
  2. # PURPOSE: ADD A COLUMN TO A SPECIFIED VIEW IN A SPECIFIED LIST IN MULTIPLE WEBS WITHIN A SITE COLLECTION.
  3. # PARAMETERS: 1. SITE COLLECTION URL; 2. COLUMNNAME; 3. LISTNAME; 4. VIEWNAME
  4. # -------------------------------------------------------------------------
  6. function Add-ColumnToView
  7. {
  8. Param(
  9. [Parameter(Mandatory=$true)]
  10. [string]$Url,
  11. [Parameter(Mandatory=$true)]
  12. [string]$ColumnName,
  13. [Parameter(Mandatory=$true)]
  14. [string]$ListName,
  15. [Parameter(Mandatory=$true)]
  16. [string]$ViewName
  17. ) # END PARAMS
  19. if ($Url)
  20. {
  21. $site = Get-SPSite $Url
  23. if ($site)
  24. {
  25. # GET THE SUB WEBS IN SITE COLLECTION
  26. $allWebs = $site.allwebs
  28. # LOOP THROUGH EACH SUB WEB
  29. foreach ($spweb in $allWebs)
  30. {
  31. try
  32. {
  33. # FIND THE LIST MATCHING THE $LISTNAME
  34. $list = $spweb.GetList($spweb.Url + "/Lists/" + $ListName)
  36. # CHECK IF THE LIST OBJECT EXISTS
  37. if ($list)
  38. {
  39. # GET THE SPECIFIC VIEW
  40. $view = $list.Views[$ViewName]
  42. # CHECK IF THE VIEW OBJECT EXISTS
  43. if($view)
  44. {
  45. # DELETE IF ALREADY EXIST
  46. while($view.ViewFields.ToStringCollection().Contains($ColumnName))
  47. {
  48. write-host (" Deleting Column From: " + $spweb.Url) -foregroundcolor yellow
  49. $view.ViewFields.delete($ColumnName)
  50. $view.Update()
  51. }
  53. # ADD COLUMN
  54. if(!$view.ViewFields.ToStringCollection().Contains($ColumnName))
  55. {
  56. write-host (" Adding Column To: " + $spweb.Url) -foregroundcolor green
  57. $view.ViewFields.add($ColumnName)
  58. $view.Update()
  59. }
  60. }
  61. }
  62. }
  63. catch [Exception]
  64. {
  65. write-host (" Error: " + $_.Exception.ToString()) -foregroundcolor red
  66. }
  67. }
  68. }
  69. else
  70. {
  71. write-host (" Error: " + "Site Collection Not available") -foregroundcolor white
  72. }
  73. $site.Dispose()
  74. }
  75. else
  76. {
  77. write-host (" Error: " + "Site Collection URL Not Specified.") -foregroundcolor white
  78. }
  79. } #END FUNCTION

Run the script with the required administrator privilege.

To verify that, go the Pages List in particular and make sure that available or not.