Is there a way to automatically add the name of the parent folder to a column in which the documents are stored?

I have a SharePoint 2010 Foundation environment with a document library named IT. In this IT document library, I have several folders containing procedures and howto's. Separate permissions have been configured on the folders.

-Windows 7
-- Users
-- Administrators
- Windows 8
-- Users
-- Administrators
- Windows XP
-- Users
-- Administrators

IT: All documents IT: Windows 7

Users access the document library using a view where the option "show items without folders" has been enabled. Because of the permissions, they don't see folders they don't have access to.

I tried making a workflow with one step that starts automatically when an item is created or changed:

"Set Parent Folder to Current Item:Path" Workflow step

When the workflow is done, the path is shown as "/IT/Windows 7/Administrators". But I only need the last part "Administrators" instead of the entire path:


How can I get only the last folder name from the path?

1 Answer 1


Lectori salutem,

I solved this question by installing a third party addon "Advanced Workflow Actions for SharePoint Designer 2010" by iLove SharePoint

URL: http://ilovesharepoint.codeplex.com/wikipage?title=Get%20Parent%20Folder%20Action

This addon adds extra actions for workflows in SharePoint Designer.

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.