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
Hi, hope the following helps.
https://www.linkedin.com/pulse/business-central-azure-blob-storage-bert-verbeek/
Thanks.
ZHU
Unfortunately I dont have that code available with me apart from the Azure blob storage.
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?
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
You can check this link for blob storage, hope it will help you.
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.
Hi, here's a simple example of updating from OneDrive using standard power automate actions.
I think you can add new custom execute actions to do it.
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
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.,
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
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.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
