- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 12:51 AM
Need to show them for all the multi failure exportsets records to get trigger a single notification on daily basis along with link(reDirect to 'list of failure records') in a body of the template notification.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 01:10 AM
you can use this table which holds export set history -> sys_export_set_run
You can use flow which runs daily, check records created on today in that table with state as Error
Then use flow variable to store the link and use that in "Send Email" flow action
Refer my blog on how to add link to records and enhance for your case
ServiceNow Flow Designer: Adding Record Link in "Send Email" flow action
Something like this in flow
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 07:27 AM
No need of Lookup records.
Just give the below URL as hyperlink in your email body. (Update the instance name with yours)
Regards,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 07:27 AM
No need of Lookup records.
Just give the below URL as hyperlink in your email body. (Update the instance name with yours)
Regards,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 08:52 AM
the Lookup Record is given so that you can fetch the group and nothing to do with the failure records.
I used "Lookup Records" on that table to know the count of failed records.
if it's more than 0 then only send email
I already informed to form link dynamically and then include that in Send Email flow action
Seems you missed that part above
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 05:33 AM
Hi @Ankur Bawiskar / @SumanthDosapati
If i given direct link to link flow variable and then i mentioned that link on email body using data pill. Email is getting trigger every day EOD(on that time no one is working) so that trigger mail checked on next day when the user click that link is redirect to today only not for yesterday failed records. How to overcome from this issue?
Thanks,
Bhanu.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 05:40 AM
you can enhance the logic in your flow variable while setting it in script and subtract 1 day from the current date/time and then include in flow variable
then if agents visit the next day the link still has date for previous day.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2025 05:57 AM
Option One:
1. Make the flow trigger at 11.59 PM
2. Change the dynamic link with filter as created on Yesterday instead of today.
Option Two:
1. Build the query to include the exact date instead of dynamic day like today/yesterday.
2. Construct the URL to open the list of records created on that date.
Regards,
Sumanth