How to acheive all the multi failure exportsets records to get single notification in a day?

[MUDIGOLAM BHANU]

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.

[Ankur Bawiskar · Accepted solution]

@MUDIGOLAM BHANU 

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.

[SumanthDosapati]

1. Go to the table list of your failed records and apply filter as created on today.
2. Copy the URL.
3. Create a new Flow in Flow Designer
4. Set the trigger as schedule and make it trigger every end of the day 
5. Send an email notification in Flow Actions and include the link you copied in step 2.

Regards,

Sumanth

[MUDIGOLAM BHANU]

@SumanthDosapati 

Thanks for the response!,..

I am looking for "list of failure records" dynamic link that should be mentioned in body template(what it will contain) session on notification along with reason of failures as well.

Thanks,

BhanuPrakash.

[SumanthDosapati]

which table are you referring to when you say 'failure records'?

[Ankur Bawiskar · Accepted solution]

@MUDIGOLAM BHANU 

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.