- 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 03:51 AM
Thanks for the response!,..
Above solution which you are proposed that is induvial record. I need one notification in a day for multiple records failed list link on body of email notification. and also how to mentioned group on "To" address in ;Send email' action in a flow?
Thanks,
BhanuPrakash.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 04:04 AM
that's what it does
run flow daily and you can check if any failed records are there or not and then only 1 email will be sent and it will contain link of those failed records
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 05:17 AM
ok, How to select group instead of email id mentioned on 'To' address in send email?.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-05-2025 05:20 AM
simply give group email there
OR
You can use Lookup Record on sys_user_group and then output of that you can pass in the TO field
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:16 AM
On Lookup Record, multiple records having issue it will return only 1st record from list of failure records. i need all the list of records which are failed. below screenshot might be the- issue. could you please provide the solution for multiple record that can be shown up in body template?