Unanswered

Sharepoint Site Storage Increase Flow

(0) Share

Report

Posted on by dixonbridgeta

125

Has anyone created a power automate flow that is able to increase a SharePoint site's storage? Users will fill out a form in Power Apps that is linked to a SharePoint site. Power automate will come in and pull that data, find the site that the user requested to increase storage on and do the increase for that user if it is under 300gb. If it is over 300gb, then approval will be needed. All of this will be recorded back to the SharePoint list that is holding this data.

Anyone ever create something like this?

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (0)

Expiscornovus 33,784 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @dixonbridgeta,

You could update the StorageMaximumLevel field value via the Microsoft.Online.SharePoint.TenantAdministration namespace. This can be accessed via the _api/Microsoft.Online.SharePoint.TenantAdministration.Tenant

You would need to retrieve the site id. After that you can update that property value via a POST request.

Below is an example.

Be aware, that value is in MBs not GBs 😁

In this example I am setting the storage limit to 250 GB

URI

_api/Microsoft.Online.SharePoint.TenantAdministration.Tenant/Sites('@{outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Site_Id')?['body']['Id']}')

Headers

{ "Accept": "application/json;odata=nometadata", "Content-Type": "application/json;odata=nometadata", "X-HTTP-Method": "MERGE" }

Body

{ "StorageMaximumLevel": "256000" }

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this information! I am still not completing understanding however. The method "Get" gets the information from the site and the method "Post" sends the increase I am assuming. I don't understand the headers, and why the storage level is 256000 and not 250000. I tried this example however, and it timed out on the "Post" method.

Was this reply helpful? Yes No
Expiscornovus 33,784 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @dixonbridgeta,

That is correct, the GET retrieves the Id of the site you want to update. If you get a timeout it might not succeeded in retrieving that Id. Can you share a screenshot of your failed flow run?

The value is different because one thousand and twenty-four megabytes (1024 MB) is equal to one gigabyte (1 GB):

https://en.wikipedia.org/wiki/Megabyte

If you want to set it to 250GB that would be 250*1024 = 256000

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

The status says badgateway.

Was this reply helpful? Yes No
Expiscornovus 33,784 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dixonbridgeta,

It looks like you used the whole body from the outputs, make sure you retrieve the Id field value instead. In my example I added the ['Id'] reference at the end of the expression.

In your setup that expression would be:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['Id']

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

I might be misunderstanding... Do I use that expression in the POST method's URI?
Error message:
"401 UNAUTHORIZED
clientRequestId: f0390ef4-540a-43ae-8074-b033b583d9d6
serviceRequestId: c7818da0-30b4-3000-39d5-f90408b04e54"

Was this reply helpful? Yes No
Expiscornovus 33,784 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @dixonbridgeta,

Yes, that is correct. That expression should be used in the Uri field of the Send an HTTP request with the POST method.

Below is a gif (click on it to see it in high resolution) how that would work via the expression editor and dynamic content.

1. Place your cursos between the '' characters

2. Type ['Id'] via the Expression tab

3. Place your cursor at the beginning

4. Click on the Dynamic content field tab and select the Body of the previous GET request action

5. Place your cursor at the end and click ok.

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the constant replies! Unfortunately, it is still not working. I followed the instructions and now it just keeps timing out..

Was this reply helpful? Yes No
Expiscornovus 33,784 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @dixonbridgeta,

Another question. Are you using the SharePoint Admin Center site address in that second request? The Site Address should be different in the second (POST) request.

Let's say your domain is Contoso. In that case the SharePoint Admin Centre site address would be https://contoso-admin.sharepoint.com

Was this reply helpful? Yes No