locked
SharePoint Online Workflow Reporting RRS feed

  • Question

  • Hi All, 

    We have a customer requirements and they want have following requirements:

    1. Workflow Reporting: They want to see how many workflows are pending, approved overdue report for approver with status etc. can be viewed from the management perspective in SharePoint. They also want to export those report in Excel within SharePoint. 
    2. Save this saves excel report within SharePoint Online Audit purposes.
      Q: What reporting could I use to generate these reports?
      Q: Collate all the workflow history (https://contoso.sharepoint.com/sites/IT/Lists/Workflow%20History)  and display within an app?

      Found a blogpost which shows Workflow Status as PowerShell Script http://spmavericks.com/2014/11/01/sharepoint-online-o365-powershell-script-get-workflow-status/

    Any sample code / suggestions would be highly appreciated.  


    Sandy

    Wednesday, January 11, 2017 5:48 AM

Answers

  • Hi Sandy,

    Seems no OOTB way at this moment.

    Since you have got the script about gathering all the workflow status, a thought is that, you can then save the results as items into a SharePoint list using PowerShell, then you can use the OOTB feature “Export to Excel” to get the report you request.

    Best regards,

    Patrick

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

    • Proposed as answer by Patrick_Liang Monday, January 23, 2017 12:32 AM
    • Marked as answer by Sandy 791 Monday, January 23, 2017 3:18 AM
    Thursday, January 12, 2017 3:02 AM

All replies

  • Hi all, 

    I found a blog that dicusses reporting for SharePoint Online

    need to find more details!


    Sandy

    Wednesday, January 11, 2017 7:01 AM
  • Hi Sandy,

    Seems no OOTB way at this moment.

    Since you have got the script about gathering all the workflow status, a thought is that, you can then save the results as items into a SharePoint list using PowerShell, then you can use the OOTB feature “Export to Excel” to get the report you request.

    Best regards,

    Patrick

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

    • Proposed as answer by Patrick_Liang Monday, January 23, 2017 12:32 AM
    • Marked as answer by Sandy 791 Monday, January 23, 2017 3:18 AM
    Thursday, January 12, 2017 3:02 AM