Create files from attached emails

[MihailZlatilov]

Hi guys,

I have a very simple flow that consists of the followind steps:

1. When a new email arrives in a shared mailbox (V2)

2. Apply to each (Attachments)

3. Create file - it creates files from all the attachments

But the above works fine with all files and zipped files. 

However, if there is an attached email in .eml format I cannot save it. 

Would you be so kind to give a hint how to achieve that and save the attached emails?

Thanks a lot!

[SudeepGhatakNZ]

@MihailZlatilov ,

In Power Automate, attachments are classified into two types: file attachments (e.g., .txt, .zip, .png, .pdf, etc.) and item attachments. While file attachments can be retrieved by the trigger, item attachments cannot be retrieved due to a known limitation.

You can utilize the GRAPH API for your use case

Get attachment - Microsoft Graph v1.0 | Microsoft Learn

[MihailZlatilov]

Dear Sudeep,

Thank you so much for your help. I have tried already the "Get attachment" action, many times over, bu it does not recognize the attached emails as attachments, you can find an attached .png of my attempt, I have tested with 4 attachments - 2 .pdfs, 1 .zip file and 1 attached email - .eml. It recognized only 3 attachments. If I am right and this does not work, can you tell me how exactly should I use the said GRAPH API, do I get it in the Premium License PA I have?

Thanks,

Mihail

[AlexEncodian]

@MihailZlatilov / @SudeepGhatakNZ 

Try using Encodian's Get Email Attachments actions (no premium licensing for PA required but its a 3rd party connector free for 50 credits per month)

[SudeepGhatakNZ]

Either try the Encodian action or use the GRAPH API.

Not all GRAPH actions require premium license.

[MihailZlatilov]

Dear Sudeep,

This is exactly what I want to do - use the Send an HTTP request V2 from Office 365 Groups Connectors and follow the rest of the steps, but unfortunately I am too lame to do it on my own. Could you please elaborate how you set up the URI for the action and what are the next steps to get to the final one - Create file? I will gladly accept this as a solution and give you a thumbs up afterwards! 🙂 Thanks a lot!

[SudeepGhatakNZ · Accepted solution]

Hi @MihailZlatilov ,

I have attached a sample flow (see attachments section). I'll blog about it later.

There is an HTTP connection for Outlook as well.

[MihailZlatilov]

Dear Sudeep,

Thanks, I this is going to work, but I have tried to do it for a When a new email arrives in a shared mailbox (V2) and some how it does not work, can you alter for me the flow so that it works with shared mailbox? Thank in advance!

[SudeepGhatakNZ · Accepted solution]

Hi @MihailZlatilov ,

The end point I provided is for the user's own mailbox. For shared mailbox, endpoint is different, but the logic remains the same

https://graph.microsoft.com/v1.0/users/{sharedmailboxmailaddress}/messages.

[MihailZlatilov]

Dear Sudeep,

Yes, but the action When a new email arrives in a shared mailbox (V2) does not have an output as When a new email arrives (V3) - the body/value of the email, which is giving me an error, how do I overcome it?

I think it should work afterwards.

Bests,

Mihail

[SudeepGhatakNZ]

Are you able to add a compose action under trigger and display the value of the body/value field?

I want to see how is it structured. Sorry, I dont have access to mailbox that I can test with

[MihailZlatilov]

Hi Sudeep,

Sure, it returns this error:

"The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/value']' is of type 'Null'. The result must be a valid array."

Bests,

Mihail

[SudeepGhatakNZ]

Let me set up a shared mailbox and get back to you

[SudeepGhatakNZ]

You might be using the wrong trigger

[MihailZlatilov]

Hi Sudeep,

If I put Compose directly I get all from the shared mailbox:

But If I try to use in the loop following your instructions I get only the Attachments:

[MihailZlatilov]

@SudeepGhatakNZ I know you did a lot to help me, but could you please tell me how to solve the issue from my last response - I am unable to pick up the necessary value? Thank a lot in advance, I highly appreciate it! 

Bests,

Mihail

[SudeepGhatakNZ]

I will share a sample tomorrow

[MihailZlatilov]

Hi Sudeep, have you got the chance to build an example flow for my complicated case? 🙂

[SudeepGhatakNZ · Accepted solution]

Hi @MihailZlatilov ,

Lovely talking to you.

I think for your scenario, you could get the email forwarded to a user/service mailbox and leverage the GRAPH api as suggested above.

[MihailZlatilov]

Hi, Sudeep,

Lovely talking with you too. Thank you for your time and advices. Noted, obviously this is the only plausible solution and I will follow it.

Have a nice day!

Bests,

Mihail