Filename extension check fails to detect extension

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have the following problem. I want to show only the attachements that have the right extionsion.

But for some reason this is not working.

Filter(ERA_AEN_AR_dataReceipts.Attachments, Name in [".pdf", ".jpg", ".jpeg", ".png", ".gif"])

ERA_AEN_AR_dataReceipts is a FileInputControl. Where users can upload there images/pdfs.

The control where I do my Filter is the control that will eventually upload the images/pdfs.

I have checked if there are files in my ERA_AEN_AR_dataReceipts.Attachments, there is.

I hope someone can help me,

Thanks in advance!

Categories:

Building Power Apps

All responses (6)

Answers (3)

Sort by

akandis on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Anonymous

You are using Name field that will come the File name but without extension. There is a field called 'File name with extension' that will return the filename+extension.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @akandis ,

I just checked this and I get the error that 'File name with extension' isn't recognized. I also checked this with ThisItem and ThisRecord but no hit.

In the image you can see the records from my ERA_AEN_AR_dataReceipts.Attachments control. This is also the reason why I checked on the field 'Name'
Verified answer

akandis on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Ohh I see you are saving the blob. Have to tryied to Split by the . and then check the last value?
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@akandis ,

Yes I already have done that but same result... Nothing happend 😕

I used the following code for it:
Filter(ERA_AEN_AR_dataReceipts.Attachments, Last(Split(Name,".")).Result in [".pdf", ".jpg", ".jpeg", ".png", ".gif"])
Verified answer

akandis on at

Like
a
(0)

Report
Copy link

Link copied!

Check without the point["pdf", "jpg", "jpeg", "png", "gif"]. Once you do the split the . will disappear.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@akandis ,

Ooooh woow, I feel like a rookie right now 😅.

Thanks a lot it works perfectly fine right now!!