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

MohammedYaseen
Tera Expert

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

4 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Aniket Chavan
Tera Sage
Tera Sage

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.

 

AniketChavan_0-1750933498162.png

 

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.

 

AniketChavan_0-1750936459308.png

 

AniketChavan_1-1750936483001.png

 

AniketChavan_2-1750936526496.png

 

AniketChavan_3-1750936560508.png

 

AniketChavan_4-1750936641289.png

 

 

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

 

View solution in original post

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

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

 

 

View solution in original post

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thanks alot Ankur

Aniket Chavan
Tera Sage
Tera Sage

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.

 

AniketChavan_0-1750933498162.png

 

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.

 

AniketChavan_0-1750936459308.png

 

AniketChavan_1-1750936483001.png

 

AniketChavan_2-1750936526496.png

 

AniketChavan_3-1750936560508.png

 

AniketChavan_4-1750936641289.png

 

 

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