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

  • Assign Sensitivity Labels In SharePoint with MSGraph (PowerShell)
    Sensitivity labels in Microsoft 365 allow organizations to classify documents into categories like public, confidential, or highly confidential. Assigning sensitivity labels in SharePoint with PowerShell involves four steps: enabling sensitivity labels, creating an Azure AD App Registration, enabling metered APIs, and running a script.
  • How to Get SharePoint Files with MSGraph with PowerShell
    Learn how to efficiently retrieve SharePoint files using the MSGraph module in PowerShell. This comprehensive guide outlines the prerequisites, provides a demo setup, and offers a recursive PowerShell script to get all SharePoint files, including folders. Discover how to manage metadata, obtain DriveItem IDs, download specific files, and assess storage in your SharePoint libraries. With step-by-step instructions and code snippets, you can seamlessly integrate MSGraph to streamline your SharePoint file management tasks.
  • 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… Read more: How to upload files to SharePoint using Graph API (PowerShell)
  • 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.
  • How to configure Azure App registration for MS Graph
    ✔️ App registrations for MS Graph: Unleash powerful capabilities through granted requests. ✔️ What is an app registration? Learn its purpose, usage, and boundaries. ✔️ Security considerations for app registrations: Explore key factors. ✔️ How to create an app registration with the right permissions for MS Graph: A step-by-step guide.
  • 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.

Image sources:

PowerShell icon by Icons8

MS Sharepoint icon by Icons8

Microsoft Sharepoint 2019 icon by Icons8