Check Attachments with Specific Name in the Prefix

(0) Share

Report

Posted on by AkshayManke

Hi Everyone,

I am working on a case where I have below type of files which needs to be attached and submitted.

1. Address Proof

2. ID Reference

3. Educational Certificate

I would like to add validation in the form, like if any of the file added in the attachment missing the prefix as above, then the form should not be submitted.

For example: If i have added the below files in the attachments field as 'Address Proof - Akshay' & 'ID Reference - Akshay' and the third attachment is missing or not having the prefix as 'Educational Certificate' then the form should not get submitted.

Can anyone please help me how to do that please?

Warm Regards,

Akshay

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

JohnM86 590 on at

Like (1)

Report

You could try something like:

If( CountRows(Attachments) = 3, ForAll(Attachments, If( Or( StartsWith(Split(ThisItem.Name, " - ")[0], "Address Proof"), StartsWith(Split(ThisItem.Name, " - ")[0], "ID Reference"), StartsWith(Split(ThisItem.Name, " - ")[0], "Educational Certificate") ), true, Set(varErrorMessage, "Please ensure all attachments have the correct prefix.") )), Set(varErrorMessage, "Please ensure all three attachments are uploaded.") ); If( IsBlank(varErrorMessage), SubmitForm(MyForm), Notify(varErrorMessage) )

This formula first checks if exactly three attachments are uploaded. If not, it sets an error message. If there are three attachments, it uses the ForAll function to loop through each attachment and check if its prefix matches any of the expected prefixes. If any attachment has an incorrect prefix, it sets an error message.
If there are no errors, the formula submits the form. If there are errors, it displays the error message using the Notify function.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @AkshayManke,

Before submitting the form, you could check whether all documents were correctly uploaded (OnSelect of the submit button):

If( //Check if document count = 3 and all documents are correctly prefixed //Don't forget to change to the correct DataCardValue / Attachment control name CountRows(DataCardValue.Attachments) = 3 && CountIf( DataCardValue.Attachments, StartsWith( Name, "Address Proof" ) ) = 1 && CountIf( DataCardValue.Attachments, StartsWith( Name, "ID Reference" ) ) = 1 && CountIf( DataCardValue.Attachments, StartsWith( Name, "Educational Certificate" ) ) = 1, SubmitForm(FormName), //Change FormName Notify( "Your error message", NotificationType.Error ) )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report

Hello @LaurensM and @JohnM86,

Thanks a lot for the help. I will check them out and will get back to you by tomorrow.

Warm Regards,
Akshay

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (1)

Report

Hi @LaurensM & @JohnM86, both the solutions given by you are working. Hence accepting them.

Many thanks for the help !!

Warm Regards,
Akshay

Was this reply helpful? Yes No