JSD: Automation triage for emailed Microsoft forms

Josh Jeffries_sq1ini

We are currently trying to streamline our new starter process, this consists of a Microsoft Form the end users fill in via ms teams, via power automate (non premium) it then sends an email to Jira Service desk which has a basic triage rule to change the request type to onboard employee. The email looks a little like this

Subject: New Starter It Request for Name Due 2020-08-22

New Starter IT Request has been submitted by "someone@someone" at "8/21/2020 7:02:20 AM"

Name: 
Job Title: 
Brand: 
Direct Manager:
Start Date: 2020-08-22
End Date (if any): 
Telephone Number:
Email Address: (taken from name and brand)
Existing account to copy: 
Additional Permissions, Mailboxes, groups or Teams: 
Additional Software: 
IT Equipment Spec:
Car Park Pass: Yes

Is there any way to grab some of the information from either the subject line or the body and update some fields or create a new subtask from. Ie can we take the start date and update the tickets due date, or if the 'car park pass' is yes can this create a a new service request approval ticket 

Richard Vencu

Hi, I would set an automation rule when issues received by email channel are created.

Using smart values you can extract information from description field (that comes in the form of the email body).

Then just add an edit action where you can change almost anything: issue type, custom fields, etc.

As an example of smart value to grab a field content try this:

{{issue.description.match("(Name: [^$]*)").remove("Name:")}}

this would match the entire line starting with Name: and then will drop the fixed part leaving only the value you seek to use in the field.