How to pull stakeholder's email associated to particular project, to send notification using flow de

lakshmi_laksh
Tera Contributor
Hello,
I am having requirement to pull  stakeholder's email associated to particular project, to send notification using flow designer in set flow variable script
tried below its not working..
if anyone can help that would be helpfull.

Script:

var
stakeholder = fd_data.trigger.current.sys_id;
var groupdepgroupUserID1uty =stakeholder.split(",");

var answer;
var mem1 = new GlideRecord('pm_m2m_project_stakeholder');
mem1.addQuery('project', stakeholder);
mem1.query();
while (mem1.next()) {
    var mem = new GlideRecord('sys_user');
    mem.addQuery('name', 'groupdepgroupUserID1uty');
    mem.query();
    while (mem.next()) {
        if (answer == '') {
            answer = mem.getValue('email');
        } else
            answer = answer + ',' + mem.getValue('email');
    }
}
    return answer;
1 REPLY 1

Satishkumar B
Giga Sage
Giga Sage

@lakshmi_laksh Check if the below solution helps:
https://www.servicenow.com/community/spm-forum/trying-to-send-email-notifications-to-demand-stakehol...

https://www.servicenow.com/community/platform-analytics-forum/how-do-i-add-stakeholders-as-recepient...

…………………………………………........................................................................................
Please Mark it helpful 👍and Accept Solution !! If this helps you to understand.

………………………………………….......................................................................................