How to Create SharePoint Storage Usage Alerts for Customer Tenants
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.

- 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.
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.
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.
Log into Power Automate with your administrator credentials and click on 'Create' to start a new 'Scheduled cloud flow'.
Set the recurrence trigger to run daily or weekly, depending on how frequently you need to monitor the SharePoint storage capacity.
Add the 'Send an HTTP request to SharePoint' action to query the site storage metrics using the SharePoint REST API.
Create a condition to check if the returned storage usage percentage exceeds your desired threshold, such as 80%.
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.

Use Microsoft Graph API to Monitor Site Storage
Programmatically query SharePoint storage quotas and usage using the Microsoft Graph API for custom application integration.
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. Visit the WPS website: Navigate to the official WPS website to download the latest version of the suite.
- 2. Install the software: Run the lightweight installer and follow the on-screen prompts to set up WPS Office on your device.
- 3. Open and edit seamlessly: Launch WPS Office and immediately start opening or editing your existing Microsoft Office files without formatting issues.

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.




