Hi,

I have created a workflow that takes the document from one folder to another folder.  In the destination folder, I want to update a column in the template to contain the folder name and then rename the document to include the folder name as part of the document name.

For example:  The document (eg document name is Sample) resides on New Documents\Student Documents\Exam Board Documents folder.

I want workflow to update a field (eg Document Type) in the template of the document to contain Exam Board Documents

I want to rename the document from Sample to Exam Board Documents - Last Name, First Name

I have query in the workflow to retrieve the Last Name and First Name.  My problem is that I don't know how to retrieve the folder name where the document resides.  I don't want the full folder name to be part of the document name in the destination area,therefore, I cannot use Entry Path.

It is also possible for the document to reside further down in the file path, eg.  New Documents\Student Documents\Exam Board Documents\Exam Board.  Therefore, I want to get the last folder name in the filepath where I find the document.

Is this possible?

Thanks,

Teng