Create View in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Create View in SharePoint

  • # Provide credentials over here
  • $creds = (New-Object System.Management.Automation.PSCredential "<<UserName>>",(ConvertTo-SecureString "<<Password>>" -AsPlainText -Force))
  •  
  • # Provide URL of the Site over here
  • # If you do not wish to pass credentials hard coded then you can use: -Credentials (Get-Credential). This will prompt to enter credentials
  • Connect-PnPOnline -Url http://MyServer/sites/MySiteCollection -Credentials $creds
  •  
  • ### Parameters ###
  •  
  • # -Title: Specify Title of the View
  •  
  • # -Fields: Specify Fields with comma(,) separated
  •  
  • # -List: The list object or name of the list
  •  
  • # -Query: You can optionally specify a query as mentioned below.
  • # Create one CAML query to filter list view and mention that query below
  •  
  • # -RowLimit: You can optionally specify row limit for the view
  •  
  • # -ViewType: Specify type of the view. Below are the options
  •  
  • # 1. none - The type of the list view is not specified
  •  
  • # 2. html - Specifies an HTML list view type
  •  
  • # 3. grid - Specifies a datasheet list view type
  •  
  • # 4. calendar- Specifies a calendar list view type
  •  
  • # 5. recurrence - Specifies a list view type that displays recurring events
  •  
  • # 6. chart - Specifies a chart list view type
  •  
  • # 7. gantt - Specifies a Gantt chart list view type
  •  
  • Add-PnPView -Title "View Name" -Fields "Body","Data Source", "Data Source" -List "New list" -Query "<Where><Eq><FieldRef Name = 'Title' /><Value Type = 'Text'>India</Value></Eq></Where>" -RowLimit 7 -ViewType Html 
  •  
  • Disconnect-PnPOnline

Thank you for reading this article. This code was tested in SharePoint 2013


© 2019 Code SharePoint