Send notification when change is in state "Review" and all change task are closed

[JohnDF]

Hi everyone,

I have a requirement to send an notification when the change is in state review an all associated change task are in status closed.

How would a achieve this requirement? I created a notification with a condition triggered when inserted or updated with state in "Review" but how can I check that the change task are closed and after that send the notification?

Any help would be nice.

[Mike_R · Accepted solution]

This could be a little tricky. I would leverage flow designer for this.

Trigger condition would be change state changes to review.

Then put a look up records step to lookup all related change tasks.

The a for each loop to

Wait for each change task to close (use a wait condition)

After that, have a step to generate an event, which with trigger an email. (Or you can use the email step native to flow designer)