cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
douglas07
Helper I
Helper I

Fill fields in Jira via e-mail receved in outlook

Hi,

 

I am trying to create a flow wich:

When i reveived a e-mail in outlook, he to create a issue in jira and fill some fields with data of body of e-mail, for example: "Name", "E-mail", "Start date", "Due Date"...

This e-mail will send of a other software, wich i am control the format of the body and create a standart.

This flow is possible?

 

7 REPLIES 7
VJR
Super User
Super User

Hi @douglas07 

 

Yes creating a Jira ticket from an incoming email is possible.

The fields in the body of the email should have some kind of a structured format.

 

If you need a start, go to the Templates section and search for Jira. You will get several pre-built templates using Jira. Probably you could take a little assistance from the template called "Create an issue in Jira for a flagged email".




-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

 

Hi @VJR , Thanks for the feedback.

 

I tried to use this template, but I understood that with it I can define the fields that will always be filled in the same way. for example, in the image below, if I put "name" : "Douglas", every task created turns with the field Name = Douglas, but what I wanted is for the power automate to look for this data in the body of the email.image.png

In this case, the email would always come in this format:

Client name: -------
Email: ------
Telephone: ---------
Start date: --------
Due date: ----------

VJR
Super User
Super User

Hi @douglas07 

 

As I mentioned the Templates was just as a starting point to begin with and will not give everything you are looking for in the requirements. 🙂

 

You will need to 

- Read the body of the incoming email

- Using string functions (like Text action or Expressions) extract the actual value of client name from the string Client name: -------

- Then use that result inside the Jira action.

 

This will always dynamically use any client name that is present in the incoming email and create the ticket according to that client.

 








-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

 

Great @VJR !

 

This is the point, I have not been able to use these functions to search for data that will constantly change. I can search for data that will always be in the email, such as "phone", but I couldn't create a code to search for your answer, which will change with each email.

 

 

VJR
Super User
Super User

Hi @douglas07 

 

You can take a look at the solution given in the below post

 

Using a flow to extract email body details

 

The inputs are similar to what you need so this should help.




-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

douglas07
Helper I
Helper I

Hi @VJR ,

 

Thanks for the help, i don't no if this flow work it with Jira but he do wich i need.

VJR
Super User
Super User

Hi @douglas07 

 

Yes it will work.

You extract the strings as mentioned in the other post (Using a flow to extract email body details)

Then pass those to the Jira.

 

Post back with what you've got so far so that myself or anyone else might be able to help you achieve that

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,667)