How to query and retrieve SharePoint List Item by Itemd ID using PowerShell / Management Shell / PnP PowerShell ?
There are multiple ways
GetItemById[]
Get-PnPListItem [PnP]
Use below PowerShell command to retrieve SharePoint List Item using the Item ID. This uses GetItemById[] which takes in the ItemId as a parameter.
You can modify the below code for other requirements but the core logic remains the same.
Using GetItemById[]
$web = Get-SPWeb $list = $web.GetList[""] $list.GetItemById[]where,SITE URL = URL of SharePoint Site [string]
LIST NAME = Name of SharePoint List [string]
ITEM ID = Number of Item Id [integer]
Using PnP Get-PnPListItem
Get-PnPListItem -List [List Name] -Id [ID]Using GetItemById[] for SharePoint Online
$list = $Context.web.Lists.GetByTitle["[List Name]"] $listItem = $List.GetItemById[[ID]] $context.Load[$listItem] $context.ExecuteQuery[]You can further update the script further to filter and query only required columns/fields.
More Posts related to SharePoint,
- Managed Metadata error - The data returned from the tagging UI was not formatted correctly
- How to generate client id and secret to register SharePoint App with OAuth
- Create SharePoint Site Collection with new Content database in existing web application
- Fix Error 2711 SQL RBS client - The installer has encountered an unexpected error. The specified Feature name ['Docs'] not found in Feature table
- How to exclude results from SharePoint Search
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher
- [Solved] SharePoint Access Denied error editing Document Name
- Recommended size and resolution for SharePoint Online Site logo
- SharePoint Server 2016 IT Preview - new improved Features and Enhancements
- Restore deleted Office 365 SharePoint group site
- SharePoint An unexpected error has occurred - Correlation ID and PowerShell Merge-SPlogfile
- [Solved] SharePoint Search Internal server error exception
- SharePoint CAML query error - The XML source is not correct
- How to hide quick launch in SharePoint classic site
- Not receiving email notification alert in SharePoint Online workflow - Power Automate, FLOW
- Change SharePoint search results FullTextSqlQuery RowLimit 10000
- Fix Power BI error Access to the resource is forbidden when connecting SharePoint Online List as data source
- [Fix] Restricted View permission level missing in SharePoint Online site library
- How to upload file programmatically to SharePoint Document Library using Server Object Model C# .Net
- How to create classic site in SharePoint Online
- That did'nt work, Issue type User not in directory - SharePoint external access error
- Merge-SPlogfile PowerShell - SharePoint Correlation ID error
- Fix Power BI 404 not found error when connecting SharePoint Online List as Data Source
- SharePoint Server 2016 IT Preview Deprecated Removed features
- SharePoint error - An exception occurred when trying to issue security token: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms..
More Posts:
- Hurry! Uninstall Adobe Flash Player - End Of Life, support end in December 2020 - News
- [Solved] Notepad++ Menu Bar Missing - NotepadPlusPlus
- How to display Toast in a thread : Android - Android
- PowerShell iterate and get all SharePoint sites and sub sites - SharePoint
- 30+ Zoom video communications application shortcuts for macOS - MacOS