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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import/Export Blob-Fil...
Small and medium business | Business Central, N...
Suggested Answer

Import/Export Blob-Files in BC without Azure Blob Storage?

(0) ShareShare
ReportReport
Posted on by neckit 144

Hi,

we have our own BC-table that contains a blob field. Here we want to regularly create new records by importing CSV files without user-interaction and also export the blob fields (CSV files) to a file server directory for selected records.

My question: Is it possible to fill the BC table via "Power Automate" and also export selected files to a file server directory via another "Power Automate" job? Or is this only possible via "Azure Blob Storage"-functions?

regards
Ralf

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    Technically possible yes. But if you are using Business Central online you will need a lot of extra software components to do it.

    So you makes life a lot easier for yourself if you put the files on Azure blob storage or on OneDrive.

    For processes you want to run without user interaction Azure blob storage is preferred because it is not owned by a single user like OneDrive is.

    And it is very little code needed in BC to do this using Azure blob storage,

    Why do you want to avoid using Azure blob storage? I know it has a cost, but it is relatively cheap for the storage needed for these kind of processes.

  • neckit Profile Picture
    neckit 144 on at

    Inge is probably right and Azure is the best choice and then for my purposes "Azure File" (with synchronized Azure File Share).

    However, I can't find any detailed documentation about what options I have from AL. For example, how can I perform typical file operations here:
    - Process files from a folder
    - Delete or move file
    - Read file
    - Write file
    And what other options do I have?

    It puts me off that I haven't found any extensive documentation on this yet. Do you have a tip for me?

    greeting
    Ralf

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    I have some very simple code for this in a public Github repository.

    github.com/.../GenJorunalImport

    This checks for new files in a Azure blob storage and creates journal lines from the CSV files.

    I can extend it with further functions if you  reach out.,

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at

    Hi, here's a simple example of updating from OneDrive using standard power automate actions.

    https://yzhums.com/33436/

    I think you can add new custom execute actions to do it.

    https://yzhums.com/20111/

    Another solution, you can consider using Graph API.

    https://www.msnjournals.com/post/how-to-use-microsoft-graph-api-in-business-central

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    The issue with using OneDrive in many of these scenarios is that a OneDrive is owned by a specific user, so if that user is leaving the company the OneDrive integration will stop working when the user account is deactivated.

    That is why i recommend Azure Blob storage over OneDrive when possible.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,812 Moderator on at

    You can check this link for blob storage, hope it will help you.

    www.navwithnav.com/.../

  • neckit Profile Picture
    neckit 144 on at

    First of all, thank you for the helpful feedback!

    You primarily use the Azure Blob starage. But we would like to use the Azure File Shares, because we can also use the synchronization with a local file server directory.

    We're not quite ready to set this up in Azure yet, but do you also have some examples of how to use Azure file shares via AL code? That would be awesome :-)

    greeting

    Ralf

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    I do not have any code samples for Azure fileshares.

    But I see that Stefano have have created some samples around this where he is using a Azure function to communicate from Business Central to the Azure file share.

    Maybe that can be helpful for you?

    demiliani.com/.../

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,812 Moderator on at

    Unfortunately I dont have that code available with me apart from the Azure blob storage.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at

    Hi, hope the following helps.

    https://www.linkedin.com/pulse/business-central-azure-blob-storage-bert-verbeek/

    Thanks.

    ZHU

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,691 Super User 2026 Season 1

#2
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,095 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,069 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans