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

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


We value your feedback:

Page URL:

Name:

 

Email:

 
 

Feedback:

 

© 2019 Code SharePoint