I have two lists in Sharepoint 2010 that have a 1:1 relationship. When a user creates an entry in the first list (call it "Requests"), this triggers a workflow that creates a corresponding entry in a "Reviews" list. The Reviews list as a "ReqID" column, so each Review has a pointer to the Request item it relates to.
The first part is working ok. Each time a Request is added, a workflow creates a Review and sets some fields in the Review appropriately.
Now, what I need to do is have a workflow on the second list such that-
- When the Review is updated and the Review status is "Closed"
- Copies the value of the "Review Outome" field from the Review to equivalent field in the Request identified by the "ReqID" field.
Is there a way to do this? Once the second list item is created it seems to be cut adrift. Even though I have an ID to join the two lists, there don't seem to be any "update List item by Listname.ItemID" actions available.
Note I don't have code access to the server, I think workflow actions are my only option.