Populate Requested for variable user mail address in Task des

[Manohararuna]

Hello Everyone,

    I have one requirement.

Requested for field is list collector type in Catalog item .if select multiple users then selected users related mail address are should populate in Task des under RITM.

For this i want script in Task event in Workflow.

How can i fix this problem

[Ankur Bawiskar · Accepted solution]

@Manohararuna 

so email addresses of those users should be populated where?

Example: I am taking description field for my reference, you can use this advanced script in Create Catalog Task Activity

var myArray = current.variables.listCollectoVariableName.toString().split(','); // give your variable name here

var emailArray = [];

for (var i = 0; i < myArray.length; i++) {
    //myArray[i];
    var gr = new GlideRecord("sys_user");
    gr.addQuery("sys_id", myArray[i]);
    gr.query();
    if (gr.next()) {
        emailArray.push(gr.getValue('email'));
    }
}

task.description = 'Email addresses are ' + emailArray.toString();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@Manohararuna 

I believe I took example of description field and you can enhance the logic further now.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Manohararuna]

Thanks for Your solution Ankur

[Manohararuna]

Hello Ankur,

     is it possible to set limit to select users in List collector  type requested for variable?

Thanks,

Manohararuna

[Dr Atul G- LNG]

Hi @Manohararuna 

https://www.servicenow.com/community/csm-forum/how-to-limit-the-list-collector-choices-selection/m-p...

https://www.servicenow.com/community/developer-blog/servicenow-learning-139-how-to-restrict-values-t...

[Manohararuna]

Hello Ankur,

         actually it takes time to select users this way.

Since we might on-board more than 100+ users during different Go-live process, this process of manually selecting each user will not be feasible for us.

We would like to have an BULK upload option so that we shall upload an excel file with all the users email & place the request.

Please Provide solution to this way.

Thanks,

Manohararuna