Send email if record not updated for 14 days

S_ren Poulsen
Tera Expert

I have currently created a catalog item and through a script I can request it on behalf of end users. My current issue is that if the item hasn't been updated by the user within 14 days I would like to send out a reminder email with specifik instructions and then again a new email after 28 days. Currently I have been trying to create a email notification but it doesn't seem to work. 

find_real_file.png 

I have tried a couple of different conditions and the one I would assume is the one I'm looking for is:

"updated > relative > before > 7 days ago" but this has no luck either.

 

Can achieve my goal through an email notification or should i try something else like event trigger? 

Thank you in advance

2 ACCEPTED SOLUTIONS

Mark Roethof
Tera Patron
Tera Patron

Hi there,

What you are trying now is just a notification with conditions? That will never work for your use case.

You could instead create a scheduled Flow for this (zero code), which runs daily and queries for the records you are after. And if any found, creates a Notification.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

S_ren Poulsen
Tera Expert

Hi HP7, 

 

What I ended up doing is that i created a n action within flowdesigner that takes in different values as seen below: 

S_renPoulsen_0-1683189702337.png

 


Hereafter, I created a flow that runs, in this case once, but you could also have it run every 14 days. It then looks up for records matching my specific criteria's but you can easily apply your own here. For each of the looked up records I then apply my created action. This action triggers an event and the event itself is linked to an email notification that sends out the email. 

S_renPoulsen_1-1683189849606.png

 


Works very well for me and my business case. 

If my answer helped you in any way, please then mark it as helpful.

Kind regards,

Soeren Poulsen

View solution in original post

5 REPLIES 5

S_ren Poulsen
Tera Expert

Hi HP7, 

 

What I ended up doing is that i created a n action within flowdesigner that takes in different values as seen below: 

S_renPoulsen_0-1683189702337.png

 


Hereafter, I created a flow that runs, in this case once, but you could also have it run every 14 days. It then looks up for records matching my specific criteria's but you can easily apply your own here. For each of the looked up records I then apply my created action. This action triggers an event and the event itself is linked to an email notification that sends out the email. 

S_renPoulsen_1-1683189849606.png

 


Works very well for me and my business case. 

If my answer helped you in any way, please then mark it as helpful.

Kind regards,

Soeren Poulsen