I have a SharePoint site with two lists:

  • list of assets
  • list of maintenance tasks: each task is linked to an asset via a lookup column. Each asset has one or more related maintenance tasks

My need: when an asset is updated, this impacts the related tasks. I want to trigger a workflow to update these tasks.

In SP 2007/2010 this is extremely difficult as a workflow can only look up one list item at a time.

Has this been improved in SP 2013, and is there a straightforward way in a workflow to select and update multiple list items?

I am open to other solutions besides workflows (although I don't see what else could trigger an automatic update). My question is specifically about out of the box functionalities, not custom development.

  • Can you include what column you want to change? Maybe it is something that can be implemented as a look-up? – Ryan Erickson Apr 1 '13 at 17:41
  • @RyanErickson it's not a simple lookup, my scenario involves calculations to determine the maintenance due date based on the asset characteristics (mileage for example). – Christophe Apr 1 '13 at 17:46
  • An event receiver is something you can rely on that will get this to work. I know you don't want to use custom code, but I think this is a route you should pursue. – iOnline247 Apr 2 '13 at 1:46
  • @iOnline247 I need this for hosted environments (Office 365 or multi-tenant) – Christophe Apr 2 '13 at 4:02
  • Event Receivers work in Sandbox, which would include O365. I had a contract recently where I had to deploy some to certain lists. I documented the options that are available to you: mattbramer.blogspot.com/2012/11/… – iOnline247 Apr 2 '13 at 4:07

The SP 2013 workflows have the same restriction that they can only update one list item at a time.

Although I have not tried this you may be able to use the new looping features to get this done.

Here is a blog example of how to use looping

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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