Тёмный

How to create Zip files in Power Automate for free, without premium actions or 3rd Party Connectors 

Paul Murana
Подписаться 6 тыс.
Просмотров 16 тыс.
50% 1

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 105   
@bobleach
@bobleach 3 года назад
Hey Paul, Thank you ever so much for this, it's perfect and what I've been trying to find for several months. I've already subscribed to your channel, but I must have missed this. keep up the great work 👏
@jrockno
@jrockno Год назад
Great stuff Paulie! Exactly what I needed. Your content is a treasure. 👍
@Jacobhblau
@Jacobhblau 7 дней назад
This video is savage! Works like a charm. This guy is on another level
@akshaynm
@akshaynm Год назад
Great Workaround Paulie, many thanks for sharing.!!
@365g
@365g 3 года назад
Many thanks Paul. Once again I've learned something new, extremely useful and very cool! Great work 👍
@ExcelOffTheGrid
@ExcelOffTheGrid 2 года назад
Amazing stuff. So if we can unzip and re-zip, we now have the ability to change the XML of any office document. I'm going to be busy playing for a few weeks now.
@PaulieM
@PaulieM 2 года назад
Yep - Had a look at your content - I bet you’re gonna produce some amazing solutions. Be cool if you got in touch through my blog - would love to connect with someone with your skills
@ImuRazz
@ImuRazz Год назад
I have learned so much from you, I can't thank you enough for sharing your knowledge with rest of us. THANK YOU!!
@PaulieM
@PaulieM Год назад
Really pleased to hear that great feedback - anything else you’d like to see covered?
@karukarthi2609
@karukarthi2609 3 года назад
Hi Paul, Thanks for your video.. Really helpful and right time I'm watching this 👍😊 My use case here is, Image compression in sharepoint online using rest api and trying to create a html file by having 70+ images and converting into pdf using Power Automate without using any premium & third party connectors. Going with one Drive option and Capturing and uploading images through powerapps and storing it sharepoint document library. Due to 2mb limitation of html file, not able to achieve the pdf generation by having single pdf with all 70+ images. Through your video, planing to split the pdf and store it into one drive by having 6 files and making a zip file finally.. Please share your insights on this and not sure my approach is correct in order to achieve the same. Thanks!
@aaronalbers7280
@aaronalbers7280 4 месяца назад
Thank you Paul for this. Curious of your thoughts on a folder with different doc types such as pdf, word doc, png, jpegs etc and concatenating them into a single pdf doc. I dont have access to the third party tools and have been trying to do this with work arounds.
@PaulieM
@PaulieM 4 месяца назад
I don’t think there is a way to do it without using 3rd Party Tools. Sorry.
@nehalbshah2010
@nehalbshah2010 3 года назад
on downloadzip action I get this error Http request failed as there is an error: 'Error while copying content to a stream.'.
@AlvinRyellPrada
@AlvinRyellPrada 2 года назад
Absolutely genius! this works for me perfectly without purchasing 3rd party connectors. Quickie question though, is there a possibility to put more protection to it? like adding password on my zipfile?
@PaulieM
@PaulieM 2 года назад
You would have to use a 3rd Party Connector for this (or Power Automate Desktop).
@amirzareei8374
@amirzareei8374 2 года назад
Thank you so much for sharing this extremely helpful video. I just have a problem that when I zip a sharepoint folder with more than 30 documents, it only zips the first 30. Do you know what could be the problem?
@piantospestcontrol
@piantospestcontrol 4 месяца назад
Replace the SharePoint HTTP body with this: {"parameters": {"RenderOptions": 4103, "OverrideViewXml": "3000"}}
@ahmedsassi6084
@ahmedsassi6084 4 месяца назад
i have same problem, did you find solution ?
@toddtebay5349
@toddtebay5349 6 месяцев назад
Hi - Thank you for sharing this! I am having trouble getting started. I am not able to edit flow code (generally) within Power Automate. I can "peek" at code but cannot edit. I have searched on how to enable this but cannot find a solution. Do you have any suggestions? Thanks!
@grantbartholomew3217
@grantbartholomew3217 3 года назад
Incredibly helpful thank you Paul!
@pieroalexanderrivasfaustin4201
Paulie thank you very much for the information. I have a problem, the code is not copied to my clipboard. Could you do step by step?
@dehc
@dehc 5 месяцев назад
It worked. I don't understand it all but I got it to work!!!
@jmrendel98
@jmrendel98 10 месяцев назад
Really a remarkable solution. Thank you!
@johnfromireland7551
@johnfromireland7551 3 года назад
"Dynamically create Word documents"!!! Yes, please! :-D
@PaulieM
@PaulieM 3 года назад
Been working on it for a while. Only figured out the Zip action this week. Hope you find it really useful.
@adriancelis9691
@adriancelis9691 4 месяца назад
This was very helpful. Thank you!
@tobiasmeyer2085
@tobiasmeyer2085 2 года назад
Wow, really nice work! It works flawlessly Is there any way to password-protect the downloaded zip file?
@vincentDev84
@vincentDev84 4 месяца назад
thanks for sharing , great tutorial.. i have problem, in onedrive only limit to 30 files
@ScatPackJack
@ScatPackJack 5 месяцев назад
Hey Paul, great idea, thanks for sharing. Have you found a way around the download zip file size constraint of 100mb? - "Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size"
@PaulieM
@PaulieM 5 месяцев назад
There is no solution, the maximum payload of any action in power automate is 100Mb
@2486ale
@2486ale 2 года назад
Hi Paul, Thank you for the video! We managed to get it working on a test domain and it was a lifesaver But then switching to the formal company one, we got 401 UNAUTHORIZED Can you help me or point to what I could try in the function to get it back working again? Still, thank you very much for the video!
@Tedydll
@Tedydll Год назад
In the "downloadZIP" step, put the following custom value for "Site Address" field: @body(‘SharePointHTTP’)[‘ListSchema’][‘.mediaBaseUrl’]
@TrailersYT
@TrailersYT 8 месяцев назад
Did you ever figure this out?
@2486ale
@2486ale 8 месяцев назад
@@TrailersYT yes, we went for HTML and Sharepoint
@TrailersYT
@TrailersYT 8 месяцев назад
@@2486ale is there a link to the tutorial? I keep getting the 100mb limit
@gregjohncock650
@gregjohncock650 Год назад
Hi, thanks for this. its very handy. I have noticed it seems to have a limit of 90mb of total size for the items needing to be zipped. do you know if this limit can be configured to be higher? Also, we are initiating the process through a Sharepoint App we are running, the we store the details of the files/folders to zip in a json file and the process initates when the json file gets created. We then poll the folder waiting for the zip file to be created. We cant seem to get the process below 30 seconds, most of the time its about 1 minute to 90 seconds to run. Do you have any ideas on how we might be able to speed it up?
@BBTechNerd
@BBTechNerd Год назад
Thank you for the instructions, one question, I tried to copy and past from my clipboard but after I copied your information as per your instruction, it does not show up in my clipboard.
@PaulieM
@PaulieM Год назад
Press CTRL-V when you’re in your clipboard.
@robertsonfilm2066
@robertsonfilm2066 6 месяцев назад
Would there be anyway to implement this with Sharepoint list attachments? I would like to download all attachments for an sharepoint list item into a zip file.
@1yyymmmddd
@1yyymmmddd 2 года назад
Hi. Great video. But can't you just use ZIP files action under Compression action folder in Power Automate?
@PaulieM
@PaulieM 2 года назад
If you have a built in action on your tenant that does that I’d be really interested to see it.
@1yyymmmddd
@1yyymmmddd 2 года назад
@@PaulieM I do have it in Power Automate Desktop.
@PaulieM
@PaulieM 2 года назад
@@1yyymmmddd ah ok. That’s quite a different thing to a cloud flow. That option will not be suitable for everyone.
@junomak3588
@junomak3588 Год назад
Can we use this on OneDrive too? If yes, could you also show us how to do it, many thanks!
@junomak3588
@junomak3588 Год назад
i tried to convert those SharePoint command to OneDrive but i cant find a replacement for the httprequest for OneDrive, sadly
@demodahm
@demodahm Год назад
Big thanks for the tutorial. Found something interesting though: The resulting file doesn't match the mime type of the file content, so I'm unable to upload the resulting .xlsx to some websites which perform MIME type checking. Not sure if this is related, but I took a look at the file signatures and it appears bits 7 & 8 are different, the latter being that of - 50 4B 03 04 14 00 06 00 vs 50 4B 03 04 14 00 08 08 (new). Any suggestions on how to overcome this?
@tru12
@tru12 2 года назад
Many thanks for this video. So good ! Do you think I can call this http request for just a single file ?
@abdalwahedhajomar3898
@abdalwahedhajomar3898 2 месяца назад
very helpful solution. thanks
@davidsolo3765
@davidsolo3765 2 года назад
Thats for the greate video. is possible to unzip with same method? Thank you
@nisharana5467
@nisharana5467 21 день назад
@Paul : How can zip files which are available inside multiple folder. In your case all the files are in Shared Document> Test Zip. What if I have structure like Share Document > Folder 1 > test1.png Share Document > Folder 2 > test2.png Share Document > Folder 3 > test3.png Looking for your reply on urgent basis.
@PaulieM
@PaulieM 20 дней назад
You would be better to use my zip component. It’s much easier. tachytelic.net/2024/06/create-zip-file-power-automate/
@victorionescu7653
@victorionescu7653 2 года назад
Nice work Paulie! Do you think is posible to make a zip file with password using your solutions?
@PaulieM
@PaulieM 2 года назад
I don’t think that it’s possible. This is using the action built into SharePoint.
@ScatPackJack
@ScatPackJack 7 месяцев назад
This is incredible, thank you!
@PaulieM
@PaulieM 7 месяцев назад
No problem, glad it was helpful to you.
@jayantkhushalani8639
@jayantkhushalani8639 2 года назад
Many thanks for the video Paul. However, the download zip file for me is throwing an error saying "Unexpected response from the service". Any idea as to what i can modify, as i really need this solution
@vinaykothari434
@vinaykothari434 11 месяцев назад
Hi, how did you handled that error?
@sanitkumar788
@sanitkumar788 15 дней назад
I am getting an error: "message": "BadGateway" on the downloadzip action. Any ideas on how to fix this?
@ssccservlearn
@ssccservlearn Год назад
Huge help! Thank you!
@PaulieM
@PaulieM Год назад
Thank you! It's a bit of a complex solution but does the job nicely.
@katy8161
@katy8161 Год назад
Bless you for this.
@carrsgroup3659
@carrsgroup3659 2 года назад
How on earth do you work this stuff out??? Huge help, thank you
@PaulieM
@PaulieM 2 года назад
I used the chrome developer console in SharePoint to see what API requests were issued when you want to zip a file in the browser interface.
@viniciusgarcia5399
@viniciusgarcia5399 2 года назад
Hello, Paulie. Don't I have to chane the site adress in the SharepointHttp Request?
@manuelacarreno7723
@manuelacarreno7723 2 года назад
Hi!! I tried out this solution but it creates a Zip file with all the documents of the shared documents folder, what could I do?
@aleksei_12_24
@aleksei_12_24 Год назад
Hallo Paulie, Thank you, you have helped me a lot
@PaulieM
@PaulieM Год назад
Glad to hear that!
@stlaurent26
@stlaurent26 Год назад
You sir are a legend!
@PaulieM
@PaulieM Год назад
Glad it helped!
@tasungota
@tasungota 2 года назад
Excelent solution, thank you
@Ziggygou
@Ziggygou 7 месяцев назад
Hi, i cannot copy paste the code. Is it possible to have a package of the powerautomate ? Thanks a lot ! :D
@PaulieM
@PaulieM 7 месяцев назад
Have you tried pasting it into the classic designer? 🧑‍🎨
@Ziggygou
@Ziggygou 7 месяцев назад
Yes, it doesn't work :/ @@PaulieM
@AsadAseem
@AsadAseem 7 месяцев назад
How do i change the rowlimit i sharepointHTTP action? :)
@PlaceTickets
@PlaceTickets 2 года назад
How it work in desktop version?
@StanleyBubb
@StanleyBubb 2 года назад
Strange I cannot seem to paste the code. Its not showing up from 'My Clipboard'
@PaulieM
@PaulieM 2 года назад
When you're in your clipboard, you need to press CRTL-V for it to appear in the list.
@StanleyBubb
@StanleyBubb 2 года назад
@@PaulieM great. Thanks mate, good vid.
@kokonaung3081
@kokonaung3081 2 месяца назад
is it also work with file system actions
@PaulieM
@PaulieM 2 месяца назад
No, only files in SharePoint. You can use my zip connector if you need more flexibility
@johntraupman2946
@johntraupman2946 Месяц назад
any chance you can zip a file on an SFTP with this code?
@PaulieM
@PaulieM Месяц назад
You’d have to bring the file contents back to Power Automate, Zip them and then put them back on the SFTP. But should be relatively easy to do.
@PaulieM
@PaulieM Месяц назад
You’d be better off using my zip component: tachytelic.net/2024/06/create-zip-file-power-automate/
@user-ht8du9ub4y
@user-ht8du9ub4y Год назад
but it is support for folders
@PaulieM
@PaulieM Год назад
Check out the blog post - there is a solution in the comments to work with more than 30 files.
@otanzion9584
@otanzion9584 Год назад
Am I the only one that couldn't copy the code to clipboard?
@sanitkumar788
@sanitkumar788 15 дней назад
Did anyone get past the downloadzip action?
@PaulieM
@PaulieM 14 дней назад
Many people have - if you’re struggling with this flow, which is understandable considering trying my zip connector: tachytelic.net/2024/06/create-zip-file-power-automate/
@marvmaster2639
@marvmaster2639 2 года назад
I love you paul
@PaulieM
@PaulieM 2 года назад
Thank you! 😂 I love all the automators !
@Chilean.Walker
@Chilean.Walker Год назад
Thank you for this video. I only have a issue in the HTTP step, ir returns the error: "File Not Found. clientRequestId: 5474c654-51cb-410c-ac95-23ae198a533c serviceRequestId: 1e00dea0-b02c-7000-5771-100059b65eeb" Can you help me?
@stewartmcgovern2k10
@stewartmcgovern2k10 7 месяцев назад
Hi, did you reslove this i have the same error?
@timoliver9892
@timoliver9892 2 года назад
Great work Paulie - I'm struggling with "download ZIP" - getting this: "401 UNAUTHORIZED clientRequestId: 5fc65939-74a3-496a-8a6d-a1c19f62ffd2 serviceRequestId: 464451a0-90e3-4000-b5a2-0a0576046d9f" Any ideas what to look at?
@TrailersYT
@TrailersYT 8 месяцев назад
Did you ever figure this out?
@AlexK-b5y
@AlexK-b5y 14 дней назад
@@TrailersYT In the downloadZIP for the Site Address try to set this: @body('SharePointHTTP')['ListSchema']['.mediaBaseUrl']. Just verify that you have SharePointHTTP for a name of the previous SharePoint post request action.
@luiz_brito
@luiz_brito 3 года назад
Hello Paulie, thanks for share with us the flow! Can you please help me? On downloadZip step, i got the following error and I'm not sure how to fix it: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.
@PaulieM
@PaulieM 3 года назад
I guess the result of what you were trying to zip was more than 100Mb - which is the maximum size for a flow action. Do you think that could be possible?
@luiz_brito
@luiz_brito 3 года назад
@@PaulieM Sorry I haven't noticed the flow has this limitation. I was wondering if this buffer size could be increased somehow...
@SDS1234_
@SDS1234_ 11 месяцев назад
Same question here
@sanitkumar788
@sanitkumar788 15 дней назад
Seems like, this flow is trying to download every SharePoint site content I can access!!. Is there a filter that we are missing?
Далее
How to use Power Automate Get Files (Properties only)
22:56