Answered

Save email to Sharepoint document library (full email)

(3) Share

Report

Posted on by BalletBob

Hi,

We'd like to save a copy of an email to a Sharepoint document library for future reference. These are our outbound marketing emails and don't have attachments. We'd like to capture the body of the email, preferably how it looks in email.

Any ideas?

Thanks

Damien

Categories:

General topics

I have the same question (0)

All responses (19)

Answers (1)

v-yamao-msft on at

Like (1)

Report

Hi BalletBob,

How about using a “Create file” action of SharePoint Online to save emails?
I had a flow, “when a control is selected, send email(Subject and Body were set to Ask in PowerApps), create file in SharePoint(File name and File content were set to Ask in PowerApps)”. In the App, I added one Button and two Text input(Text input1 for subject and Text input2 for Body), then added the flow to the Button. when the button was clicked, someone received the email and a file was created to the SharePoint library.
Here is a screenshot of my flow, please try if it works for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Courtenay 52 on at

Like (1)

Report

Hi there,

I just wanted to update this thread.

It is now possible to do this within flow using Parserr. We have just joined the Flow community and wanted to thank everyone in the flow team for making this possible:

https://flow.microsoft.com/en-us/services/shared_parserr/parserr/

Parserr allows you to turn incoming emails into useful data to use in various other 3rd party systems.You can use to extract anything trapped in email including email body contents and attachments.

Have a look here: https://parserr.com

Was this reply helpful? Yes No
C_Helzer 4 on at

Like (1)

Report

anyone know of a working solution? When I try this, the resulting file is a blank email file.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (6)

Report

The solution is pretty strait forward now.
The best practice is to combine outlook mail rules and Power Automate flow.
You can set up a folder, and use mail rule to determine which mails need to be archived (move the mail to this folder). And then in Power Automate flow, just monitor the new mails to this folder.
It will be better to add a time stamp to the file name.

Was this reply helpful? Yes No
BalletBob 66 on at

Like (3)

Report

I've marked this as the solution as both Teams and Sharepoint now natively support viewing MSG files which they didn't when I posted the question.

I was looking to end up with a PDF or image file but I guess I no longer need to.

Was this reply helpful? Yes No
Amgarnier 5 on at

Like (1)

Report

This is great thanks for the update

Was this reply helpful? Yes No
XSpence8 29 on at

Like (1)

Report

@Anonymous trying this and getting a failure, advising me to inspect my inputs. Any thoughts on what I missed?
EDIT: Adding flow details

Was this reply helpful? Yes No
JP-007 15 on at

Like (0)

Report

This worked nicely. But there seems to be a problem. When you open the created email in the browser (preview) it takes ages to open. This only affect emails 'created' with the method you posted. Actual emails dragged and dropped into sharepoint open with no problems.

A second issue is, if you download a 'created' email, it will not open in outlook. Error:
"We can't open #filename It's possible the file is already open, or you don't have permission to open it."
FYI, I definitely have permissions on the file.

Any ideas on either issue?

Was this reply helpful? Yes No
JP-007 15 on at

Like (1)

Report

Please note, if you have trouble opening the file (email) after you re-download it, you may want to change the file ext to .eml

Please see this link... Solved: Not able to open email (.msg) file locally, create... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
skagawa 11 on at

Like (1)

Report

I used this same flow and got a blank message

Was this reply helpful? Yes No