Updated 19 March 2025
Automating Microsoft 365 with PowerShell is the definitive guide to using PowerShell to automate administrative operations across the Microsoft 365 ecosystem. Originally a chapter in the Office 365 for IT Pros eBook, the content has been dramatically expanded and revised into five chapters:

• An introduction to PowerShell for Microsoft 365. Tips on using the modules, performance, etc.
• Working with the PowerShell Modules used with Microsoft 365 workloads (Exchange, SharePoint, Teams, etc.),
• Using PowerShell with the Microsoft Graph APIs.
• Using the Microsoft Graph PowerShell SDK.
• Using the Microsoft Graph PowerShell SDK with Exchange, SharePoint, Teams, and other workloads

Unlike the simple examples of how to use cmdlets often found in Microsoft documentation, Automating Microsoft 365 with PowerShell includes hundreds of practical and useful examples to illustrate how to get things done. You'll learn how to build solutions like the Microsoft 365 Tenant Licensing report (https://office365itpros.com/2024/06/20/microsoft-365-licensing-report-19/) and the Microsoft 365 User Passwords and MFA report (https://office365itpros.com/2024/06/25/authentication-methods-v13/).

To add value to the examples presented in the chapters, pointers to fully-developed PowerShell scripts in the Office 365 for IT Pros GitHub repository (https://github.com/12Knocksinna/Office365itpros) are included where appropriate.

The text explains how to manage Microsoft 365 objects such as Entra ID user accounts and groups, Exchange Online mailboxes, SharePoint Online sites, document libraries, and files, and Teams chat, channels, messages, and settings.

Automating Microsoft 365 with PowerShell does not attempt to teach the basics of PowerShell and assumes some proficiency with PowerShell on the part of the reader. If you know how to use PowerShell to manage Microsoft 365, you’ll delight in the clear and unambiguous explanations of how to get work done.

If you subscribe to the Office 365 for IT Pros eBook (2025 edition and later), you don’t need to buy Automating Microsoft 365 with PowerShell because it is included in your subscription. Only buy here if you don’t want to buy the full Office 365 for IT Pros eBook.