Hello Everyone,
How to auto schedule to export data & import data from configuration package in Business Central SaaS Version. Please advice if how can we do it through Power Automate. Or please advise me with best other solutions.
Thanks.
One way could be to create a report with an excel layout that you use to export the data to excel format.
Then you can run that report in a job schedule and have your report output stored to a Azure blob storage,
Thanks for the reply
Thanks for the reply.
As far as I know, the configuration package does not have standard APIs, and it cannot be directly associated with Power Automate.
But as Nitin mentioned, there are many solutions, but all of them require BC to have APIs or Web Service.
Below is a very simple example of integration with OneDrive, I hope it can give you some hints.
Thanks.
ZHU
Hi,
You can create the Power Automate to import Data from SharePoint, Azure or OndDrive, Read those data and insert directly to Business central.
Below is the video which let your how to access azure blob storage in powerAutomate.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156