nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Automations to Microsoft Teams

filipa.rodrigues

Hey all,

Does anyone know what JQL code I should insert when I want to send an automatic message to teams?

My goal is to send a warning 2 weeks before a new joiner joins a company so that I can remember to onboard them. I know that you can do it with Slack, I searched for Teams, and apparently it is also possible.

So, I really need the JQL, but I don't even know where to start, and how to connect Jira to Teams in the first place.

Can someone please help?

Accepted answers

All comments

Jack Brickey

Hi @filipa.rodrigues , I don't quite understand how JQL comes into play here. It seems to me that if you are creating an issue in Jira for onboarding then the creation of the issue could result in Teams notification. Can you explain in more detail your scenario here? Maybe you need a notification "x days" before the new hire joins? If that is the case then Automation would be the best approach.

automation...

trigger: scheduled daily

condition: JQL example - Status != done and "duedate" <= startofday(10)

action: send Microsoft teams message

filipa.rodrigues

I am quite new with all of this, sorry if my explanation is not good aha. I saw some videos where people insert something here and they got the results they wanted.

Screenshot 2023-03-20 at 11.59.24.png

Just like in that example you gave: Status != done and "duedate" <= startofday(10).

But I didn't know if it is really necessary or not. In sum, I really just need a way to get automated messages on teams 2 weeks before the new joiner joins the company. I really just don't know where to start.

Rajesh Ramankutty

Hi you can create a custom field call Data of Joining and

Sort the JQL same with Date of Joining and then you can set automation rule to trigger email to the team for the same

hence befor 2weeks for Date of Joining your team will get alert and start working on the same let me know if you have a douts.

Jack Brickey

No worries at all @filipa.rodrigues that is why the Community exists, to help each other.

so yes, I think Automation is the right path. What date field do you have that presents the start date of the new hire? I can create and share an example automation if you like. However, I recommend you try creating based on my above guideline example. It should be quite straightforward. As you initially stated you need to zero in on the JQL. Note that you could test your JQL outside of Automation to see if it returns the expected results. This can be done under Advanced issue search (click in search bar, select advanced issue search, enter the above JQL but replace "due date" with your start date as appropriate.

filipa.rodrigues

Thank you @Rajesh Ramankutty !

Rajesh Ramankutty

@filipa.rodrigues welcome

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jql

jira-service-management-cloud

jira-service-management