Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
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  ||  ✨ 9x 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  ||  ✨ 9x 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