Another simple article, which provides a PowerShell script that I need to use to download a file from a Sharepoint site.
So for that we are using the Pnp.Powershell module by giving the Sharepoint online credentials and then we use Connect-PnPOnline function to connect in the account from the PowerShell.
The documentation of this module can be found here: PnP PowerShell Overview | Microsoft Docs
The documentation of this function can be found here: Connect-PnPOnline (PnP.Powershell) | Microsoft Docs
In order to work, we need to set the list name from Sharepoint in the variable called $ListName.
After that we use a do function while the count of items from that list is greater than zero. While that logic is negative, it will delete the rows: $items[0].DeleteObject().
Again it’s a really simple Powershell solution, and the script of this article can be found on my GitHub reporitory: guimatheus92/DeleteRowsFromSharepointList (github.com)
I hope you enjoyed this simple solution!
This blog is part of SharePoint Week. For more great content, click here
Check out Guilherme’s website here
About the Author:
Brazilian, engineer and developer well versed in BI, SQL, Data Modelling, Analysis Services, ETL Process, Python, VBA, Power BI, etc. Passionate about technology, who uses agile pratices and decision-making processes data-driven. You can find me in my LinkedIn profile, from my website and also from my Medium profile.
Matheus. G. (2021). Delete rows from a Sharepoint list through Powershell script. Available at: https://guimatheus92.medium.com/delete-rows-from-a-sharepoint-list-through-powershell-script-aee081cb9d24 [Accessed: 14th September 2021].
