Automatically email anyone who's one-drive is over 100gb

[AB21805]

Hi all,

I would like to implement an automation process to save time and avoid the need to manually find and email these users individually. The goal is to automatically email anyone who has over 100GB used on their OneDrive, providing them with necessary steps within the email.

Is this possible? 

[#2]

Yes. Create a Power Automate flow.

[#3]

Do you have an example?

[#4]

How could it be done?

[#5]

You can use GraphAPI command (getOneDriveUsageAccountDetail) to retrieve report with the OneDrive sites and their capacity for the last 180 days, and apply a for each command to check every user storage size and if it exceeds the 100GB send him an email

REF: Power Automate Community

[#6]

Here it is: https://powerusers.microsoft.com/t5/Building-Flows/OneDrive-storage-usage/td-p/2599729

UPDATE: this article is even better: https://www.leonarmston.com/2021/02/download-microsoft-365-usage-reports-using-microsoft-graph-in-po...

Be warned: you can do that only using a  Premium connector. 

[#7]

Power Automate Flow:
Create a Power Automate flow that triggers periodically (e.g., daily or weekly).
Use the Graph API command getOneDriveUsageAccountDetail to retrieve OneDrive usage details for the last 180 days.
Apply a loop (for each command) to check each user’s storage size.
If a user’s storage exceeds 100GB, send them an email with the necessary steps.
Graph API Command:
The getOneDriveUsageAccountDetail command provides information about OneDrive sites and their capacity.
You can use this data to identify users with excessive storage.
Email Content:
In the automated email, include instructions for managing storage (e.g., deleting files, optimizing storage).
Provide links to relevant documentation or support resources.

[#8]

Hi @AB21805, did you solve the problem?