Extract attachment from e-mail within an email

[ataladayFBG]

Hello All,

I get a lot of automated reports via email and I have Power Automate save them directly to my sharepoint.

However we have a new system and it is sending the reports with an email attached and inside that email is the excel report.

Is there a way to automate the saving of the attachment within the attached e-mail?

[AlexEncodian]

@ataladayFBG 

You should be able to do this using Get Email Attachments action by Encodian. You can pass through the attached email file and it will extract its attachments (it should work on any number of nested levels).

---- 

*Encodian Flowr is a Standard Power Automate connector with 150+ actions to supercharge flow builds. Conversion, merging, splitting, OCRing, data extraction, QR/Bar codes, searching and much more. And we just added "Utility" actions, which are almost free to use and accelerate solution builds and remove maintenance overheads with actions like Extract text between values, extract URLs, extract email addresses, Password/GUID/HMAC creation, escaping/unescaping HTML, parsing HTML tables, etc.   

[v-qiaqi-msft]

HI @ataladayFBG ,

Exactly we could achieve this using Power Automate, here is a simple demo for your reference:

[ataladayFBG]

I've got it set up like your example.  I'll see if it works tomorrow morning.  Thanks!

[ataladayFBG]

Hello,

I set it up like your example.  Power Automate says it ran successfully, but I don't see anything with the correct name or saved at about the time I received the e-mails.

Any ideas what went wrong?

[v-qiaqi-msft]

HI @ataladayFBG,

You add a subject filter in your trigger, not sure if it is the key to your issue.

I prefer to add a condition to check if the subject contains some special strings, if yes, create file.

[ataladayFBG]

The Subject filter has worked fine with normal situations of triggering saving a file from an e-mail, but I have removed that filter.  These are the only e-mails I get from that e-mail address anyways.

[v-qiaqi-msft]

HI @ataladayFBG,

Is this issue still?

Not sure if the file name vaid as below:

On my side, the flow works fine.

[ataladayFBG]

Again that convert date works in my other flows so I'm not sure why it would mess this up.

Same thing.  It says it ran successfully, but there is nothing in the folder.

[Mgt78]

@ataladayFBG 

Did you ever get this working as I am trying to achieve the same thing.  I have also set up a flow like Qi has suggested but no luck - it seems to fail on the first step as it determines the 2nd email is the attachment, then can't read that the real excel attachment is within that.

[ataladayFBG]

Do you actually get a failure?  Mine says it succeeds, but no file is created.

[Mgt78]

No, just my choice of word - it "succeeds" as for as the flow is concerned but never creates a file.