Answered

Microsoft Flow - Extract zipped email attachment on incoming email to folder on OneDrive

(1) Share

Report

Posted on by Community Power Pla...

Hi All,

I'm finding Microsoft Flow to be extremely frustrating and wondering if here is help available here!

I'm trying to setup a flow based on the subject line of an email so that the attachment gets unzipped to a folder on OneDrive (please see image below) as it comes in to my mail box.

I get an error which I do not understand.

My understanding is that 'On new email' task I have set it to take emails with the specified subject line, then pass that attachment to 'Extract archive folder' under 'Apply to each Attachment on email'. So now that task should extract the zipped attachment to the folder specified below.

2020-03-13 11_00_12-Window.jpg

When I test the Flow and get the error:

2020-03-13 11_18_12-Run History _ Power Automate.jpg

Thanks

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

fchopo 8,003 Moderator on at

Like (3)

Report

Hello @Anonymous
Have you checked if the attachment is a zip file? Have a look at this example:
The steps are the following:
1) We check if the email Has Attachments (Has Attachments is equal to true).
2) For each attachment, create a file in OneDrive.
3) If the file is a zip compressed file (Media Type is equal to application/zip)
4) Extract the archive to the folder.

Hope it helps!
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @fchopo,

Thanks for your help on this. I followed your instructions and it moves the file to my desired folder but does not unzip.

The file type is: WinRAR ZIP archive (.zip) and it is password protected (which I forgot to mention previously).

Do you know how I an supply the password to flow assuming that is the issue?

Thanks

-PS - I should add that Condition 2 came out as False even though I set it to: application/zip

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (2)

Report

Hello @Anonymous
I have tested the flow and you are right. After a little of investigation, I discovered that the media type value is application/x-zip-compressed.
On the other hand, it's not possible to extract an password protected zip file, as stated in this thread: https://powerusers.microsoft.com/t5/General-Power-Automate/Password-protected-zip-files/td-p/29184
Hope it helps!
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @fchopo

Your solution is still useful knowledge. Shame about the password issue.

Cheers!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Is it possible to unzip password protected .zip files using flow?

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (1)

Report

Hi @Anonymous

No, it's not possible.

Regards,

Ferran

Was this reply helpful? Yes No
Daimao666 2 on at

Like (0)

Report

Does this save both the zip and extracted file to the folder ? If it does, can you autodelete it afterwards ?

Was this reply helpful? Yes No
Kesia 2 on at

Like (0)

Report

hello @fchopo ,

where can I find the media type to precise the value is application/x-zip-compressed?
I only whant to get the Zip file inside the email and not the others attachements like the images etc

thanks

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hi @Kesia

You can read the content-type value from the get attachment action:

Hope it helps!

Ferran

Was this reply helpful? Yes No
domuniz47 10 on at

Like (0)

Report

Thank you sooo muuuuch!!

Was this reply helpful? Yes No