Applies to: SharePoint Online and On-Premises
This article describes the steps to configure a workflow to auto close Ticket when all the associated tasks are completed for that Ticket.
Configure a workflow on Associated Tasks list on Item modified event as shown below.
Please note the condition on ‘Task Status’ column value and put the exact value so that workflow is triggered only when status of a task is getting chnaged: afterchange:Completed
Create query list action to check if all the associated tasks are completed for the Ticket.
<FieldRef Name='RelatedTicketID' LookupId='TRUE'/>
<FieldRef Name='Status' />
Screenshot of Query list action:
Create an update item action to close the Ticket