How to determine the size (Mb) of an attachment in MS Flow

[Charles-v-D]

Hi all,

I just had one of my flows "fail" due to the fact that the attachment to an e-mail exceeded the 5Mb size. I want to build in a check to prevent this from happening. How can I determine the combined size of all attachments of a SharePoint List item?

Any feedback is welcome!

Regards

Charles

[DeepakS · Accepted solution]

Hi @Charles-v-D 

Following Expression (approx) will give you the file size:

 KB =  div(int(length(string(body('Get_file_content')))),1024)  (Preferred)

MB = div(int(length(string(body('Get_file_content')))),1048576)

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[Charles-v-D]

@DeepakS Thanks Deepak! Works like a charm!

regards

charles

[AW0522]

Hello @Charles-v-D ,

I am also looking into the simplest way to determine the combined size of all attachments of a SharePoint List item. How did you go about accomplishing this?

Regards,

A. Watts

[Charles-v-D]

Hi @AW0522 

My flow collects the attachments from the item and then for each of them I increment a variable with the size of each attachment. The size in bytes is determined by:

div(int(length(string(outputs('Get_attachment_content')?['body']))),1024)

Hope this helps

[AW0522]

Awesome @Charles-v-D!

Efficient indeed!  Thank you for sharing  👍👍

Very Best,

A. Watts

[Anonymous]

Hello Charles,

I applied the solution provided by you and the file size is never truly accurate. I tried putting 1000 instead of 1024 and it got closer. But its always by +- 100 KB to the actual file size.

Any idea why that could be?