Post

Create new view for a list in SharePoint Online with PowerShell
This is part 9 of 10 where we will be creating a new view for a list in SharePoint Online with PowerShell. This is part of the following series: We will be collecting all available web templates in part 1 so we can use this to create a new site in part 2. In part […]

This is part 9 of 10 where we will be creating a new view for a list in SharePoint Online with PowerShell. This is part of the following series:

We will be collecting all available web templates in part 1 so we can use this to create a new site in part 2. In part 3 we will be creating a web for the newly created site. We then want to create a couple of site columns in part 4 which we will combine to a content type in part 5. This content type will be added (part 8) to our newly created document library in part 7 using a list template from part 6. After everything is set we will be setting the view in part 9 for this list to show the added columns we got from adding the content type. We only want to set permissions for myself so I’ll will be breaking the inheritance and setting permissions in part 10.

 Create new view for a list in SharePoint Online

This script will first create a new view and will add specified columns to this view. You can create an array using a .CSV file but I know the column names so I will create my array in the script.

This script will update the library to enable multiple content types and then add the newly created content type. We will first start by opening the SharePoint Online Management Shell as administrator which can be downloaded at https://www.microsoft.com/en-us/download/details.aspx?id=35588.

image

You will need to change the first variables to match your Office 365 tenant and copy this bit to PowerShell.

function new-SPOnlineView {
 #variables that needs to be set before starting the script
 $siteURL = "https://spfire.sharepoint.com/sites/blogdemo"
 $adminUrl = "https://spfire-admin.sharepoint.com"
 $userName = "mpadmin@spfire.onmicrosoft.com"
 $listName = "finance"
 $viewName = "Blog View"
 $viewColumns = "Name", "Blog Text", "Blog Number", "Blog User", "Created", "Modified"
 
 # Let the user fill in their password in the PowerShell window
 $password = Read-Host "Please enter the password for $($userName)" -AsSecureString
 
 # set credentials
 $SPOCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userName, $password)
  
 # Creating client context object
 $context = New-Object Microsoft.SharePoint.Client.ClientContext($siteURL)
 $context.credentials = $SPOCredentials
 $web = $context.web
 $list = $web.lists.GetByTitle($listName)
 $context.load($list)
 
 #Creating new view using ViewCreationInformation (VCI)
 $vci = New-Object Microsoft.SharePoint.Client.ViewCreationInformation 
 $vci.Title = $viewName
 $vci.ViewTypeKind= [Microsoft.SharePoint.Client.ViewType]::None
 $vci.RowLimit=50
    $vci.SetAsDefaultView=$true  
 $vci.ViewFields=@($viewColumns)</pre>
#adding view to list
$listViews = $list.views
$context.load($listViews)
$addListView = $listViews.Add($vci)
$context.load($addListView)

#send the request containing all operations to the server
try{
$context.executeQuery()
write-host "info: View created succesfully" -foregroundcolor green
}
catch{
write-host "info: $($_.Exception.Message)" -foregroundcolor red
}
}
new-SPOnlineView

image

You will be asked to enter the password and press enter

image

Verify if the view has been created for the list / library

image

Tips

You can find more properties for the ViewCreationInformation class at https://msdn.microsoft.com/EN-US/library/office/microsoft.sharepoint.client.viewcreationinformation_members.aspx.

The columns are case-sensitive so make sure you type these correctly, otherwise you will see an error “column does not exist”

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archive