Categories

x

Categories

Latest Posts

Power Platform Interview Questions

Azure Tutorials for Beginners

Set-PnPListItem: Update ListItem in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Update ListItem in SharePoint

Using PnP (Pattern and Practice) PowerShell commands, you can access and manipulate SharePoint objects easily.
Prerequisite: You have to install cmdlets to work in PnP PowerShell.

How to run PnP PowerShell command in SharePoint?

First, open powershell ise.

powershell ise

Make sure you run it in Administrator Mode.
Now, copy and paste the code mentioned below and click on Run Script as shown in the screenshot.

powershell ise run command

# 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 Item using CAML Query
# -PageSize = 1, This is item limit. This will ensure that only 1 row is returned.
$ListItem = Get-PnPListItem -List "New list" -Query "<View><Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>New Title</Value></Eq></Where></Query></View>" -PageSize 1
# Update List Item
Set-PnPListItem -List "New list" -Identity $ListItem -Values @{"Title" = "Test Title"; "Body"="Test Body"}
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:

Name is a mandatory field

Email:

Email is a mandatory field
Email format is not corrent

Suggestion:

Suggestion is a mandatory field