Categories

x

Categories

Get All Items in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Get All Items 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
# Get Context
$clientContext = Get-PnPContext
$targetWeb = Get-PnPWeb
# Get the list object
$targetList = $targetWeb.Lists.GetByTitle("New list")
$clientContext.Load($targetList)
$clientContext.ExecuteQuery()
# Get the fields object. List all the columns separated with comma
$fields = "Id","Title"
$ListItems = Get-PnPListItem -List $targetList -Fields $fields
foreach($ListItem in $ListItems)
{
Write-Host "Item Id : " $ListItem["ID"] "Item Title : " $ListItem["Title"]
}
Disconnect-PnPOnline

Similar examples using different APIs:

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

We value your feedback:

Page URL:

Name:

Email:

Feedback: