Email Notification for Timesheet

[user0719]

Does anyone know how the following can be achieved?

1. Time Sheet Due --> Notification needs to be sent on Fridays to remind users to complete and submit the current timesheet by the end of the time sheet period.
2. Time Sheet Overdue --> Notification needs to be sent on Mondays to users who have not submitted a timesheet for the previous period; a notification is also need to be sent to the manager with a list of Time Sheets pending submission User.

[user0719]

Thank you @Sandeep Rajput! Is there also a way to check if timesheet users have not submitted their time card and trigger reminder notification this way?

[Sandeep Rajput]

@user0719 Using a Lookup records action and querying the time card table within the flow you can determine which users have submitted the timesheet. Accordingly you can send emails to the users who didn't fill the timesheet.

For more information on Look up record action please refer to https://docs.servicenow.com/bundle/xanadu-build-workflows/page/administer/flow-designer/reference/lo...

[user0719]

@Sandeep Rajput Would I query users who have not filled the timesheet this way? (see screenshot)

Or what is your recommended approach?