I have have a requirement to send an csv file generated from within Business Central to an SFTP site.
I want to send it to Power Automate, and have Power Automate send that csv onto the SFTP site in one go, without saving the csv file first in a storage blob or Sharepoint site.
Yes, this can be achieved, but not exactly in the way described.
Power Automate cannot send a file to SFTP without receiving file content first. However, you do not need to store the file in SharePoint.
The recommended approach would be:
Generate the CSV file in Business Central using AL.
Convert the file stream to Base64.
Send the Base64 content to Power Automate via an HTTP-triggered flow.
In Power Automate, convert the Base64 string back to binary using base64ToBinary().
Use the SFTP “Create File” action to upload it directly.
This way, the file is handled entirely in memory within the flow and is not stored in any intermediate location.
Standard Business Central Power Automate triggers do not support directly passing file streams.
Was this reply helpful?YesNo
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.
63
Share
Report
All responses (
Answers (
