Rename a mail's attachment with the mail receive time and storing the attachment

[phaldar]

I am absolutely new to the tool. I have an urgent need to extract attachments from a folder in my inbox. Its a folder that gets daily reports. Those reports do not have the date time mentioned in the attachment name, hence I need to download the attachment after renaming them with the mail received date.

I have searched and none of the solutions are exactly matching my ask. Almost all of them are talking about "When a new mail arrives", whereas I need to parse through each mail that is already in this folder.

I am unable to figure out how to rename the attachment with the received date in a loop.

Formula for the Compose piece: 

concat(formatdatetime(triggerBody()?['DateTimeReceived'],'yyyy-MM-dd-hhmm - '),item()?['Name'])

 Here's what I have so far:

[fchopo]

Hi @phaldar 

You can do something like this:

1) Get Attachment Filename without extension. Ex: MySampleFile.PDF -> MySampleFile

split(outputs('Get_Attachment_(V2)')?['body/name'],'.')[0]

2) Get Attachment extension -> PDF

split(outputs('Get_Attachment_(V2)')?['body/name'],'.')[1]

3) Add Received Date Time to the Filename without extension -> MySampleFile-2022-01-01-15-02

concat(concat(outputs('Compose-AttachmentName'),'-'),formatDateTime(triggerBody()?['DateTimeReceived'],'yyyy-mm-dd-hh-mm'))

4) Add file extension to the previous step -> MySampleFile-2022-01-01-15-02.pdf

concat(concat(outputs('Compose-AttachmentNameDate'),'.'),outputs('compose-AttachmentExtension'))

You could also try to use a single expression merging all the other expressions.

Hope that helps!

Ferran

[phaldar]

@fchopo 

Thank you for your response fcho.

But triggerBody() might not be the right expression for me. Since my trigger is Manual and I need to get the received date and time of the mail that i am parsing at any given point of time in the loop.

Can you help with that?

[fchopo]

Hi @phaldar 

Received Time is another attribute of an email, so you can replace 

formatDateTime(triggerBody()?['DateTimeReceived'],'yyyy-mm-dd-hh-mm'))

by 

formatDateTime(items('apply_to_each_2')?['receivedDateTime'],'yyyy-mm-dd-hh-mm'))

 Hope that helps!

Ferran

[phaldar]

Hi @fchopo 

I am still getting an error as below, I don't think I have configured the loops correctly:

[fchopo]

Why don't try to use the exact same actions I used in my screenshot without renaming them? 🙂

Regards,

Ferran