unzip files from email

[Priya2007]

Hi ,

I am trying to unzip files from an email.

In zip folder I have two files one is csv and other is xlsx.

I am getting below error:

If anyone can help would be great.

Regards,

[v-jingzhang]

Hi @Priya2007 

Have you solved this problem? If so, kindly accept an appropriate reply as Solution or post your own solution to help other people find the solution quickly. If not, please provide more information about it. Thanks.

Best Regards,
Community Support Team _ Jing

[v-jingzhang · Accepted solution]

Hi @Priya2007 

You can create a custom function with M code from this blog  Reading Zip files in PowerQuery / M, then add a column to your current table by invoking this function (Add column tab > Invoke Custom Function). You will have a table content in the new column. After expanding the table, you will see all files in this zip folder and you can access either one you want. 

Here is a video tutorial for it: Get data from zip files without extracting them in Power Query - YouTube

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Ehren]

Try adding a custom column that does the unzipping, and then performing combine on that new column.