1

I am creating a dashboard with share Point online list. I want to show number of task created by each person. But, the report is showing numbers (Author ID) How do I change to names?

Improve this question

2 Answers 2

Reset to default
0

Here is the detail level steps.

Step-1: Connect to the SharePoint List.

Step-2: Click on "Edit Queries"

Step-3: Click "Choose Columns"

Step-4: Choose your columns and "Author"

enter image description here

Step-5: Click on symbol given as shown in the image

enter image description here

Step-6: Choose the column "Title"

enter image description here

And now you will have your name.

enter image description here

Let me know if you need any additional details.

Improve this answer
3
  • 1
    Thanks It worked!
    – Bhuvana Sundar
    Sep 15, 2019 at 8:53
  • But we couldnt get assigned to ID like this?
    – Bhuvana Sundar
    Sep 20, 2019 at 15:36
  • you should check other properties available in the checklist box. You will get the name of the property that you are getting
    – Aakash Maurya
    Sep 25, 2019 at 10:36
0

I have a question on this. Once it has run and I have the name. How do I save it. I don't see that column in my original excel. Do I have to do a save as?

Improve this answer
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.