I want to send approval reminder for RITMs for a particular catalog item

[MohammedYaseen]

Hi Team,

I want to send approval reminder for particular catalog item on the 10th,11th,12th and 13th of the month

Can we achieve this using flow designer?

Thanks,

Yaseen

[Ankur Bawiskar · Accepted solution]

@MohammedYaseen 

yes it's possible.

check this and enhance for your requirement

Approval Reminder Using Flow Designer 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Aniket Chavan · Accepted solution]

Hello @MohammedYaseen ,

Yes, it's definitely possible!

You can create a Scheduled Flow that runs daily at 12 AM, and then control the logic so it proceeds only on the 10th, 11th, 12th, and 13th of the month.

Here's how I tested it in my instance:

• I created a flow variable of type True/False called Reminder Day.

• In the very first step, I used "Set Flow Variable" and added a script to check if the current day is one of the 10th, 11th, 12th, or 13th. If yes, it returns true, else false.

• var gdt = new GlideDateTime();
  var today = parseInt(gdt.getDayOfMonthLocalTime());
  
  if (today === 10 || today === 11 || today === 12 || today === 13) {
      return true;
  }
  return false;

• Then I added an If condition to check if Reminder Dayis true. If it’s false, the flow stops there.

• If true, the flow continues — I used a Lookup Records action on the sysapproval_approver table.

  • Condition 1: state is requested

  • Condition 2: dot-walked to Approval for-> request_item -> cat_item and selected the specific catalog item name I wanted to target (you can adjust this as needed).

• After that, I used a For Each loop on those lookup records we did and directly added a Send Email action inside it — since all necessary checks were already done before this point.

It worked exactly as you described — sending reminders only for the right dates and the right catalog item approvals.

Let me know if you get stuck anywhere, happy to help further!

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Regards,
Aniket

[Ankur Bawiskar · Accepted solution]

@MohammedYaseen 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MohammedYaseen]

Thank you Aniket for sharing . We can get the condition working.

Is there a way we can use a specific schedule (Geography based) where it triggers excluding Weekends and holidays. 

For eg.,  for July 2025, 10th working day is 14th July, excluding weekends and no holidays.

[Aniket Chavan · Accepted solution]

Hello @MohammedYaseen ,

This can be handled by customizing your schedule and script logic a bit more.

1] Set up a custom holiday-aware schedule:

• Go to System Scheduler > Schedules and create a new schedule (e.g., India Business Days)

• Set working hours (Mon–Fri)

• Under the Child Schedules related list, link your Holiday Schedule with Include type & This way, holidays are excluded.

2] Update the Flow Designer script:

var schedule = new GlideSchedule('your_schedule_sys_id'); // Replace with your custom schedule’s sys_id
var gdt = new GlideDateTime();
var start = new GlideDateTime(gdt.getYear() + '-' + (gdt.getMonth() + 1) + '-01 00:00:00');
var workingDayCount = 0;

while (start.before(gdt)) {
    if (schedule.isInSchedule(start)) {
        workingDayCount++;
    }
    start.addDaysLocalTime(1);
}

if (workingDayCount >= 10 && workingDayCount <= 13) {
    return true;
}
return false;

I haven’t tested this exact script myself yet, but it looks fine and should work as expected. Give it a try and see how it goes.

🔹 Please mark ✅ Correct if this solves your query, and 👍 Helpful if you found the response valuable.

Best regards,
Aniket Chavan
🏆 ServiceNow MVP 2025 | 🌟 ServiceNow Rising Star 2024

[WilliansM]

https://www.servicenow.com/docs/bundle/vancouver-platform-administration/page/administer/time/task/t...