Unanswered

Power automate get attachment V2 (o365 outlook connector) is not recognize the .EML and .MSG format files

(1) Share

Report

Posted on by Jagan45

I'm trying to export the .EML and .MSG files from email. Power Automate only recognize the particular file format such as .pdf , .jpg, .xlsx etc. so instead of using get attachment connector I've used send HTTP request connector to get the attachment data. I'm able to process and get the data of the attachments of .EML file but there is difference in time and time zone. Power automate connector is considering the time as UTC not writing the same value .

Can somebody assist me on this issue ?

Categories:

General topics

All responses (8)

Answers (0)

Sort by

sandeepstw 312 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

To address the time and timezone discrepancy in Power Automate when processing .EML or .MSG files using the HTTP request connector, you should adjust the datetime value using the 'convertTimeZone' function.

Get data from the datetime value from the attachment data. And use 'convertTimeZone' like this example
"@convertTimeZone(triggerOutputs()?['headers']['x-ms-file-last-modified'], 'UTC', 'Your Desired Time Zone')"

Replace these value 'Your Desired Time Zone' and 'Eastern Standard Time' with appropriate values.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra
Jagan45 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sandeepstw ,

Thanks for your response.

Are you suggesting me to use HTTP request instead of using Send an HTTP Request (outlook connector) ?

If yes, could please guide me as I'm new on using the HTTP connector. If you do have any different ideas please suggest me as well.

This was the actual output I'm getting while using Send an HTTP request to get the actual attachment content.
Jagan45 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlexEncodian & @sandeepstw ,

Thanks for your suggestion . Can we achieve it by using default power automate connectors instead of using Encodian's connector?
AlexEncodian 4,409 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes - if your flow is triggered by a new email arriving, then you don't need to extract attachments from .EML and .MSG files. You can simply use the outlook get attachments action for that specific email.
Jagan45 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlexEncodian ,

I tried but it could recognize only excel file not the email attachment (.EML)
Jagan45 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Can somebody please help me to get .eml attachments present on an email using power automate flow.
markdaniel01 10 on at

Like
a
(0)

Report
Copy link

Link copied!

You want to find the best software to convert EML files to MSG and then use the ToolsBaer EML File Converter tool. This software helps to convert EML files to PDF, PST, MBOX, CSV and other file formats like MSG, including all their email attachments. It also allows you to import multiple EML mailboxes from various email clients like Gmail, Yahoo Mail, Thunderbird, AOL, Office 365, etc. Furthermore, this professional software is compatible with all versions of Windows Operating Systems like Windows 11, 2015; 10, and 365. 8.1, 8, 7, Vista, XP, and below. Moreover, this automation tool is user-friendly and easy to use.

Read more: https://www.toolsbaer.com/eml-to-msg-conversion/
Rzelaya 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Help, I have this issue that i want to extract a Pdf that comes in a .eml format, how you manage to solve it?