Answered

Flow which renames email attachments

(0) Share

Report

Posted on by Sherazad

Hello,

Is it possible to build a flow which renames email attachments or strips out French accent characters from attachment names as they enter the mailbox?

There is an issue I am trying to solve wherea third party application which picks up attachments from the mailbox are having an issue with the French accent characters. Hence those attachments never get into the third party app.

thanks,

Sherazad

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (2)

AlanPs1 2,471 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sherazad
This sounds like an interesting scenario, so thank you for posting it.

You say a "third party application which picks up attachments from the mailbox".
Can you provide as much detail on this aspect of things please, how eaxctly it picks up the mail, or if it is forwarded on to the application?
Also, what the application is it? It'd be great if you can share the name of it please?

Thanks, Alan

Was this reply helpful? Yes No
Sherazad 52 on at

Like (0)

Report
Copy link

Link copied!

The third party application is called Perceptive content. It has an email agent which monitors a mailbox and imports the attachments into the application.

One other question, can flow save attachments to a unc path on the network and rename the file there? If so, that may be another way I can get the attachments into the application.

thanks,

Was this reply helpful? Yes No
Verified answer

AlanPs1 2,471 on at

Like (0)

Report
Copy link

Link copied!

Hi Sherazad.
There are connectors to file system and if it were a local computer with OneDrive and SharePoint so if the files were synchronising from either that method could work too.

I’m short for time just now but if you look through my latest posts/replies you should see a solution I provided for saving the actual email to SharePoint. This should give you a starting point and if any issues I’ll be able to come back tomorrow and assist so feel free to reply and let us all know how you get on.

Thanks, Alan

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Sherazad ,

Could you please explain more details about the unc path that you mentioned?

Flow could save the email attachment with new name to sharepoint, Onedrive for business and also local folder with File System connector.

Make an example to save the email attachment in your Onedrive for business as below:

The expression in the Compose as below would get the attachment extension:

last(split(items('Apply_to_each')?['Name'],'.'))

The expression in the File Name column as below would rename the attachment with name "New Name":

concat('New Name.',outputs('Compose'))

The flow would run successfully as below:

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Sherazad 52 on at

Like (0)

Report
Copy link

Link copied!

Hello All,

Thank you for the excellent and detailed responses. I will give this a try and let you know.

I believe I will go the save to SharePoint route and grabbing the item from there.

thanks,

Was this reply helpful? Yes No
Sherazad 52 on at

Like (0)

Report
Copy link

Link copied!

One question though. Can I save the attachment to SharePoint on prem or does it have to be SharePoint online?

thanks,

Was this reply helpful? Yes No