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.
- Part 1: Get SharePoint Online web templates with PowerShell
- Part 2: Create new site in SharePoint Online with PowerShell
- Part 3: Create new web in SharePoint Online with PowerShell
- Part 4: Create new site columns in SharePoint Online with PowerShell
- Part 5: Create new content type in SharePoint Online with PowerShell
- Part 6: Get SharePoint Online list templates with PowerShell
- Part 7: Create new document library in SharePoint Online with PowerShell
- Part 8: Add content type to an SharePoint Online list with PowerShell
- Part 9: Create new view for a list in SharePoint Online with PowerShell
- Part 10: Set custom permissions for a site in SharePoint Online with PowerShell
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.
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
You will be asked to enter the password and press enter
Verify if the view has been created for the list / library
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”
