cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sherazad
Regular Visitor

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
AlanPs1
Resident Rockstar
Resident Rockstar

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

v-yuazh-msft
Community Support
Community Support

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
AlanPs1
Resident Rockstar
Resident Rockstar

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!


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,

AlanPs1
Resident Rockstar
Resident Rockstar

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!


v-yuazh-msft
Community Support
Community Support

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.

 

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,

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

 

thanks,

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,330)