Latest Posts

Add-PnPView: Create View in SharePoint using PowerShell

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

Using PnP (Pattern and Practice) PowerShell commands, you can access and manipulate SharePoint objects easily.
Prerequisite: You have to install cmdlets to work in PnP PowerShell.

Make sure you run it in Administrator Mode.
Now, copy and paste the code mentioned below and click on Run Script as shown in the screenshot.

# 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

Page URL:

Name:

Name is a mandatory field

Email:

Email is a mandatory field
Email format is not corrent

Suggestion:

Suggestion is a mandatory field