Inbound email flow

[pratiksha5]

The email body looks like this:

Assignment Team: Win_Infrastructure

I would like to populate the assignment group.

When I am trying to write the script in something like email.body, it is not taking the reference.

Please suggest how to do it.  I have multile things to to that's why not using inbound action. If that is not possible, then I will go that way. I'm just trying to see if this can be done.

[Dr Atul G- LNG]

Hi @pratiksha5 

Have a look here

https://www.servicenow.com/community/developer-forum/inbound-email-action-auto-populate-values-in-in...

[Amit Pandey]

Hi @pratiksha5,

Please use the following code in your inbound action script-

var assignTeam = email.body.assignment_group.trim();
current.setDisplayValue('assignment_group', assignTeam);

[pratiksha5]

getting email is undefined.  I have tried below and it is not working as well

var assignTeam = fd_data.trigger.body_text.assignment_team.trim();

[Amit Pandey]

Hi @pratiksha5 

Alternatively can you try using Flow Designer, with following script- 

var emailBody = fd_data.trigger.body_text;
var assignTeam = /Assignment Team\s*:\s*([^\n]+)/i;
var match = emailBody.match(assignTeam);

var assignGroup = match ? match[1].trim() : "Not found";
var assignmentGroup = new GlideRecord('sys_user_group');
assignmentGroup.addQuery('name', assignGroup);
assignmentGroup.query();
if (assignmentGroup.next()) {
   return assignmentGroup.sys_id.toString();
} else {
    return "No matching record found for contact: " + assignGroup;
}

It had worked for me.