Answered

Validation for attachment control

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

Newbie here. I would like to have a checkbox ticked once the file attached has a .PDF extension. How to better accomplish this one?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Add a gallery and assign its Items = AttachmentDatacard.Attatchments

add a label and a checkbox to the gallery

the label Text = ThisItem.Name

the checkbox Default = If(Mid(ThisItem.Name,Find(".",ThisItem.Name)+1,3) = "pdf",true,false)

Once the files are uploaded this is what you get

hope it helps

If this post helps you in a lot or a little, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @rubin_boer ! before creating what you have suggested though, followup question. Do I still need to create a gallery if my maximum attachment is only limited to 1 (file)?

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hi @Anonymous

you can do that as well. just remember you will have to get the first item like this:

If(Mid(First(DataCardValue20.Attachments).Name, Find(".",First(DataCardValue20.Attachments).Name)+1,3) = "pdf",true,false)

If this post helps you in a lot or a little, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Ah, it did work. However, I want to use the existing checkbox outside the gallery. The checkbox already has an existing string for Default and would just like to add another condition: when .PDF is uploaded in the attachment, checkbox is ticked.😁

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry forgot to mention @rubin_boer that I tried adding (&&) your suggested IF condition in my existing checkbox's DEFAULT, no squiggly lines but doesn't seem to work.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hi @Anonymous

Can you please share the existing string in default.

In the image below the checkbox in the control reference is in a gallery and the gallery is set to the attachments of the datacard hence the Thisitem.Name. The checkbox outside of the control have the default as "

If(Mid(First(DataCardValue20.Attachments).Name, Find(".",First(DataCardValue20.Attachments).Name)+1,3) = "pdf",true,false)" which references the actual datacard and not "ThisItem".

PS

You can add the current string in the

If(

(Mid(First(DataCardValue20.Attachments).Name, Find(".",First(DataCardValue20.Attachments).Name)+1,3) = "pdf") && (Another condition here),
true,
false
)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rubin_boer , Using your string alone worked, but when I add the existing string: (TextInput1.Text = "Priority"), true, false) - both strings do not work..weird.
So I tried taking out "(" and ")" when adding the existing string, like this:
If(
(Mid(First(DataCardValue20.Attachments).Name, Find(".",First(DataCardValue20.Attachments).Name)+1,3) = "pdf") && TextInput1.Text = "Priority",
true,
false
)
- no squiggly lines but the string for the data card doesn't work.

Was this reply helpful? Yes No