Skip to main content

Notifications

Power Automate - General Discussion
Suggested answer

How do I unzip a zip file when a new or modified file is detected in Azure Blob Storage?

(1) ShareShare
ReportReport
Posted on by 789
Hopefully this is the right forum to ask this.
 
Here is my situation. I have a file that is being written to an Azure Blob Storage container on a regular basis. This file, unfortunately, can only be delivered zip due to its size. I want to use the CSV stored in the zip file in PowerBI however PowerBI can not natively read a zip file. What I am looking for is a way to maybe use PowerAutomate to look for new or modified blobs (looks like there is a trigger for that) and, if it finds one, unzip the file right there in the Blob Storage container. Is there a way to do this? I am not finding any actions the explicitly say they perform this function. Perhaps I need to move the file to another location first where PowerAutomate has an action to unzip a file and then transfer that file back to Blob Storage.
Categories:
  • Suggested answer
    trice602 Profile Picture
    trice602 11,848 on at
    How do I unzip a zip file when a new or modified file is detected in Azure Blob Storage?
    Hi,
     
    One recommended "easy path" is to leverage Power Automate for Desktop.  While is seems like a band aid, some of these tools will run flawlessly for years.  Check this out!
     
    • Add a Run a Flow Built in Power Automate Desktop action in your cloud flow.
    • Create a Power Automate Desktop flow to:
      • Save the ZIP file to a local directory.
      • Use the Extract archive to folder action in Power Automate Desktop to unzip the file.
      • Upload the extracted files back to Azure Blob Storage using Upload file to Azure Blob Storage.
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard