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
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

 

 

 

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

    Hi, --ak-- 

     

    For the information you have provided now, all I can say is that if you can't modify the wrong data before you get it, then it can't be recovered. 

    If the mixture of null values and numbers(15,16,17,18 etc) corresponds to the original data form, then you can modify it by customizing the column.

    Like this:

    PQ:

     

    if [column]= 15,"manager approved",else if [column]=16,"manager declined", else if ...else ...

     

     DAX:

     

    if ([column]= 15,"manager approved", if ([column]=16,"manager declined", if(...)))

     

     


    Best Regards,
    Community Support Team _ Janey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

      thank you- i'll give this a go!