Scheduling Dynamics 365 Business Central Reports to SharePoint Using Power Automate and Job Queue Automation

In many organizations using Microsoft Dynamics 365 Business Central, not all users can be granted licenses due to privacy requirements, licensing costs, or role-based access restrictions. As a result, organizations need a scalable and secure way to distribute Business Central reports automatically without providing direct system access.

Scheduling Dynamics 365 Business Central reports automatically and exporting them to SharePoint enables organizations to automate ERP reporting and securely distribute business data across teams. This approach uses Business Central job queue automation, API integration, and Microsoft Power Automate workflows to generate reports and store them in SharePoint on a recurring schedule.

For organizations looking to implement advanced automation, integration, and reporting solutions, working with experienced Business Central consultants can help design scalable reporting workflows and automation architectures.

Storing Business Central reports in SharePoint automatically ensures centralized access, improves reporting efficiency, and eliminates manual report generation tasks. In this guide, we demonstrate how to automate Business Central report scheduling and export reports to SharePoint using Power Automate, custom API pages, and job queue automation.

SharePoint is a powerful collaboration platform that helps teams work together more efficiently. It provides a central place to store, organize, and share information securely. With SharePoint, users can collaborate on documents, manage content, and automate everyday processes. It seamlessly integrates with Microsoft 365, making teamwork more connected and productive.

SharePoint serves as a centralized document management system for ERP report storage, enabling organizations to automate report distribution and maintain a secure, searchable, and structured repository. Integrating Business Central with SharePoint using Power Automate enables automatic file creation, secure report storage, and seamless access to ERP reports across Microsoft 365.

We will use the Business Central Job Queue to schedule reports automatically, enabling ERP reporting automation without manual intervention. Business Central job queue scheduling allows reports to run in the background based on defined recurrence formulas such as daily, weekly, or monthly execution.

The ‘Report Output Type’ option allows exporting reports in multiple formats including PDF, Excel, and Word, enabling flexible report distribution and automated Business Central report delivery.

We need to work on Business Central in configuring/ setting up several things for the same. In this document, we will be creating a recurring job queue which will run a report in Business Central. We can configure the file type of the Report with the ‘Report Output Type’ option with PDF, Word, Excel options. Also, the recurring period can be configured in the ‘Recurrence’ section. Here we’ve used ‘1D’ as ‘Next Run Date Formula’ so that the report will be run every day.

Also, we need to expose the ‘Report Inbox’ table to API with the help of a custom API page via AL, which will eventually expose the Report data we need through an API. We will be retrieving this exposed data with a Power Automate connector and transferring it to SharePoint folder.

To enable integration with external systems, Business Central allows developers to expose report data using custom API pages created with AL. This Business Central API integration enables Power Automate to retrieve report data automatically and trigger downstream automation workflows such as exporting reports to SharePoint or distributing reports via email. This approach represents a scalable ERP automation architecture using Microsoft Power Platform and Business Central APIs.

In Power Automate, we create an automated workflow using the Dynamics 365 Business Central premium connector. The trigger “When a record is created” detects newly generated reports in the Business Central Report Inbox table. This event-driven automation ensures reports are processed and exported automatically without manual intervention.

Power Automate enables seamless integration between Business Central and SharePoint, allowing organizations to automate report export, create files automatically, and distribute ERP reports securely across teams.

If it is Reports Inbox record of the report which we confirm, we will be creating a file in SharePoint with the help of ‘Create file’ standard connector by SharePoint. This automated workflow represents a powerful Business Central report automation solution using Microsoft Power Automate and SharePoint integration. It eliminates manual report downloads, reduces operational overhead, and ensures consistent report availability in SharePoint document libraries.

Once the Business Central job queue, API integration, and Power Automate workflow have been configured, reports are generated automatically based on the defined schedule. Power Automate retrieves the report data via Business Central APIs and creates files in SharePoint automatically. This enables fully automated ERP report generation, storage, and distribution using Microsoft Power Platform and SharePoint integration.

Scheduling Dynamics 365 Business Central reports and exporting them automatically to SharePoint provides a scalable and secure ERP reporting automation solution. By leveraging Business Central job queue scheduling, API integration, and Microsoft Power Automate workflows, organizations can automate report generation and distribution without requiring additional Business Central licenses.

This integration between Business Central and SharePoint improves operational efficiency, enhances data accessibility, and ensures secure report storage within Microsoft 365. Automated report distribution using Power Automate and SharePoint represents a best-practice approach for Business Central reporting automation, enabling organizations to streamline reporting processes and improve decision-making.