Is it possible to access a list in a different (sub) site in a Workflow Activity using SPD?

Question

I have the following SharePoint 2010 site structure:

• Root (SiteCollection)
  • Queue (List)
  • Subsite (Site)
    • Target (List)

I'm using the custom SPD activities from iLoveSharePoint to create a site based on a template in the "Subsite" whenever an item is created in the "Queue". This works fine, however, now i need to create a new list item in the "Target" list aswell.

Since the workflow is running on the "Queue" list, it seems that I cannot access the "Target" list because it's in a different (sub) site.

Any ideas how I can resolve this issue?

Answer 1

I agree with Kit that your question in the same as the one he references from stackoverflow, but I'll throw out an idea that wasn't offered for that question.

iLoveSharePoint includes a custom activity for executing a PowerShell script...it's certainly feasible to leverage that to do just about anything you can do with custom code...i.e. use that instead of building a custom SPD activity as the answer to the stackoverflow question suggests.

For reference: http://ilovesharepoint.codeplex.com/wikipage?title=Execute%20PowerShell%20Script%20Action&referringTitle=Workflow%20Actions%20for%20SharePoint%20Designer%202010