Trying to Automate pulling an email address and assigning a work item to that individual

[Brandon Drucker]

In the 'description' of this automated work item is the email address of the person assigned to the task. This doesnt really do us any good so I'm trying to automate a way to extract this information and select this person as the 'Assignee' drop down box under the 'Details' section. I havent had much luck and I'm looking for some help here.

Things Ive tried:

I tried creating a variable to extract the Email

{{issue.description.match("Engineer/Supervisor/Drafter: ([A-Za-z0-9:;_. -/&#]+).*@")}}

and then assign the work item to that smart variable

{{extractedEmail}}

I also tried to do an advanced branch to extract the employee ID from that email

{{lookupIssues.extractedEmail.accountId.distinct}}

and then assign the work item to that smart variable

{{employeeID}}

[John Funk · Accepted solution]

Hi Brandon,

The first thing you mention above should work. Add a Log action after you create the Variable to see what value it has, if any. Also, do an Edit work item to update the Assignee field, and not an Assign work item action. 

[Brandon Drucker]

Hi John,

Doing an edit work item gives me these options, none seemed relevant so thats why I did an assign work item. Where do I go from here?

Thanks

[John Funk]

You just type the variable directly in the box - {{extractedEmail}}

[Brandon Drucker]

I got it

Thank you for the help John! I did have to change my coding for the email extraction to:

{{issue.description.match(".*Engineer/Supervisor/Drafter: (\\S+).*")}}

The one I inputted wasnt pulling anything from the "@" onward.

[John Funk]

Nice job! Glad it is working for you.