Power Platform Community Forum Thread Details

Hello, I’m uploading a .msg file to a SharePoint folder, which then triggers a Power Automate flow. The .msg file contains the email body along with a PDF and an Excel attachments. I want to know if it’s possible to extract the .msg content uploaded to SharePoint as well as the text/data from the attached PDF and Excel files from the .msg file stored in SharePoint within the flow, and if so, what the best approach would be. Thank you.

Categories:

Building flows

Hi @CU04022236-0

Cloud-based approach is to use an Azure Function to parse the .msg file and then call that function from Power Automate using an HTTP action. In this solution, when a .msg file is uploaded to SharePoint and triggers the flow, the flow retrieves the file content and sends it (typically as base64) to an Azure Function endpoint. The Azure Function, written in Python using the extract_msg library, reads the Outlook message file, extracts the email subject, body, sender details, and all attachments (such as PDF and Excel files), and converts them into a structured JSON response. The function can return the email content as text and the attachments as base64-encoded files. Power Automate then receives this JSON response, processes each attachment accordingly (for example, sending the PDF to a document processing service or reading rows from the Excel file), and stores or uses the extracted data as needed. This architecture is scalable, secure, fully cloud-based, and ideal for enterprise-grade automation.