Workflow Use Case
Updating Approvers for a Change Request
Description
This workflow retrieves Approvers from each item of the ‘Approval Tasks‘ list and updates all the approvers into a single multi-user field(Approvers) in the ‘Change Requests’ list.
Workflow
First, create a workflow on the ‘Change Requests’ list Item Modified event.
Action 1
Add a ‘Query List’ Action to get items from the ‘Approval Tasks’ list.
Query:
O365
<View><Query><Where><Eq><FieldRef Name=’CR’ LookupId=’True’ /><Value Type=’Lookup’>##CR##</Value></Eq></Where></Query></View>
For more information about the Query List Action go to Query List.
Action 2
Add an ‘Update Item’ action to update the ‘Approvers’ field with all approvers using ‘$variablecollection’ function as shown in the picture below.
