Solved: Re: Get attachment file size using attachment cont...

Vysakh__S · ‎07-04-2023

Hi Team,

Is there any way to get the size of all the attachments uploaded through attachment control

For example, if I am attaching 5 files through attachment control I should get the file sizes of the attachments.

WarrenBelz · ‎07-05-2023

A bit of persistence, I got it working make a Gallery (called galAttach below) with the Items

AttachmentControlName.Attachments

Now put an Image control in the Gallery (called imAttach below) with the Image

ThisItem.Value

You can now hide the gallery You will need to trigger the next piece, so a button with “Size” or similar below the attachment control will do the job.

ForAll(
   galAttach.AllItems,
   Collect(
      colSize,
      {
         ImSize:
         (Len(
            JSON(
               imAttach.Image,
               JSONFormat.IncludeBinaryData
            )
         ) - 814) / 1370000
      }
   )
);
UpdateContext(
   {
      varSize:
      Sum(
         colSize,
         ImSize
      )
   }
)

You can then have a label with

"Total Attachment size: " varSize & " Mb"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

View solution in original post

WarrenBelz · ‎03-13-2024

@Sindhu251 ,

There is no reason this will not work

With(
   {
      _JSON: JSON(
         ImageExcel.Image,
         JSONFormat.IncludeBinaryData
      )
   },
   With(
      {_MB: (Len(_JSON) - 814) / 1370000},
      If(
         !("xlsx" in Last(
            Split(
               Last(IconBrowseAttachement_UIPS.Attachments).Name,
               "."
            )
         ).Value),
         Notify(
            "Only file with .xlsx extension are allowed",
            NotificationType.Error
         );
         Reset(IconBrowseAttachement_UIPS),
         _MB > 10,
         Notify(
            "Only files less than 10 MB are acceptable.",
            NotificationType.Error
         );
         Reset(IconBrowseAttachement_UIPS),
         UpdateContext({varMB: _MB})
      )
   )
)

View solution in original post

WarrenBelz · ‎07-04-2023

Hi @Vysakh__S ,

This blog of mine should do the job for you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Vysakh__S · ‎07-04-2023

Hey @WarrenBelz thanks for the replay, but can I get the file size of all the attachments which I had uploaded , like showing the file size in a gallery or something

WarrenBelz · ‎07-04-2023

@Vysakh__S ,

Sorry, only works for one image at a time as you need to set a Variable on the contents of the hidden image. I did a test with a Collection from a Gallery of images, but it does not work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

WarrenBelz · ‎07-05-2023

Hi @Vysakh__S ,

A bit of persistence, I got it working make a Gallery (called galAttach below) with the Items

AttachmentControlName.Attachments

Now put an Image control in the Gallery (called imAttach below) with the Image

ThisItem.Value

You can now hide the gallery You will need to trigger the next piece, so a button with “Size” or similar below the attachment control will do the job.

ForAll(
   galAttach.AllItems,
   Collect(
      colSize,
      {
         ImSize:
         (Len(
            JSON(
               imAttach.Image,
               JSONFormat.IncludeBinaryData
            )
         ) - 814) / 1370000
      }
   )
);
UpdateContext(
   {
      varSize:
      Sum(
         colSize,
         ImSize
      )
   }
)

You can then have a label with

"Total Attachment size: " varSize & " Mb"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Vysakh__S · ‎07-05-2023

There you are thanks a lot for the solution. 😍

WarrenBelz · ‎07-05-2023

@Vysakh__S ,

I have also updated my blog

Sindhu251 · ‎03-12-2024

Hi WarrenBelz

I am. Attaching excel file in powerapps attachment control. I want to capture the file size in variable in powerapps. Could u please help me with this