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!
Hi. Chapters would be great but I don't have time to do it. :) If you ever want to provide the time stamps I would be happy to add the chapters. 😀 KInd of a crowd sourcing. If you just leave a new comment on the video and I will see it. Replies often get missed. Thanks
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
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.
I would try some of the ideas here. I don't have an example in front of me to try right now. Sorry. :( sharepoint.stackexchange.com/questions/239066/retrieve-value-in-lookup-field-type-using-sharepoint-pnp-powershell
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???
@@ShanesCows I am encountering run time errors sometime. I get as query is not executed. How to resolve this.?? I have given 15 seconds delay after connect-pnponline. Any leads it will be helpful!!!
@@ShanesCows Thank you for your response :) In the project server There are 3000 records but i am getting only 300 records instead of getting 3000 records.how can use $skiptoken in power automation. please help me 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.
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?
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?
This video shows the opposite direction to help you get started. Export SharePoint List to Excel with PowerShell ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KZT8xi0OsFQ.html
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
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
Hey Michael. I think you are on the right track. I don't have PowerShell on this computer I am using today but I will poke the bear a little bit on Friday and see if I can iron it out for you. Might make a good video. :) If you figure it out today please share. Thanks
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?
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".
OK, disregard! I put parentheses around $_.id and things worked better. Did not--for some reason--need to do this in your example used in your video. Powershell continues to be a bit of a mystery. So many tips & tricks are needed in order to succeed! But your videos are helping immensely! Thank you!
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.
There is a lot of things that can only be done in PowerShell I think is why a lot of people learn. SharePoint Online management has a lot of PoweShell only features for example.