web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Workflow to automatica...
Microsoft Dynamics CRM (Archived)

Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

(0) ShareShare
ReportReport
Posted on by JohnM1 19

Hi

I need to send a list of data to colleagues each week from our CRM.

I want to automate the process instead of me having to run the Advanced Find, Export to Excel, and then save and send the file to a list of colleagues.

Is there a Workflow (or perhaps a MS Flow) that can be used to automate/schedule the 'Export to Excel' function in CRM for a selected Advanced Find, that then saves the excel file to either SharePoint Online or OneDrive, and then finally to email the saved file to a list.

Would appreciate if someone could describe how to set this up.

(fyi: I'm not a Workflow expert although I'm comfortable with navigating the 365 Processes/workflow area).

Regards

John

*This post is locked for comments

I have the same question (0)
  • Elijah Stownton Profile Picture
    Elijah Stownton 192 on at
    RE: Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

    You can try Skyvia Data Integration to schedule the export to CSV from Dynamics 365. it is a no-code freemium platform.

  • Suggested answer
    Harshil Shah Profile Picture
    Harshil Shah 294 on at
    RE: Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

    Hello John,

    I understand your requirement is to Get Some advanced find data to Excel file and store it in Sharepoint or on OneDrive. Well I don't think you can achieve this via Workflow Only.

    You need to create custom workflow code which will trigger every week and write some Code logic using fetchXML to retrive data using CRM Service. Check below link

    docs.microsoft.com/.../use-fetchxml-construct-query

    After you get data in C# code you can create excel file and upload it on Sharepoint or OneDrive via Code.

    Check below URL to achieve that.

    docs.microsoft.com/.../gg309548(v=crm.8)

    www.inogic.com/.../

    community.dynamics.com/.../upload-documents-to-sharepoint-in-plugin

    Regards,

    Harshil Shah

  • sai123456 Profile Picture
    sai123456 324 on at
    RE: Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

    I guess CRM doesn't support this out of the box. But you can create a custom workflow to trigger on your requirement and use below link for saving the file.

    Saving File:

    social.microsoft.com/.../export-crm-data-to-excell-using-c

    Sending Email:

    www.emailarchitect.net/.../14.aspx

  • JohnM1 Profile Picture
    JohnM1 19 on at
    RE: Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

    Hi - I'm not a coder unfortunately, so I'm not sure this is something I can do/figure out. But thanks for the option. I'll look into it further if I get no other answers.

  • chikhaleankush Profile Picture
    chikhaleankush 547 on at
    RE: Workflow to automatically 'Export to Excel' an Advanced Find each week + save to Sharepoint + email to list

    I am not aware of way exporting to excel automatically. If there is a way maybe someone can shed light on it.
    But can I suggest one another way, which I have used in mulitple of my projects.

    • Create SSRS report for you advanced find ( I belive you have almost save column to export)
    • Once you have this ssrs report you can automate process of downloading this SSRS report as Excel file
    • Once you Render (generate) automatically SSRS report and save(download) it as Excel
    • You can send this Excel Report as Email to users.

    All these steps can be automated and scheduled weekly, But you need some coding for this.

    How will I schedule this?

    • I will create a flow
    • This flow will run schedules as you wish
    • This flow will call a workflow/Action
    • In background this action will have plugin (c#) logic which will generate report.
    • Now you can either save this report as Notes to a particualr entity or direclty send a Email.

    There are some online code available to achieve this.

    Here is one perfect link match for you 
    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/361435/download-whichever-ssrs-report-from-the-report-server-in-crm-dynamics-c-and-javascript---pdf-and-docx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans