SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Scenario: I have a group of users; each has a private document library (named with their userid). When a person updates a list item I need to put copy of the item into their library (using a codeless solution).

Is there anyway to 'trick' the workflow designer into letting me do something like the following:

  • var destinationURL = "http://blah/site/" + CurrentItem["UserID"]
  • ACTION: Copy item in Current Item to destinationURL

The only apparent way to do this is to make an if statement for each person and manually select their library. I really want to avoid that for 60 people. Any suggestions?

I looked into using a drop off library w/ content organizer rules but it looks like I'd still have to have 1 rule per person.

share|improve this question

in your work flow you'll want to do something like if (modified by or created by == UserID) then (copy this item to destination)

share|improve this answer
Correct, but that's what i want to avoid b/c this strategy requires writing 1 if/statement + action for each user/destination. There are 60 users. That's why I'm looking for a way to dynamically set the destination. – Chris M. Jan 26 '12 at 16:36

You can use a workflow lookup to get properties of the item that triggered the workflow. Can you get the "Modified By" property of the Current Item with the lookup and use that to build the URL?

share|improve this answer
I can but the question is -- what then? The "Copy List Item" action makes you pick the destination in advance rather than dynamically at run time. Is there a way to teak this action or an alternate one that's more flexible? – Chris M. Jan 26 '12 at 16:37
AFAIK you have two options: implement custom workflow action to which you can give the destination URL dynamically, or implement custom event handler. I would almost say event handler is more straightforward, but it of course depends on which one you have more experience of. – Jussi Palo Jan 26 '12 at 20:57
Thanks, that sounds like the way to go – Chris M. Jan 27 '12 at 16:54

If you allow me, this is an unusual request. The benefit of a tool like SharePoint is to share and avoid duplicates, and you are going in the exact opposite direction.

With a SharePoint Designer workflow, you can't set the target list dynamically.

The closest I can think of is e-mail enabled lists. Maybe you could enable incoming e-mail on each target list, then use the workflow to build the list e-mail address dynamically and send the e-mail. [disclaimer: not tested, I am not sure if workflows accept a dynamic string in the e-mail "to" field]

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.