Get List Items from a SharePoint View in PowerShell

Requirement: Get all list items from a SharePoint view in PowerShell

PowerShell to Get Items in a SharePoint List view

When you are working with SharePoint, there are times when you need to get a list of items from a view, rather than getting all of the items in the list. Whether you’re looking to export data or just need some way to automate getting data from a SharePoint view for reporting or other purposes, PowerShell is your answer! In this post, we’re going to take a look at how you can use PowerShell to get items from a SharePoint list view.

Here is the PowerShell script example to get list items from a SharePoint view:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Variables
$SiteUrl="https://intranet.crescent.com" 
$ListName = "Invoice"
$ViewName = "2014 Invoice"

#Get Web and List objects
$web = Get-SPWeb $SiteURL
$list = $web.Lists[$ListName]

#Get the View
$view = $list.Views[$ViewName]

#Get All Items from the View
$items = $list.GetItems($view)

foreach($item in $items)
{
    write-host $item["Title"]
}