Workflow Use Case
Updating Approver for a Change Request
Description
This workflow retrieves Approvers from each item of the ‘Change Requests Approval Tasks‘ list and updates all the approvers into a multi-user field (Approver) in the ‘Change Requests’ list.
Workflow
First, create a workflow on the ‘Change Requests’ list Item creation event.
Action Settings:
Action 1: GetAllApproverItems (Query List Action)
Add a ‘Query List’ Action to get items from the ‘Change Requests Approval Tasks’ list as shown below:
For more information about the Query List Action go to Query List.
Action 2 : Update Approvers in Change Requests (Update Item Action)
Add an ‘Update Item’ action to update the ‘Approver’ field with all approvers using ‘$variablecollection’ function as shown in the picture below.
'Approver' Column Mapping with expression builder:
Syntax for 'Approver' column mapping without expression builder: GetAllApproverItems##$variablecollection(;#,[Assigned To|AssignedTo])
Online and Onprem syntax for Variable Collection function without expression builder:
SharePoint Online: $variablecollection(separator,[ColumnDisplayName|ColumnInternalName])
SharePoint On-Premises: $variablecollection([ColumnDisplayName|ColumnInternalName],separator)