Power Automate - Unzip files from Incoming email attachments
Vložit
- čas přidán 28. 08. 2024
- This video explains how you can unzip a zip file using power automate flow.
Video also explains how to use incoming email trigger , store the attachment in SharePoint folder and store in SharePoint library.
Thanks
great instruction, super easy to follow, thanks for the help !
Thanks !
Great video - simple to follow and worked first time for me - many thanks!
Glad it helped!
Great video @m365techhelp
Very helpful video. It helped me do the job on point. Thank you so much for posting this video.
Great thank you so much!!! Helped me solved a problem very quickly.
You're welcome!
Thanks for this video. Wondering how you might extend this flow so that the unzipped file can then be attached to an email?
Muy buen video, me funciono para extraer archivos de tipo Excel
Microsoft needs to make it so that you can name the extracted files easily.
Thanks for the video! Quick question - My flow failed and it says 'To make this flow work, inspect the inputs to this action and ensure they would provide the correct inputs.' and I'm not sure why. The flow initially was successful but on the second run it failed.
Thank you. It really helped.
Thank you so much r for sharing this amazing video. I have a question on this. When I follow the steps, it saved both extracted excel file and zip folder. Can we save only extracted file from zip folder? I really appreciate if you could advise me.
Thanks For help
It worked in one go !
Nice video mate. Just have come across your channel. Looking forward to watching your other vedios on power automate.
But I tried this flow and it doesn't work for me. I am getting am error on variable assignment.
the unzipping does not work. the workflow only saves the zip attachment to the folder.
same here. It's simply placing the zip file there and that is also corrupted.
Very helpful video. One thing need get your instruction. If I don't need that zip file and original folder and just an excel file appears at destination path. How do I do? Thks!
Hi good explanantion, Had a doubt if email attachment having email only and inside email attachment there is zip then how do we extract that zip file from email attachment inside email?
This helped me a lot, and was easy to follow - thanks. Is there any chance of a video showing how to then delete the zip file, as once it's extracted it's not required anymore.... Thanks again
To add to this question, Is there a way to have the extracted file go to the folder that the zip file was in instead of a new folder?
I have a file that is a .csv but the automated email that comes to me is .csv.gz (not sure how that is compressed) but it is. How can I get it to work with that?
is this possible if I have to save unzipped file in one drive ? (instead of sharepoint as directed in this video). if so , what is the action that i can use ? please reply it is very urgent
good explanation, can we extract password protected files?
Thank you. However, when I attempt to "Extract" the ZipFile with the "Extract Folder" action, the flow fails. It appears that when the "Create File" action creates the ZipFile from the Email Attachment, the ZipFile is corrupted and is no longer a "Zip File". I can't even open it when I download the document. Any Ideas?
In that action, i use this function to de "File contect" and works for me: base64ToBinary(outputs('Get_Attachment_(V2)')?['body/contentBytes']).
It really helped and thanks you for sharing. How can I save only extracted file only?
Hi, I got stuck at getting file properties set up. What is the Library name I should give, I have different folder paths in shared documents. Can you please help me?
Hi sir
Great . Can u also share how tobsave attachment with attachment to desktop folder or onedrive
Consider we are getting Subject attachment daily and we need save it and rename it as per date
Very good video. could you give me a bit more advice, What if i need to rename the file output from unzip attachment by add received date time to file name?
my winzip has only 1 text file, but it fails with this error 'Unable to extract contents of file', and when i go check the file. the file size is just 1 kb. doesnt seems to be created at first place. any help ?
I am facing the same issue, could you solve it?
👍👍👍
hi , how we can configure flow if zip file has password protected, and i need to extract files to my sftp folder.
the extracted folder is not even completely downloaded. What could be the issue here?
Estou com um problema ao extrair, preciso sobrescrever/substituir o arquivo e isso causa um erro, há alguma solução ?
hola, saludos. me gustaria saber como sería si dentro del adjunto solo quiero que me extraiga el xml que es el archivo que me interesa. al extraer del correo me está arrastrando tambien la imagen del logo que acompaña la firma de correo y no quiero. y si quisiera que en una misma carpeta me extrajera todos los zip y no en una carpeta para cada uno? agradezco tu ayuda
Thank you so much bro. Can you help finding a way to convert the file type csv to xlsx?
Extraction how to do in one parent folder
Hi, pls explain me to how to save this files to one drive also
Is possible unzip multiple files in same folder? I can only unzip 1 :(
Thanks for your question.
It works for multiple files in the same folder.
I tested myself with 4-5 files in a single zip, these are extracted without any problem.
Please try to follow the same exact steps, it should work.
@@m365techhelp thanks for the reply back and will start all over because it only unzip the 1st file. Thank you for your time
what if you want to unzip it but without folder, how are you going to do that?
You just need to change the destination path without folder (select root folder directly)
Hello, I have the same question. Can you please elaborate on what to change to only extract the file and not create another folder?@@m365techhelp
Where to ask doubts ? Telegram or any social media handles?
You can write your question in the comments Or drop it on my email - krishan.sharma4324@gmail.com
@@m365techhelp What if we have more than 100 files in the zip file how to handle that sir .
@@madhusmita0712 I did unzip with more than 10 files. So, I don't see any problems unzipping more than 100.
If you are facing issues unzipping more than 100 files, then let me know I will test it at my end too.
@@m365techhelp There comes an error saying unarchives a file of 100 in the file . The limit is hundred for unzipping a zip file .