I have created a custom approval workflow. A document is uploaded to an "Unapproved document" library. If and when the document is approved, it is automatically moved to another document library ((Approved Documents). For audit requirements, I need to be able to show the name of the person who approved each document, in the "approved documents" library.

So far, I have created a variable (approver name)within my "collect data from user" workflow step, . I know this is being populated as it appears correctly against the task in the task list.

I have created a new column in the "approved documents" library, using "look up from data already on this site", and chosen "approver name" from tasks. However, this does not show any information.

Is what I am trying to do even possible???