Forum Discussion
unzip files from email
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,
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.
3 Replies
Try adding a custom column that does the unzipping, and then performing combine on that new column.
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.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
