Hi Team,
I am working on a Scheduled Report in ServiceNow and need some guidance on the best approach for dynamically populating recipients from a System Property.
Requirement
I want the Email addresses field in the Scheduled Report to dynamically pick email IDs from a System Property instead of manually maintaining them in the Scheduled Report UI.
System Property
Property Name:
x_vxt.eidi.report.recipients
Property Value Example:
hans.fischer@example.com,abc.user@example.com,jason.miller@example.com
Dynamically populate Scheduled Report recipients from a System Property?
Any recommended approach, Script Include, Notification customization, or supported OOB mechanism would be very helpful.
Thanks in advance.
Hi,
To my knowledge there is no direct way that you can set the recievers dynamically this way,
but I can at least think of a workaround that should be good (haven't tried it so make sure you do!).
I'm assuming you're triggering this report on some schedule, like daily, weekly or otherwise.
What you can try is to create a Flow that runs on the same schedule but triggers some time before the report triggers.
The Flow would basically look up the value of the system property, then look up the record of the scheduled report, then update the report with the newly found value of the system property.
Example below:
