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