web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Power automate flow - extract ZIP file

(0) ShareShare
ReportReport
Posted on by 439

Hi,

I designed cloud flow in power automate and as flow is triggered a record is received (get) where also all of attached files are being archived into the *.ZIP file format  and that *.ZIP file is send with that record to BC SaaS. But I need that ZIP file will be extracted and send the extracted files in PDF file format to the BC SaaS.

My solution is to create new table ("Employee Attachment") and link that table with T5200 - Employee and as records is inserted from that Cloud flow, the extracted files will be inserted in the BLOB field; new records will be created for each file that is inserted.

Should I do the extraction of ZIP file already in the cloud flow, or as file is inserted in BC, then with some procedure to extract ZIP file and insert the extracted files.


I saw that BC version 15 supports blob storage module, but now sure to use that, since it cost additional money, which my client does not want to spent...

Do you think this will work?

Thanks Damjan

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,105 Moderator on at

    Business Central SaaS have no generic support for unzipping files so i will recommend you unzip the files before you try to send them to BC online.  If you want BC to trigger some kind of automatic unzipping you will have to use Azure function for that.  As long as you stay within the DB size of your license there is no additional cost for storing blobs in BC. But with BC 19 you have the option to also use Azure blog storage for storing files and reading files from within BC.

  • Damjan Zakojc Profile Picture
    439 on at

    Hi NorthW

    for Azure Blob Storage, can we user free subscription? There will not be more then 2 GB of data in 1 year. That is why I was trying to avoid Azure Blob Storage.

    But with Azure Blob Storage, I saw that Power automate has a trigger Azure Blob Storage to save and to extract ZIP files.

    pastedimage1638353820467v1.png

    Thanks Damjan

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans