Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Power automate flow - extract ZIP file

Posted on by 431

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

Categories:
  • Damjan Zakojc Profile Picture
    Damjan Zakojc 431 on at
    RE: Power automate flow - extract ZIP file

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Power automate flow - extract ZIP file

    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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans