Work with SharePoint Online lists with PNP PowerShell 

This is hands down the best tutorial I have come across

Thanks Shane, so useful! I have learning SPO powershell right now and your video has helped me to complete one of job assignments. Thanks again for clear and educational examples!

Hey Shane, I know your content is years old at this point but it's still great! One request, now that RU-vid supports chapters in videos, if you could go back through your series of videos and add chapter data (e.g. for each new thing you show how to do), that would be super, super helpful! For example, I often need to come to a video like this and review just how to move items from one list to another, so jumping to that section would save me 15 minutes... and I'm sure you can see how that capability would compound over time!

Shane, We use Duo MFA in front of our Office 365. Using the Connect-SPOService -url -admin.sharepoint.com works as expected and brings up the newer Office 365 login page and redirects us to our Duo Authentication Gateway login page. We do not capture the credentials because it does not appear to work with Duo MFA enabled. However, when using the Connect-PnPOnline -url .sharepoint.com it brings up the older style login screen similar to your video when you capture the credentials. However, this last command when we type in our correct credentials into the older style login box we receive a (500) Internal Server Error in PowerShell after about a minute which makes sense because using the Connect-SPOService command it will bring us to our Duo Authentication Gateway login page which then after 2FA login success redirects and closes the newer style login window indicating success. Do you have any insight on using PowerShell with MFA enabled on Office 365 specifically with Duo if possible? Thank you, Collin

Hi Shane, Awsome videos .. Just need little help how can avoid moving duplicate item. like skip the item if its already there in the destination.

Another clear and helpful video. Where I ran into problems with my own Lists was trying to incorporate lookup columns, suppose for the sake of argument that the column "color" was a lookup . How would the piped | where-object {$_["color"] -eq "red"} look? I know you try not to use look up columns Shane, but on occasion you are just landed with them.

In regards to list item deletion. Alternative way would be to do MS Access -> DELETE * FROM [Lst_Name]

THANKS SHANE. THE ONLY F*CKING USEFUL TUTORIAL FOR MANAGING PS ONLINE THROUGH POWERSHELL. YOU'RE THE BOSS

Hi Shane, I love your videos but I cant't seem to get pass the login step because Power shell doesn't seem to recognize my credential. any suggestion? Thank you!

Hi Shane, your video was helpful and much appreciated. I have a couple of queries how to update a particular listitems in a list? how to remove particular listitems in a list???

Nice Video, how to fetch Project online oData into SharePoint using power automate or PowerShell.Please make the video on this

Thanks for the videos, I have created a simple SharePoint list and created a power app base on that list, my question is when I add the new column in SharePoint list it doesnt show the new column in my app, I have refresh the data source as well and still nothing.

Hi Shane. Thanks for tutorial it was great start to PnP. I have question- how to copy element with attachment to different list with the same columns? Thanks in advance.

really thanks for this great video but can you give us the link to the cmdlets showing in the video !!

Hi Shane, The SharePoint PowerShell videos are amazing, have helped me a lot. I am trying to upload data from csv file to SharePoint Online list, error handling Try-Catch doesn't seem to pick up the errors. Are there anyways to pick up the line items from csv which errors?

Is there an online resource of general pnp powershell documentation/samples you can recommend?

Please suggest how to add link to documents In document library using PNP powershell

Hello, this video is really helpful but I have a query....I want to set a default value for boolean type column which is yes/no checkbox But -defaultvalue property does not work. Could you please help?

Is there a way to export a permission report for libraries in your sharepoint online for every folder in the library.

Really helpful video Shane! Is it possible to import items from excel to an existing SP Online lists using PowerShell?

Hi Shane, I am not really shore if this is the right video to ask my question. But I will do it anyway. I have a SharepointOnline List, and i have a csv. When I do the forall loop the Powershell findes the correct Items and gives me a output that the value has been changed. That actually happens except for the last entry in the SharePointList. Powershell tells me that everything has been changed but in the List the last one isn't. I have attached the loop and hope you can help me or direct me to the Problem. foreach ($Row in $CSVDate) { #Get the List Item matching "Name" field in the CSV $Item = Get-PnpListItem -List "Datenliste" | Where-Object { $_["ID"] -eq $Row.ID } if($Item -ne $null) { if($Item["Leistysytem"] -ne $Row.Leitsystem){ #Update List Item - Internal Name! write-Host "Debug: von " $Item["Leistysytem"] " auf " $Row.Leitsystem " geändert" $Item["Leistysytem"] = $row.Leitsystem $Item.Update() Write-Host "Updated:"$row.ID -ForegroundColor Green } else { write-host "Nothing to do @ " $Row.ID -f DarkRed } } else { write-host "No matching Item Found for:"$row.ID -f Red } }

I accidentially deleted a list with Remove-PnPList -Identity $list -Force Is there anyway to restore this list, as I do not see it in any Recycle bins. This is on a SharePoint Online site

Hi, Thanks for this helpfull video. Is there any possibility to copy list items to another list with versioning?

great video, many thanks

Thanks for sharing. SPO list query using Where-Object {...} works fine BUT CAML fails, Is it meant to be okay on SPO Lists?

Shane, How would the PS script be different if you wanted to copy a document library from one site to another? I assume New-PNPList commands such as line 14: New-PNPList -Title “Test” -Template “genericlist” -OnQuickLaunch would need to be changed to: New-PNPList -Title “Test” -Template “documentlibrary” -OnQuickLaunch But wasn't sure how to adjust line 35: Add-PNPListItem -List "Test 2" -Values @{"Title" = $item[“Title”]; "Color" = $item[“Color”]; "Animal" = $item[“Animal”]} to make sure the document in each item is copied along with the contents of the other columns. Any suggestions there? Thanks, Michael

Using Office365/SharePoint online, can I copy files from one SharePoint user to another via pnp commands? Do I need creds for both users or can it be accomplished logging in as global admin?

Great Sir, really i like it

Could you please help me with script to delete the attachment from the multiple list items in sharepoint online.

Hi, The PowerShell demo was really helpful. I have one query - To connect to the site collection do we need farm administrator credentials ?

How to delete the default Column Like Title??

Doesn´t work! At 4:20 it just keeps saying the term connect-pnponline is not a recognized as the name of a cmdlet...

Very helpful video! I was able to successfully repro everything you did in your video. But when I tried to use your command ($items | ForEach-Object {Remove-PnPListItem -List "Test" -Identity $_.id -Force} to delete items in my own script, I get an Error Message (Object reference not set to an instance of an object.) I do see all of my items when I execute $items. Cannot figure why Remove-PnPListItem is throwing a "NullReferenceException".

can we join two lists in spfx. I am new in sp

hi, nice vi9deo, can i copy a complete list with colums in share point online ?

do you know how to delete the default permission level using power shell CSOM PNP?

how can we make it as solution with some controls like exe file, so that others can use.

Very good video, Shane. I am a novice and have bookmarked your videos. I was getting the following error running the Add-PNPListItem line: "Add-PNPListItem : Operation is not valid due to the current state of the object". However I found somewhere that if I add the following, it runs OK: -ContentType "Item" Ref: github.com/SharePoint/PnP-PowerShell/issues/778

I will never understand how anyone would rather waste time writing a powershell script, do accomplish something that can be done with a mouse click or two. Makes absolutely no sense to me.

anyone ever say you sound like Charlie from Sunny? lol