cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

o365 Email to On-Prem SharePoint 2013 attachments

 

 

o365 Email to On-Prem SharePoint 2013 attachments

 

Hi,

 

I currently have full access to MS flow and have a gateway setup to connect to my on premises SharePoint 2013 environment.  I can confirm that there are no connection issues with either my o365 outlook or SharePoint on prem.

 

I am trying to accomplish the following:

 

Strip PDF files from emails in a given outlook folder

Specify a date range (received date) to strip these emails

Rename the PDFs using text within the attachment itself, meaning that if there is an attachment called Document41693232019987.pdf, I would like to extract the file and rename it to 4169323202document.pdf in SharePoint.

 

So far, I have been able to get the flow to pull all attachments from any new email in a specified folder.  However, I am wondering if an expression to rename the file in the SharePoint Create item section would work. In addition, from what I have read there is no way for Flow to recognize file types, is this still true?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @kilaj1,

 

Do you want to delete the attachments in a specific email folder? I am afraid that it cannot be achieved, currently there is no action can be used to delete email attachments.

 

Do you want to delete emails within a date range? Yes, we could achieve it by using the action Get emails, then use a Condition to filter the items within the date range.

 

To rename the PDFs using text within the attachment itself, it is not available currently, as extract contents from the attachments is not possible. If you want this feature, please submit an idea on the Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Finally, about the file types, it seems that it is still not possible.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
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

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @kilaj1,

 

Do you want to delete the attachments in a specific email folder? I am afraid that it cannot be achieved, currently there is no action can be used to delete email attachments.

 

Do you want to delete emails within a date range? Yes, we could achieve it by using the action Get emails, then use a Condition to filter the items within the date range.

 

To rename the PDFs using text within the attachment itself, it is not available currently, as extract contents from the attachments is not possible. If you want this feature, please submit an idea on the Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Finally, about the file types, it seems that it is still not possible.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
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

Highlighted

Hello, @kilaj1!

 

If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.

 

Thank You!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities
Highlighted

Thanks for the responce Mabel.  I dont need to delete the emails jsut geta copy into SharePoint, which does work.  The problem is that the PDFs are named baddly with a serial number.  I used an application called Sperry Attachment Save, which is a Outlook plug in.  Worked fine for a while, but some bug prevented it from pulling emails beyond december 2017.

 

 

With reguards to the Date range, I do recall attempting to use Conditions but it didnt work.  Since the Flow triggers based on "new" emails, ive decided to just create a new folder and target that and copy the emails that need the PDF stripped out.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,125)