Small and medium business | Business Central, N...

How to auto schedule to export data & import data from configuration package

(0) Share

Report

Posted on by Manish Ratan

425

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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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.

www.youtube.com/watch

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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.

https://yzhums.com/33436/

Thanks.

ZHU

Was this reply helpful? Yes No
Manish Ratan 425 on at

Like (0)

Report

Thanks for the reply.

Was this reply helpful? Yes No
Manish Ratan 425 on at

Like (0)

Report

Thanks for the reply

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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,

Was this reply helpful? Yes No