How to create a flow to extract names of the file stored in zip attachment from outlook email and save the file accordingly?

[Mah14Moh]

Hi All, 

Can anyone please assist me in creating a flow in which I can extract the names of the files stored in a zip attachment in an Outlook email and save them to a folder if the name of the file stored in the zip attachment matches my criteria?

I looked on Google but couldn't come up with anything concrete.

Thank you so much in advance!

[AliB365]

Hi @Mah14Moh 

You will have to extract the zip file first and then perform a condition using a filter array in order to identify the files you want to keep.  Any that you don't need, you can delete.  For example:

Create a folder based on today's date/time (to keep the files separate), extract the zip, get the files in the folder....

Filter the files that you want to delete, for example, I want to delete files with the word Another in them, you might want another that does not contain a file extension, for example does not contain xlsx:

The easiest way to create the apply to each is to add the delete file action, insert the identifier so that the apply to each is added automatically and then change the input for the apply to each to the body of the filter.

If you've got any more questions please let me know.  I hope this helps.

Ali B

[Mah14Moh]

Thank you for the response!

I am not sure if i was able to explain it very well. 

let me elaborate it - 

Once an email arrives then the flow will automatically scan if it is a zip attachment or not and if it is a zip attachment then it will search a specific name - for an example "abc", across all the files archived in that zip attachment and if the flow founds a file with name - "abc" then flow will save the zip attachment in a specific folder.

Thank you so much once again for your support.