Workflow Notification Activity vs Notification

[MStritt]

On a regular Notification, I get a 'Users/Groups in fields' pick list where I can select a field off the RMR.

On the Notification Activity on the Workflow, I don't see/get it. Is this something I can add? I'm not able to navigate to a specific field (value) on the RMR where I want the email to be sent to. 

[SanjivMeher]

Can you confirm, it is a reference field and referencing the sys_user table. And try with this.

Try with below code.

if (current.u_st_email) {
    answer = current.getValue('u_st_email');
}

[MStritt]

Actually, it's a string field. I'll try your update.

[MStritt]

Hi Sanjiv,

Added the following script, but it didn't send the notification.

// Set the variable 'answer' to a comma-separated list of user or group sys_ids that you want the email sent to.

if (current.u_st_email) {
    answer = current.getValue('u_st_email');
}

[SanjivMeher]

Does this user have an user account in Servicenow? Also can you confirm u_st_email is a field on the table where you are running this workflow on?

Can you try

var u = new GlideRecord('sys_user');

u.addQuery('email',current.u_st_email);

u.query();

if (u.next())

{

answer = u.sys_id;

}

[MStritt]

The email address may or may not be associated with a contact in ServiceNow. It's a string field. It's on the table the workflow is being created against.