How to show Who approved this project in a report using text mode

[TaraPearl11]

I am trying to create a report showing who actually approved a project, so we can track if and when someone edits the approval process on a template to add a different approver.

I can get the correct user ID number to show but using regular text mode edits to change that to the username is proving fruitless. Below is my original text which returns the user ID number. Changing ID to :name is not working; it returns a blank value in that column. Thanks in advance for any help you can provide.  

displayname=Approved By
linkedname=approvalProcess
namekey=view.relatedcolumn
namekeyargkey.0=approvalProcess
namekeyargkey.1=enteredByID
querysort=approvalProcess:enteredByID
textmode=true
tile.name=component-approvalprocess-field
valuefield=approvalProcess:enteredByID
valueformat=HTML
viewalias=approvalProcess:enteredByID

[VictoriaLinn]

Is it a project report? If so, what about using the Project > Approvers and Status column instead. This way you can see all approvers added and the status. Maybe I'm reading your approach incorrectly.

[TaraPearl11]

Not quite. I need to show who actually clicked the green checkmark to approve the project. I can get the user ID but need to see the user name instead. The standard tricks to change ID to name are not working. Thanks though. 

[KellieGWAB · Accepted solution]

Hi @TaraPearl11 - this is what I use

displayname=Approved By
listdelimiter=<br>
listmethod=nested(approverStatuses).lists
textmode=true
type=iterate
valueexpression=CONCAT({approvedBy}.{name}, " ")
valueformat=HTML

[TaraPearl11]

@KellieGWAB This worked. Thank you so much! 

[Sarah_N]

I know this is an old post, but is there a way to add a date to this list as well? 

For example:

John Smith, 02/02/2024