Unanswered

Rename email attachment with keeping file type

(0) Share

Report

Posted on by KamalSager

Hi everyone,

A scheduled cloud flow was created to automatically save emails attachments, however since my attachments have the same exact name and type but with different received times, I couldn’t keep the attachments file type when use the received time as a file name and when use the attachment name it will keep the file type but the flow will overwrite the file name and save only the latest email attachment at the end! Appreciate any advice on this one. Thank you

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report

@KamalSager

To clarify, irepective of the scheduled nature of your flow. An email arrives with some attachments which you want to save ot a SharePoint Library. The emails come in at various times of the day.

You want to save each one of the attachments with a unique name but keep its type like XLSX and DOCX.

Can you please give me an example of the typical names.

Regards,

Andrew

Was this reply helpful? Yes No
KamalSager 6 on at

Like (0)

Report

@Andrew_J

Report_2024_04_15.CSV
Report_2024_04_16.CSV

We receive this email everyday, each email has only one attachment with the same exact name.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@KamalSager

Then if you have files coming in of:

Report_2024_04_15.CSV
Report_2024_04_16.CSV
Report_2024_04_17.CSV
Report_2024_04_18.CSV
Report_2024_04_19.CSV
Report_2024_04_??.CSV

Then why not use the following:

https://www.youtube.com/watch?v=w_7cqWwgOW8

The above is based on many number of attachments. And I would not use a sheduled flow. I would look at the email address the above reports come in from and some of the subject as per the above video.

Regards,

Andrew

Was this reply helpful? Yes No
KamalSager 6 on at

Like (0)

Report

@Andrew_J
These are the output names that I need to get. The original files name are the same they all use the same name let's say
report_abc

I receive this email everyday with the same attachment ( same file name & type), only the content is different and need to save these attachments with new different names that reflects date of receiving the attachment.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@KamalSager

Then that you should look at the following:

In the box above you shoukd use as an expression:

formatdatetime(utcnow(), 'yyyy_MM_dd')

The have something like as follows:

Add the rest of the dynamic linking in the above as you need.

Regards,

Andrew

Was this reply helpful? Yes No
KamalSager 6 on at

Like (0)

Report

Thank you @Andrew_J instead of using an expression I did use the attachment received time plus .CSV
and now I got the attachments with their file type as well. The concern was in keeping the file type without the need of adding the file extension .CSV!!

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@KamalSager

So is this resolved then, if so can you please make this as solved.

Andrew

Was this reply helpful? Yes No