Allow only some file types as attachments

[Lefty]

Hello,

Is there a way I can restrict only certain file types to be uploaded via a Power Apps form (canvas app) linked to SharePoint Online.

Currently I want only PDF to be attached to my form, is this possible?

I've tried something like this:

Created a label - LblAttachmentWarning

On the Visible property of the label:

If(!".pdf" in Concat(DataCardValue38.Attachments.Name,Name&","),false)

On the submit button Visible property:

!LblAttachmentWarning.Visible

But I dont get the error appear when i upload a non PDF or even when i upload a PDF

[WarrenBelz]

Hello @Lefty ,

This on the OnAddFile properties of the Attachments card: (I will call the card AttachmentsCard) to generate an error message hopefully the user will acknowledge and set a variable you could disable the form save or something else on (I don't know of a way of clearing the attachment control)

If(
   Last(
      Split(
         Last(
            AttachmentsCard.Attachments).Name,
             ".")
         )
         .Result <> "pdf",
         Notify(
            "Only PDF files can be attached",
            NotificationType.Error
         );
         UpodateContext({vAtrErr:true})
      )
   )
)

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.

[Lefty]

HI @WarrenBelz 

I've tried your suggestion on the Datacard but getting a few errors:

If(
Last(
Split(
Last(
Attachments_DataCard1.Attachments).Name,
".")
)
.Result <> "pdf",
Notify(
"Only PDF files can be attached",
NotificationType.Error
);
UpodateContext({vAtrErr:true})
)
)
)

Noticed that my initial question works if i say:

Visible fx: If(".png" in Concat(DataCardValue38.Attachments.Name,Name&","),true)

But I dont want to name all the file types, rather i want to say if its not PDF show the error, then i disable the save button, but cant get that fx to work either

[WarrenBelz]

Hi @Lefty ,

Without testing the issue with the first formula, I will try something hopefully less complex - your coding skills are obviously well up to extrapolating from this.

The formula for testing the extension of the first attachment should be

Last(
   Split(
      First(
         DataCardValue38.Attachments
      )
      .Name, 
      "."
   )
)
.Result

So if this result is not "pdf", you should have something to test and hide/disable. Happy to help further if required.

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. 

[WarrenBelz]

HI @Lefty ,

I have had some more time to try to give you a more complete solution and have tested this on one of my Attachment controls successfully.

Firstly, the target is the Attachment Control, not the Card it is contained in - I will call yours FileAttach in the code below. I suggest you put this on your save button

If(
    Last(
        Split(
            First(
               FileAttach.Attachments
            )
            .Name,
            "."
        )
    ).Result = ".pdf",
   SubmitForm(YourForm),
   Notify("Only PDFs allowed")
)

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.

[Lefty · Accepted solution]

HI @WarrenBelz 

Thanks for all your responses.

I couldn't get your suggestion to work, but I've cracked my initial question, its easy when it works!

I've used the following code on my labels visible property , and made my submit button invisible if my label shows: 

If(Not(".pdf" in Concat(DataCardValue40.Attachments.Name,Name&",")),true)

This allows me to only submit PDF

[WarrenBelz]

@Lefty ,

This recent post of mine may also help.

[Lefty]

HI @WarrenBelz 

Thanks, going back a bit, i'm surprised you even found this post of mine!
I think we got it to sort of work when I was looking for a solution for this.... but have bookmarked your new suggested post. 

[russoedu]

The best way I found to solve this is by counting the number of attachments without the desired extension:

CountRows(Filter(DataCardValue38.Attachments, Right(Name, 3) <> "pdf")) > 0

Translating, I'm counting (CountRows) the result of the filter (Filter) of all attachments (DataCardValue38.Attachments) where the last 3 characters are not "pdf" (Right(Name, 3) <> "pdf")).

If this filtered value is bigger than 0, it means some of the attachments are not PDF.

[Pandaredcap]

Try this code on the "On Add file " of the Attachment control 

If(Not(EndsWith(First(Self.Attachments).Name, ".pdf")) And Not(EndsWith(First(Self.Attachments).Name, ".docx")),Notify("Only pdf and docx files are allowed", NotificationType.Error); Reset(Self))