Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
--ak--
Regular Visitor

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. Several fields i want to show are showing as ID's...please see image below.. So instead of showing the actual values in the sharepoint list Power BI is showing numbers...how can i get it to display the actual value?

ak_0-1650978761133.png

Any help would be appreciated.

 

Thanks in advance

8 REPLIES 8
--ak--
Regular Visitor

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

@--ak-- 

 

vjaneygmsft_0-1651214624583.png

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?

 

hello,

 

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

 

ak_0-1651215586265.png

 

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

 

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

ak_0-1651216635790.png

 

 

 

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.

thank you- i'll give this a go!

v-janeyg-msft
Community Support
Community Support

Hi, @--ak-- 

 

What's the source data you obtained in the power query? And what's the actual value?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.