Welcome to SPO Scripts – your source of high quality PowerShell Scripts about M365 and SharePoint. 

PowerShell is the language when it comes to automation of Microsofts collaboration products. In this blog I want to show you step by step how you can automate things with PowerShell scripts. Main focus is SharePoint, SharePoint Online, Azure.

My aim is to democratize the automation so everybody can make their processes more efficient. 

If you have any cases, where you think I should set up a blog post or you have feedback for me, contact me. I appreciate it.

Jump directly to the PowerShell Script categories


Latest Posts – PowerShell scripts

  • How To Download a SharePoint Library Using Graph API (PowerShell)
    SharePoint is a powerful platform for managing and collaborating on documents, but downloading files from SharePoint libraries can be a tricky, especially when it comes to deal with large files or a large amount of documents. In this post, I want to show you a straightforward guide to download a SharePoint Library using PowerShell with Microsoft’s Graph API for SharePoint administrators, develops or system integrators. This tutorial will help you streamline your automation in terms of downloading SharePoint libraries. At the end, you’ll find a ready to use PowerShell script, which you can use to download the SharePoint Library using Graph API.
  • How to download files from SharePoint using Graph API (PowerShell)
    Downloading files from SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous articles, I have been explaining how you can upload files to SharePoint using PNP module. In this article, I want to show you how you can achieve download files from SharePoint using Graph API.
  • How to upload files to SharePoint using Graph API (PowerShell)
    Uploading files to SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous articles, I have been explaining how you can upload files to SharePoint using PNP module. In this article, I want to show you how you can achieve upload files to SharePoint using Graph API. Note: This method works for …

    How to upload files to SharePoint using Graph API (PowerShell) Read More »

  • Create SharePoint list items using Graph API (PowerShell)
    SharePoint List items do represent a row of structured data in our SharePoint. Besides creating them manually, you have the opportunity to create them programmatically. In this article I want to show you how you can create SharePoint list items using Graph API with PowerShell.
  • How to get SharePoint List Items with Graph API (PowerShell)
    In this article I am explaining how you can get SharePoint List items with Graph API. I took PowerShell to get the items, but you could also get all the items with a web request in the tool of your choice e.g. Postman.
  • Security of app registration in Azure Active Directory
    Originally, I thought about writing an article about how to get SharePoint list items with Microsoft Graph API by PowerShell. But before doing this, I thought you should first need to know something about app registration in Azure Active Directory in this context. App registrations are really powerful, as you can raise any request if granted. In this article, I …

    Security of app registration in Azure Active Directory Read More »

  • How to get all lists and libraries in SharePoint Online
    Learn how to get all lists and libraries with two PowerShell scripts to understand what is going on in your SharePoint tenant.
  • Upload documents to SharePoint (PNP.PowerShell)
    Learn how to upload documents to SharePoint with PowerShell. Integrating different systems to SharePoint can be achieved easily with this.
  • SharePoint Site Usage: Get active Sites for last 6 months with PowerShell
    When migrating our SharePoint to SharePoint Online, it can be really hard to separate the wheat from the chaff. SharePoint Site usage helps you find, what is actually used in your current farm. SharePoint farms grow by new projects and with the change of structures. If you want to have an overview, it is every time a good idea, to get rid of old stuff.

Image sources:

PowerShell icon by Icons8

MS Sharepoint icon by Icons8

Microsoft Sharepoint 2019 icon by Icons8