Collecting Attachments and Renaming in Sequential order

[Dan7Merc]

Hi Power Users!

I am developing an app intended to do the following

1. Collect jpg and pdf (I'm using an attachment control) - Done

2. Rename the attachments with a predefined naming system

Needs advice: how can I rename all the attachments including a sequential number and patch? at the moment

it is renaming all attachments with the same filename - therefore patching only 1 file.

3. Using a flow - patch the attachments to a Document Library - Done

I have pasted the code/script below if anyone is a superhero and wants to assist a helpless newbie like me 😊

//COLLECTING FROM ATTACHMENT CONTROL

ClearCollect(ColRenamed,OPS_Select_Attachment.Attachments);

//UPDATING OR RENAMING THE FILES

UpdateIf(ColRenamed,
!(First(Split(DisplayName,"-")).Result in "Random"),
{
Name:varSelectedItem.D_ProjectNumber &"-"& Week_NUmber_6.Text &"-"& varOPSCount &"-"& Filename_Entry.Text & If(Last(Split(
Concat(OPS_Select_Attachment.Attachments,Name),".")).Result="jpg",".jpg",".pdf")
});

//CREATE FILE FLOW FOLLOWS

Thanks! 😎

[BCBuizer]

Hi @Dan7Merc ,

May I suggest to just pass the Item id to Power Automate and do the collecting, renaming and saving in there. for instance:

[Dan7Merc]

@BCBuizer  Thanks for the attention. I actually started writing a flow to do this task but then again I wanted to try doing it directly from the app. still giving it a try and if no success...then Flow it is 🙂

Thanks

[BCBuizer]

Hi @Dan7Merc ,

As far as I know this topic is still current:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Rename-Attachments-on-New-Edit-Form/td-p/102....

This means it is not possible to rename attachments in Power Apps, but a flow can do the trick.

[Dan7Merc]

@BCBuizer 

I am able to rename my attachments...but it only works with a single attachment...I will post the code/script when I managed to hack it 🙂

[BCBuizer]

Hi @Dan7Merc ,

Can you please share what you have so we can both have a crack at it.

[Dan7Merc · Accepted solution]

@BCBuizer  - Hacked it and it Works!
Code/Script written below for sharing...Sharing is Caring 😁

note: CollectedAttachments should be the "Items" of the Attachment Control..

Set ( Variable1 , CountRows ( Document Library where the files are stored ) );

ClearCollect ( CollectedAttachments , AttachmentControl . Attachments );

ClearCollect ( CollectionForAttachmentItems,

With ( { TestData: CollectedAttachments } ,

    ForAll ( Sequence ( CountRows ( AttachmentControl.Attachments ), Variable1 + 1),

        Patch ( Last ( FirstN ( CollectedAttachments,Value ) ) , { Name: Naming_Convention & Value & If ( Last ( Split ( 

Concat ( AttachmentControl . Attachments , Name ) ,"." ) ) . Result = "jpg", ".jpg", ".pdf") } ) ) ) )

Enjoy!