We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Generate reports through flow designer

Sprankle
Tera Contributor

I have a requirement to generate reports on schedule basics using flow designer

7 REPLIES 7

Ankur Bawiskar
Tera Patron

@Sprankle 

not possible directly.

You will have to use custom flow action and write script there to trigger scheduled report

var rec = new GlideRecord('sysauto_report');
if (rec.get('name', 'MyReport')) {
    gs.executeNow(rec);
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

(function execute(inputs, outputs) {

var jobClass = inputs.script_job.sys_class_name;
var trueLookup = new GlideRecord(jobClass);
if(trueLookup.get(inputs.script_job))
{
    outputs.passfail = 'pass';
    SncTriggerSynchronizer.executeNow(trueLookup);
}
else{
    outputs.passfail = 'fail';
}


})(inputs, outputs);tried this on action script

@Sprankle 

so what's your findings?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

I have tired as per your suggestion schedduled report is triggering but as a requirement i need to get the attached report should be send to receipents