How to make a flow that will determine the Sharepoint storage reach the 80% of the its capacity then send the notification to a particular email address

[acep-ITService]

How to make a flow that will determine the Sharepoint storage reach the 80% of the its capacity then send the notification to a particular email address.

[RobElliott]

@acep-ITService here is one I use for a site that regularly approaches its storage limit. It runs every Monday morning.

After the recurrence schedule trigger add a Send an HTTP Request to SharePoint action:-

Method: GET
URI: _api/site/usage

Headers: accept | application/json; odata=nometadata

At this point, name & save the flow and run a test. In the results of the test copy everything from the Outputs box of the Send an HTTP Request action. Add a Parse JSON action, click the "Generate from sample" button and paste in what you copied.

Add a format number action and click in the Number field then select StoragePercentageUsed from the dynamic content box and set the format to 0.00%.

I then get a logo from our intranet to use in the email.

Add a Condition, click in the left field and select the output of the Format Number action. In the right field type .8. Leave the red if no channel empty but add the send an email action

Save the flow again and test it. 

And this is the result.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[acep-ITService]

@RobElliott not each site storage limit but thanks for that information, in case you have a flow about the whole SharePoint Storage capacity, like from my screenshot it is showing "The storage is almost full" so that we can get a notification that we have to buy more storage.

[RobElliott]

@acep-ITService sorry, I can't help with that as I'm not a tenant of global SharePoint admin at my company.

[Isaac_Cummins]

Hi Rob,

Thanks for this. I really thought it was going to be the solution after spending the past two days trying to get some sort of report, email alert, etc work but I am stuck at the Parse JSON part because I just do not have an option "Generate from sample". Using the newer interface, what I actually see is "Use sample payload to generate schema". It want's me to input something myself but I am at a loss. I have tried several schemas that I have found online but no luck. 

Any advice would be really appreciated.

[RobElliott]

@Isaac_Cummins my previous instructions still work, it's just that the wording has changed with the new designer. Build your flow down to the Send an HTTP request to SharePoint action, then save and test it. Copy the outputs of the HTTP action and then paste it into the use sample payload.... field in the parse JSON action. So in the live one I run below, I built it down to zLST (the send an http request action) then tested the flow and copied the outputs in the parse json action.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)