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?

2 Answers 2


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.

  • 1
    Thanks It worked! Commented Sep 15, 2019 at 8:53
  • But we couldnt get assigned to ID like this? Commented 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 Commented Sep 25, 2019 at 10:36

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?

  • If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review Commented Dec 15, 2022 at 2:28

Your Answer

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

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