Applies to: SharePoint Online and On-Premises

Description

This article describes the steps to configure a workflow to auto close Ticket when all the associated tasks are completed for that Ticket.

Configuration

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 changed: afterchange:Completed

Action 1:

Create query list action using Query builder to check if all the associated tasks are completed for the Ticket as shown below.

Syntax: %%[Column Display Name|Column Internal Name]%%

Example: %%[Related Ticket ID|RelatedTicketID]%%

Action 2:

Create an update item action to close the Related Ticket as shown below.