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.