cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charles-v-D
Helper V
Helper V

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
DeepakS
Resident Rockstar
Resident Rockstar

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.

View solution in original post

6 REPLIES 6
DeepakS
Resident Rockstar
Resident Rockstar

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.

@DeepakS Thanks Deepak! Works like a charm!

 

regards

charles

 

 

AW0522
Frequent Visitor

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

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
 

flow.PNG

Awesome @Charles-v-D!

Efficient indeed!  Thank you for sharing  👍👍

Very Best,

A. Watts

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? 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,414)