Auto Generate Email Reports from SharePoint Online List


  • Hello,

    I have a sample list from which i want to send email weekly with status report(PDF/Excel) with charts . I wanted to know if it is possible in SPO and if yes please share some reference article links .

    Sample list looks like:

    Task Name Complexity Status
    Task 1 Simple Completed
    Task 2 Medium Completed
    Task 3 Complex In-Progress
    Task 4 Complex In-Progress
    Task 5 Medium Completed

    • Edited by Kodnil Friday, February 10, 2017 12:52 PM
    Friday, February 10, 2017 9:06 AM

All replies

  • Hi Kodnil,

    I don't think that this is an easy thing to be achieved.

    The method I could think of is to loop through all list items and then set variable to the values of the column, then insert the variable to the content of the email using workflow.

    Then create retention policy to start the workflow every week repeatedly.

    Best Regards,

    Lisa Chen

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Monday, February 13, 2017 10:04 AM
  • Please share some sample links. I only have option of using JS code.
    Wednesday, February 22, 2017 6:35 AM