How could I send email notifications for overdue status reports?

ben119
Tera Contributor

Hi,

Use case is that we want an email to be sent out weekly that displays a list of projects that have not had a status report created within the last 7 days.

I have been playing around in Flow Designer and so far have the following flow:

ben119_0-1712886341788.png

This flow successfully identifies status reports that HAVE been created in the last 7 days and displays the count in an email. This however, is too basic and I was wondering if it would be possible to do the inverse and find projects that HAVE NOT had a status report created in the last 7 days and also display the names of each project in a list within an email - preferably with little to no scripting if possible. Thanks a lot for any help that can be provided!

0 REPLIES 0