Save Approval Mail Response in Sharepoint folder

[Anonymous]

Hi all. 

I have an approval flow that if approved, sends the requestor a confirmation email. 

I need that confirmation email to save as a .msg format in my sharepoint library. My attempt at the flow is below. The flow works but the format it saves of the response email looks like this.. not the file im looking for:

Current flow looks like this: 

j

Does anyone got any ideas?

Best,

Morten

[yashag2255]

HI @Anonymous 

In your create file action, can you replace the .approval with .msg? 

I just made a test on my side and this works.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Expiscornovus]

Hi,

You should be able to use the Outlook connector for this. It contains the export email action:

https://flow.microsoft.com/en-us/blog/outlook-connector-more/

[Anonymous]

Hi @yashag2255,

That did change the format to .msg!

So then I am halfway there.

Unfortunately, it did not grab the content of the mail, so when I click the link its blank..

[yashag2255]

Hi @Anonymous 

I just made a test on my environment and you should use the Export Email option as suggested in the other post but save it with the .msg extension. Refer to the sample screenshot below:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Hi @yashag2255,

I tried the solution suggested, however, I'm not able to find "Message Id" in the dynamic content. Do you know how I can get that? 

I think it is related to my trigger being a selected file in sharepoint, and not "When an email arrives" like the flow you tested above.

Also, do you know the difference between "Get email" (like I have in my original attempt, please see screenshot in original post) and "Export email"? 

I guess these questions are for both of you @yashag2255, @Expiscornovus. 

Thank you! 🙂

[yashag2255]

Hi @Anonymous 

Okay. So you can get the Message ID of an email when it is sent or recieved. In the flow action we are using send an email but unless this action is executed the email is not sent and therefore we cannot get the ID of this email to get the email or export it. (Basic deiffrence would be, after getting a particular email you can add an action to reply to it and refer to the Get email action and in the export email you can export the details - to, from, subject and body). 

One way of doing what you want to is, create two flows. 1 will run until the send an email action in your flow. 2nd will have the get email action and then create file from that. The second flow will be with a manual trigger and in the 1st flow, you can add an action to run a flow after the send an email action. makes sense?

Hope this Helps!

[Anonymous]

@yashag2255 

I understand what you mean (I think).

However, will this not be an issue concidering that this is not a personal flow. Meaning, if I do it like you suggest, would it not require everyone in my company to install the flow, to have access to their outlook?

Thanks!

[yashag2255]

@Anonymous 

You would add all the other users as run as users right? You can ask them to provide the conenction to outlook (or the other specific actions) for both the flows. Also, adding people as CoOwners will make them run the flow with the connections of the Owner of the flow. 

Hope this Helps!

[gurmeetKRahi]

Hi,

Did you end up getting any solution to this? any update will be appricated.

Thank you

[yashag2255]

Hey @gurmeetKRahi 

Can you share details on the scenario that you are trying to build? For exporting outlook emails, you can use the when a new email arrives trigger, then the export email action and then use the body of the export email option to save it is an eml or msg file in the document library (or the place where you want to save it)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Hi @yashag2255 

I'm also encountering this issue of not having the Message ID. If creating 2 flows, is there any way to trigger the 2nd flow automatically?

I'm actually creating a Microsoft form which allows users to submit a job request. Once submitted, the flow will trigger to send an approval email to certain managers. Once the manager approves, there will be another email sent to user to inform him / her the request has been approved. Up to this part, the flow works perfectly.

However, I want to keep this approval email in SharePoint Document Library as a record. Are the "Export Email" and "Create File" actions the only way of doing it? I noticed some people mentioned about using " When a new email arrives" action but is this action checking the "Inbox" of my own personal Outlook mailbox since for my scenario, the approval email is being sent to user.

Any  advice is appreciated.

[Anonymous]

@Anonymous and @Anonymous  did you ever get this to work?  I need the "approval email" saved as a file in a sharepoint folder but I'm not having any luck figuring it out.

Thanks

Shelly

[sambr1]

were you able to make this work? how to get Send Email Body in "Get Email" or Export Email.

please respond me if you got solution?