Automate send email of report generated as excel attachment with sharepoint in Dynamics 365 CRM
Send Automated Reports to Each User with customized excel template as Attachment Dynamics 365 is a exceptionally amazing framework which enables Sales, Field Service, Customer Service and Marketing teams to perform huge number of functions to facilitate the business. Dynamics 365 has introduced new feature to schedule an automated report via "Run Report" wizard on each entity. But still there are few limitations. To overcome, all these limitations we need to setup the custom solution. In this blog, we will demonstrate you the customize way to automatically send report as email with excel attachment. Here are few features which will be included, We can schedule a flow as per our need i.e. weekly, monthly, daily etc. Send Excel Attachment with Custom Excel Template Send email to Each user as per their access to records - we will only send the records in sheet where the specific user has access. Store specific template files in SharePoint for future reference. Now, using an