Scheduling Reports in Microsoft Dynamics 365

Please note, this tool is no longer in use and updates will not be made to it. Please contact us if you have any questions. 

Microsoft Dynamics 365 comes with several powerful reporting features. It includes a set of out-of-the-box reports that provide useful business information, and it also allows users to create reports using Report Wizard and the authoring tool.

But for Dynamics 365 (Online), one of the highly sought-after features is the ability to schedule the delivery of reports. Thanks to the extensibility of the CRM platform and the contribution from the CRM community, this is now possible by using MS Flow and a custom solution. In this blog, I am going to share my experience in achieving report scheduling for one of Encore’s customers.

The client has one report with users as a parameter. By selecting a user, the report displays the associated records. The requirement is to schedule an email of this report to the list of users.

Follow these steps to achieve this:

  • Install and configure the Report Scheduler solution, this requires configuration on both Dynamics 365 and MS Flow. This will create a custom Flow action; Render Report.
  • In MS Flow, configure a monthly scheduled trigger to retrieve the list of users who will receive the report in an email. With each of the retrieved users being passed as a parameter into the report, the report is rendered into PDF using the custom Flow action.
  • The final step is to compose an email with the generated PDF as an attachment (Alternative option; you can compose the report content in an email body).

Figure 1. Flow configuration for report scheduling:

Figure 2. Sent email with report attached, and content composed in the email body:

If you have any questions about scheduling reports in Dynamics 365, please connect with us.

Dynamics 365 CRM How-To eGuide

41 pages of step-by-step instructions for 6 different key tasks in Dynamics 365 CRM apps. Includes interactions with Power Apps and Power Automate!

Get eGuide

Dynamics 365 CRM How-To eGuide

Get eGuide