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

(0) Share

Report

Posted on by Charles-v-D

280

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

Categories:

General topics

All responses (6)

Answers (1)

Sort by

Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

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 280 on at

Like
a
(0)

Report
Copy link

Link copied!

@DeepakS Thanks Deepak! Works like a charm!

regards
charles
AW0522 7 on at

Like
a
(0)

Report
Copy link

Link copied!

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 280 on at

Like
a
(2)

Report
Copy link

Link copied!

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 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome @Charles-v-D!
Efficient indeed! Thank you for sharing 👍👍
Very Best,
A. Watts
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?