cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sherazad
Level: Power Up

Flow which renames email attachments

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Flow which renames email attachments

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


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Community Support Team
Community Support Team

Re: Flow which renames email attachments

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:

Capture.PNG

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:

Capture.PNG

Capture.PNG

 

 

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.

 

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Flow which renames email attachments

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


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Sherazad
Level: Power Up

Re: Flow which renames email attachments

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,

Super User
Super User

Re: Flow which renames email attachments

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


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Community Support Team
Community Support Team

Re: Flow which renames email attachments

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:

Capture.PNG

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:

Capture.PNG

Capture.PNG

 

 

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.

 

View solution in original post

Sherazad
Level: Power Up

Re: Flow which renames email attachments

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,

Sherazad
Level: Power Up

Re: Flow which renames email attachments

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

 

thanks,

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 237 members 3,189 guests
Please welcome our newest community members: