Unanswered

Save Approval Mail Response in Sharepoint folder

(0) Share

Report

Posted on by Community Power Pla...

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:

File A approval.png

Current flow looks like this:

If approved.png

Does anyone got any ideas?

Best,

Morten

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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..

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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! 🙂

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
gurmeetKRahi 4 on at

Like (0)

Report

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

Thank you

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No