Others

How to Create SharePoint Storage Usage Alerts for Customer Tenants

Maira MehtabMaira Mehtab Oct 10, 2026 870 views

Question details

A Managed Service Provider (MSP) needs to set up automated email notifications when a customer's SharePoint site reaches a specific storage threshold (such as 80%) to streamline service desk ticketing.

How to Create SharePoint Storage Usage Alerts for Customer Tenants
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Monitoring customer tenant storage capacities through Microsoft Partner Center to proactively manage quotas.
Observed behavior
The user requires a systematic way to trigger a service desk ticket whenever a SharePoint tenant approaches its predefined storage limit.
Before you start

Ensure you have the appropriate administrative permissions in Microsoft Partner Center and active delegated access (DAP/GDAP) to the customer's tenant environment before configuring automation flows.

Solution 1Recommended

Create a Custom Power Automate Flow for Storage Alerts

Set up a scheduled Power Automate flow to monitor SharePoint storage usage and automatically send email alerts to your service desk.

Power Automate allows MSPs to create scheduled cloud flows that evaluate storage metrics across customer tenants and execute downstream actions like sending emails or integrating with ticketing systems.

1
Open Power Automate

Log into Power Automate with your administrator credentials and click on 'Create' to start a new 'Scheduled cloud flow'.

2
Define the schedule

Set the recurrence trigger to run daily or weekly, depending on how frequently you need to monitor the SharePoint storage capacity.

3
Add a SharePoint HTTP request

Add the 'Send an HTTP request to SharePoint' action to query the site storage metrics using the SharePoint REST API.

4
Add a condition block

Create a condition to check if the returned storage usage percentage exceeds your desired threshold, such as 80%.

5
Configure the email alert

In the 'If yes' branch, add the 'Send an email (V2)' action to notify your service desk, including the tenant name and storage details to automatically generate a ticket.

Create a Custom Power Automate Flow for Storage Alerts
Implementation Assistance: If you need pre-built templates or scripting help, visit the Power Automate Community forums and search for SharePoint storage monitoring.
Free Microsoft Office alternative

Looking for a Lightweight Alternative to Microsoft Office?

While SharePoint and Power Automate are essential for enterprise administration, you don't always need heavy and expensive software for daily document creation. WPS Office provides a complete, lightweight, and free office suite that seamlessly handles your standard office tasks.

  1. 1. Visit the WPS website: Navigate to the official WPS website to download the latest version of the suite.
  2. 2. Install the software: Run the lightweight installer and follow the on-screen prompts to set up WPS Office on your device.
  3. 3. Open and edit seamlessly: Launch WPS Office and immediately start opening or editing your existing Microsoft Office files without formatting issues.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Free and lightweight office suite that requires minimal system resources.Familiar, easy-to-use interface that ensures zero learning curve.Built-in PDF editing and comprehensive cloud synchronization features.
microsoft office alternative - wps office

Frequently Asked Questions

Can I set up default SharePoint storage alerts directly in the Microsoft 365 admin center?

Yes, but native alerts are usually sent automatically only to site owners when storage reaches 90%. For custom thresholds (like 80%) or directing alerts to an MSP service desk, you must use a custom Power Automate flow or Graph API integration.

What permissions are required to run a Power Automate flow for customer tenants?

You need Global Administrator or SharePoint Administrator rights in the target customer tenant, or appropriate delegated administrative privileges (DAP/GDAP) configured via the Microsoft Partner Center.

Where can I find templates for SharePoint storage monitoring flows?

You can search the Power Automate Community forums or Microsoft Q&A under the 'SharePoint Development' tag for community-shared templates and custom REST API script examples.

Is there an additional cost for using Power Automate to monitor SharePoint?

Standard connectors are included in most Microsoft 365 plans, but if your flow relies on premium connectors (like advanced HTTP requests to certain external APIs), it may require a premium Power Automate license.