Today one of my colleagues was trying to create a list item in SharePoint Online using the PnP PowerShell.
Adding an item to a list
He was running the following command
Add-PnPListItem -List $dlist -Values @{"Title" = "$webTitle"}
and got the following error:
Add-PnPListItem : The object is used in the context different from the one associated with the object.
At line:4 char:5
+ Add-SPOListItem -List $dlist -Values @{"Title" = "$webTitle"}
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (:) [Add-SPOListItem], InvalidOperationException
+ FullyQualifiedErrorId : EXCEPTION,SharePointPnP.PowerShell.Commands.Lists.AddListItem
The -web switch
I noticed that the -web switch was missing
Add-PnPListItem -List $dlist -Values @{"Title" = "$webTitle"} -Web $web
So what happened?
When -Web is missing in PnP PowerShell Cmdlets the root site will be assumed as the site to be used.
Therefore Add-PnPListitem will run on the root site while the list specified lives in a sub site. This problem can also be avoid by running the connect cmdlet and specify the sub site as your connected site.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com
I also experienced this issue when trying to add list-item with managed metadata column that allows multiple values.