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

CC does not populate two values

samadam
Mega Sage

I have an email script to send to the creator and an email address. I have the following in the mail script:

 

email.addAddress("cc", 'test@test.com', 'Change Management');              
var created_by = current.getValue("current.opened_by");
    if (created_by) {
        var grUser = new GlideRecord("sys_user");
        if (grUser.get("user_name", created_by)) {
            email.addAddress("cc", grUser.getValue("email"), grUser.getDisplayValue());
        }
    }

Only test@test.com shows up in the CC field on the list view. How can I get both?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@samadam 

you need not query sys_user.

use this

email.addAddress("cc", 'test@test.com', 'Change Management');
if (current.opened_by) {
    email.addAddress("cc", current.opened_by.email.toString(), current.opened_by.getDisplayValue());
}

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

View solution in original post

4 REPLIES 4

Anand Kumar P
Tera Patron

Hi @samadam ,

Try below script ,check if user has valid email.

        var userEmail = grUser.getValue("email");

        if (userEmail) {

            email.addAddress("cc", userEmail, grUser.getDisplayValue());

}

If my response helped, please mark it as the accepted solution and give a thumbs up👍.
Thanks,
Anand

 

 

Omkar Mone
Mega Sage

Can you check if this works for you? 

 

email.addAddress("cc", 'test@test.com', 'Change Management');

var created_by = current.getValue("opened_by");
if (created_by) {
var grUser = new GlideRecord("sys_user");
if (grUser.get("sys_id", created_by)) {
var userEmail = grUser.getValue("email");
if (userEmail) {
email.addAddress("cc", userEmail, grUser.getDisplayValue());
}
}
}

Ankur Bawiskar
Tera Patron

@samadam 

you need not query sys_user.

use this

email.addAddress("cc", 'test@test.com', 'Change Management');
if (current.opened_by) {
    email.addAddress("cc", current.opened_by.email.toString(), current.opened_by.getDisplayValue());
}

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

samadam
Mega Sage

That worked. Thank you