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

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

Mark Manders
Mega Patron

You can either use a flow or a scheduled job for this (I advise the flow, but it seems some people are more used to the old way of scripting). Have it run on a daily base, check on the 'created' and the 'state' and if the created is 7 days ago (and later 14) you can trigger an event (in the scheduled job) or create a notification (in the flow) to be send out. 

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

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Community Alums
Not applicable

Hi Mark,

 

I have a worflow and trying to have the same set up. 

 

Do you have any advise please?

 

Thanks

HP

Hi HP7 

The solution I went with consists of me creating an action within flowdesigner that takes different parameters in order to trigger an event. My setup of this looks as follows: 

S_renPoulsen_0-1683195741955.png

 

With this I then created a flow that runs every 14 weeks and the flow looks up different records that match my specific criteria. I then use a for each action that looks up every record found and then the created action is applied on each record. the action triggers an event which is connected to an email notification. I am able to achieve my desired outcome through this method and it works as a charm.