Ability to extract email as MSG or EML file from various Flow mail services

Status: Planned
by JRitmeijer on ‎02-20-2017 05:59 AM

Flow nicely integrates with various email services, I see separate Actions and Triggers for Gmail, Office 365 Outlook, Outlook.com.

 

All these services follow a similar pattern. They allow emails to be fetched from an inbox and access the Body, Subject, To, CC etc, which is all nice and well. However, what is deparately needed is the ability to get a copy of the full email in MSG or EML format so the entire email can be passed between services so it can be archived or processed further.

 

I see quite a few people asking for this in the forums and we need it as well so our customers can pass emails (as MSG or EML) into our Flow based PDF Converter.

 

As requested in the following Flow discussions

 

https://powerusers.microsoft.com/t5/Flow-Forum/save-an-email-to-a-document-library/m-p/10351/highlig...

https://powerusers.microsoft.com/t5/Flow-Forum/Save-email-to-Sharepoint-document-library-full-email/...

https://powerusers.microsoft.com/t5/Flow-Forum/Create-a-file-in-SharePoint-when-a-new-item-is-added/...

https://powerusers.microsoft.com/t5/Flow-Forum/O365-Flows-For-sending-attachments-to-SharePoint-libr...

https://powerusers.microsoft.com/t5/Flow-Forum/Save-email-email-message-to-Sharepoint/m-p/9076/threa...

https://powerusers.microsoft.com/t5/Flow-Forum/Issue-with-Outlook-folder/m-p/1633/highlight/true#M19...

https://powerusers.microsoft.com/t5/Flow-Forum/Store-email-in-SharePoint/m-p/21473/highlight/true#M5...

https://powerusers.microsoft.com/t5/Flow-Forum/Store-email-in-SharePoint/m-p/21473/highlight/true#M5...

 

Most people ask for a very specific implementation (e.g. Store email in SharePoint), but as we already have the facility to create files in SharePoint (and DropBox, OneDrive, Google Drive, Box.com) we just need a generic function in each of the provided email services to 'Get email as MSG'. From here on the MSG can be passed into other services without tying the implementation into a specific service.

 

Status: Planned

Thanks for the feedback (and the great evidence collection linking to the various posts!). We are now planning on doing this feature. Thank you!

Comments
by allg33k
on ‎10-12-2016 06:02 PM

This is pretty much as the Subject reads.  I'm currently trying to make a simple helpdesk ticketing solution on SharePoint Online.  However as you all know the ability to email lists is not available.  I've come up with a few solutions.

 

1. Create a site mailbox, create a forward from our helpdesk email to that, then create a rule that moves all incoming emails to the documents folder in Outlook that actually points to sharepoint.  *** Worked in theory.  Was just going to run outlook on a vm that would run the rule since I couldn't make the rule on the OWA/site mailbox page.  But the Outlook rules won't allow you to choose the Documents folder.  You can drag and drop it manually though. So this one is busted.

 

2. Use a rule that runs a script which copies the email as a .msg to a network folder.  Then use a third party tool (we own one) to sync that folder to a sharepoint list. *** Haven't been able to find a script that works. So this one is sorta busted.

 

3. Put up a SharePoint Foundations server so I can email a list, then use the third party tool to sync the list up to 365.  *** This should work but really seems like a lot of work.

 

4. Come here and see if Flow or it's communtiy can help me come up with an easier solution.

 

Right now I'm hoping 4 works out.  Thanks in advance!

 

by allg33k
on ‎10-12-2016 06:50 PM

I made this post before I tried to make one on my own.  I just looked through the templates.  So at this point I have tried to make a flow and it appears I should be able to do what I want, however I'm missing somthing.  My test is taking an incoming email and creating an entry on my custom list.  However it is not adding the attachment to that list if there is one.  I'd like the new list entry to have the subject, the body of the email, and any attachments added to it. I'm getting a new item on SharePoint but no attachments or body. Basically just the subject and that's it.  Do I need a column in the list that matches the name of what it is in an email? For instance right now my Subject line is showing up in a column called Subject...which is the Title feild renamed.  So do I need to add a column called body for that to get put there? 

by allg33k
on ‎10-12-2016 06:56 PM

Nope that didn't work.  Help.  Smiley Happy

by allg33k
on ‎10-18-2016 05:00 PM

I apologize, I didn't quite understand the organization of the forum when I first posted.  I posted something similar in the Flow Forum and ended up building a flow to accomplish what I needed.  Would be a lot easier if you could just get the entire email as a .eml file somehow though. 

 

Here is my solution: https://powerusers.microsoft.com/t5/Flow-Forum/How-To-Email-and-Attachment-to-Sharepoint/m-p/8712#U8...

by JRitmeijer
on ‎02-20-2017 05:59 AM

This is a great idea, but very much tied into SharePoint. I have created a more generic version of this idea at https://powerusers.microsoft.com/t5/Flow-Ideas/Ability-to-extract-email-as-MSG-or-EML-file-from-vari.... That way it can be used in all services, not just SharePoint.

 

Please upvote

by allg33k
on ‎02-20-2017 07:08 AM
I made the same request months ago! However I needed a solution and had to work around it. I'd love to see the message come as a full file. I used to be able to do that on prem with the mail enabled web parts.
by Flow Staff Stephen
on ‎02-24-2017 06:42 PM
Status changed to: Planned

Thanks for the feedback (and the great evidence collection linking to the various posts!). We are now planning on doing this feature. Thank you!

by allg33k
on ‎02-24-2017 09:15 PM
Much appreciated! This will make the process that I am doing much easier. Then we will also be able to delete the email out of the mailbox after the flow runs. As it is now we have ended up keeping all of the email in the mailbox because there could be scenarios where my work around may not capture everything in the email. Mostly because the number of attachments is not predictable. Especially if someone put several screenshots in the email or had images in their signature. I've had several requests for different uses that capturing the entire email as a single file will resolve. Is there a way that we will be notified when this feature becomes available?
Labels
Idea Statuses