change Record column to Display Name

[ppl]

Hello.

How I can change Record value in my column Author to Display Name in my report?

This is what I see in Transform data window

And I need Full Name of an author column in my SharePoint list.

[PhilipTreacy · Accepted solution]

Hi @ppl 

I'm not entirely clear on what you need, what do you mean by Full Name ? But I think you want to get the Title from the Record in the column?

If so, add a custom column and enter this in the dialog box

= try [Author][title] otherwise null

 Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.