Getting size of all content in subfolder on Sharepoint

[maltiser]

Hello everyone,

I am trying to check get total size of subfolder and files, inside one subfolder placed in one personal sharepoint.

The way that I was using, was through sharepoint API with metrics, with this I get bigger sizes (think that it's related with revisions), for example, here on metrics I have the value of 2.8 GB for that folder, but in reality, if I copy this folder, I will have only the sum of file sizes (a total of around 50 MB):

So, how can I get only the sum of that file size and all subfolder in that Documents folder?

[Expiscornovus]

Hi @maltiser,

Based on your requirements my suggestion would be to use something different than Power Automate 😁

You don't really need a cloud flow for that type of information. Just use the Storage Metrics page in the site settings. That feature shows the total size per folder as well.

You can append this to any site collection url to access this feature, if you cannot find it in the settings menu (even a OneDrive, which is also a site collection under the hood):

/_layouts/15/storman.aspx

For a OneDrive that url would be something like below

https://contoso-my.sharepoint.com/personal/johndoe_contoso_onmicrosoft_com/_layouts/15/storman.aspx

[maltiser]

I am already using that, on a power automate flow, but those total sizes that you get from,

/_layouts/15/storman.aspx

are the same as that folder size that I am showing on that image.

Note: I am not using a PA flow to check those values manually but to use these subfolder total sizes as control checkpoints (to receive warnings about big chunks of data) before proceed with a backup from a sharepoint A (with a site collection admin added in this user) to a sharepoint B (user added to site collection admin on sharepoint A), and to accept or not the backup manually.

[Expiscornovus]

Hi @maltiser,

Apologies, I thought it was a onetime thing. In that case a Power Automate cloud flow does make sense.

Have you tried looking into the Graph API approach. Maybe a List children of a driveItem method could be useful in this scenario.

And just to double check. You are first stage and second stage recycle bins are empty, correct? As far as I know items in there would also add to the storage count.

[maltiser]

Will check that.

Both first stage and second stage bin, think that are not included within these subfolders sizes, but I could be missing here something. Think that it's included on storage count but on root storage, not inside each subfolder. Most likely it's related with file retentions, have excels with more than 1GB on storman or metrics but in reality on onedrive (even on web like I shown above), have only a few MB's.