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 <SITE URL>
$list = $web.GetList("<LIST NAME>")
$list.GetItemById(<ITEM ID>)
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,
- [Solved] SharePoint Access Denied error editing Document Name
- See actual SharePoint error exception modify web.config
- SharePoint 2010 DataForm Unable to display this Web Part System.StackOverflowException
- SharePoint List redirect user after submitting form NewForm.aspx
- How to retrieve all SharePoint Online List Items using Rest API
- SharePoint workflow Canceled - Coercion Failed: Unable to transform the input lookup data into the requested type
- SharePoint error cannot connect to the configuration database
- Not receiving email notification alert in SharePoint Online workflow - Power Automate, FLOW
- How to create SharePoint List Item programmatically
- SharePoint CAML query error - The XML source is not correct
- Sharepoint Server 2016 installation Prerequisites with download links
- Sharepoint errors were found when compiling the workflow
- Send Email with attachment using SharePoint PowerShell, SMTP server
- Sign in as different user missing in SharePoint 2013
- SharePoint List excel import - This table exceeds the maximum number of supported rows
- SharePoint Managed Metadata Hidden Taxonomy List - TaxonomyHiddenList
- Changed AD user display name showing old name in SharePoint
- How to migrate SharePoint Designer 2010 workflow to Power Automate FLOW (Microsoft Office 365)
- SharePoint Server 2016 error Microsoft Office Online Server 2016 cant be installed on the same machine as a Microsoft SharePoint Server product
- Fix SharePoint 2019 installation error This product requires Visual C++ Redistributable Package for Visual Studio 2017
- Deploy SharePoint wsp solution package using PowerShell
- How to delete SharePoint List Item programmatically
- New-SPLogFile PowerShell - create new SharePoint log file
- SharePoint An unexpected error has occurred - Correlation ID and Merge-SPlogfile
- Change SharePoint search results FullTextSqlQuery RowLimit 10000
- SharePoint 2010 August 2015 Update KB3055049 - Duplicate Document ID issue bug fixed
- Bypass domain name for IIS site (SharePoint)
- SharePoint error - Your organization doesn't allow sharing with users from this domain. Please contact your IT department for help.
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher
- SharePoint list excel import error - Title is a required filed and can't be empty
- SharePoint error - An exception occurred when trying to issue security token: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms..
- Cannot load PowerApps form in SharePoint Online due to repeated authentication
- How to hide quick launch in SharePoint
- How to exclude results from SharePoint Search
- SharePoint Designer Workflow error - Coercion Failed: Input cannot be null for this coercion
- Get-ADUser PowerShell - Get AD user details using email address
- PowerShell iterate and get all SharePoint sites and sub sites
- SharePoint Server 2016 IT Preview Deprecated Removed features
- SharePoint excel error - A problem occurred while connecting to the server. If the problem continues, contact your administrator.
- Merge-SPlogfile PowerShell - SharePoint Correlation ID error
- SharePoint Server 2016 IT Preview - new improved Features and Enhancements
- Recover SharePoint if the SQL Server IP changes
- SharePoint PowerShell Merge-SPLogFile filter by time using StartTime EndTime
- SharePoint formula - Calculated columns cannot contain volatile functions like Today and Me
- [Solved] SharePoint System.IO.FileNotFoundException was unhandled
More Posts:
- reCaptcha Verification expired. Check the checkbox again - Html
- Android Studio Native typeface cannot be made error - Android
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists - MySQL
- Mac OS X Error: Could not create the Java Virtual Machine - Mac-OS-X
- Android [SDK Manager] The system cannot find the path specified - Android-Studio
- How to stop disable Facebook video autoplay during scroll - Facebook
- NewApi error : Finds API accesses to APIs that are not supported in all targeted API versions - Android
- JSON Text to JavaScript Object using eval() Example: JSON Tutorial - Json-Tutorial
- Failed to load the JNI shared library jvm.dll - Eclipse
- PHP Script to Upload Images to Server - PHP
- Get Device Screen Width and Height using javaScript - JavaScript
- How to get SharePoint List Item URL using PowerShell - SharePoint
- Your Android SDK is missing, out of date or corrupted SDK Problem - Android-Studio
- Send Email with attachment using SharePoint PowerShell - SharePoint
- How to add Newline to text in Android TextView - Android