Flow sends emails based on Form responses. How can I save a copy of those emails to SharePoint?

[Anonymous]

I have a Form that processes through Power Automate and sends an email summary of the responses to the person in the office responsible for dealing with the request. As the creator/monitor of this, I get a copy of all the emails and have been saving a copy in my Outlook using Rules. Instead, we need a copy to be archived in SharePoint and not my email (because I'm retiring!). 

Can I incorporate into my current flow a way to save to SharePoint each of those emails that PA generates? If so, what are the broad strokes of how to do that? Once I get into the weeds of it I may have more questions, but I just need a plan.

Thanks

[Sundeep_Malik]

Hey @Anonymous 

You can make another flow whose trigger would be when an email is received. In its subject filter give the same subject that you are sending in the above mails. 

After this you can use export email action. And after this you can use create file action to store that email in sharepoint Library. 

Giving you links for the same:

https://www.oneplacesolutions.com/save-important-emails-to-sharepoint-with-microsoft-flow.html

https://powerusers.microsoft.com/t5/General-Power-Automate/Save-email-to-Sharepoint-document-library-full-email/td-p/4440

I hope this helps 🙂

[RobElliott]

@Anonymous why not just save the form response directly to a SharePoint list instead of saving to email first?

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP UK (and classic 1967 Morris Traveller driver)

[Anonymous]

Saving it/Sending an email allows me to format it as a nice table that everyone can read easily. I would like the archived SharePoint email to have the same layout. (If I'm understanding your question correctly). 

Formatted email

[Anonymous]

Excellent. Almost. It exported the email before the intended person in the office received it. So I need it to export a copy of the email. Or re-do my original flow to send a notice of a new email in Sharepoint. I'd prefer to export a copy.