Filtering Items in Attachments with Name

(0) Share

Report

Posted on by Rhk

133

So in my case, I'm creating an application with two data cards with attachments

Attachment Name - "HardwareGoods" and

another Attachment Name - "Invoice"

OnAddFile -

Clear(CollectingIncorrectNames);
ForAll(
Self.Attachments.Name,
If(
Not("HardwareGoods" in Name),
Collect(
CollectingIncorrectNames,{Name : Name}
));
If(
CountRows(CollectingIncorrectNames)>0,
Notify("Change Attachment Name to 'HardwareGoods' on the file name", Error); Reset(Self))

On Items - How do I filter only Attachments which has a name with 'HardwareGoods' only not the 'invoice'

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Can you help me with this

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rhk ,

Two things - this will sort the first one out OnAddFile

If( !("HardwareGoods" in Last(Self.Attachments).Name), Notify( "Change Attachment Name to 'HardwareGoods' on the file name", Error ); Reset(Self) )

However, if your two attachment controls are on the one Form, the second one submitted (in the order they are on the form) will overwrite the first one, so you cannot save two sets in one SubmitForm)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

On Items Property - How do I filter Attachments which has a name with 'HardwareGoods' but not the 'invoice'

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Rhk ,

I am not sure of the other consequences of this when saving, but you can display only HardwareGoods in the Attachment Control Items with

Filter( ThisItem.Attachments, "HardwareGoods" in DisplayName )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

Rhk 133 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for your help. A few lines of code did work from your responses but got a better visual solution from this video -
https://www.youtube.com/watch?v=hJQjGE-oUpM

Was this reply helpful? Yes No