Forum Discussion

--ak--'s avatar
--ak--
Regular Visitor
4 years ago

SharePoint Workflow Reporting

Hello,   Could i get some help  I've imported data from a SharePoint list which incorporates a workflow. I am trying to create a report where i can monitor the status of items within the list. Sev...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
--ak--'s avatar
--ak--
Regular Visitor
4 years ago

thank you for the response!

 

the source data is a sharepoint list... the actual value is the current workflow status which has many values depending on the item status such as "manager approved, booking approved, booking declined" etc

 

i had a similar issue when trying to see which manager approved each list item but this solved by pulling the site o-data and linking tables

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

--ak-- 

 

What I am asking is the data of the first step when importing data, whether it is displayed correctly? Can you show me a screenshot?

 

  • --ak--'s avatar
    --ak--
    Regular Visitor
    4 years ago

    hello,

     

    here is a screenshot..i've had to redact some sensitive information but i am after the booking table, shown below

     

     

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      --ak--  Which column is the one you described first? id?

       

      • --ak--'s avatar
        --ak--
        Regular Visitor
        4 years ago

        no so that is showing all the tables in the sharepoint site...when i go into the booking table the column i shows a mixture of null values and numbers(15,16,17,18 etc)- these represent the workflow status but im not sure how to change the numbers into "manager approved, manager declined" etc