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; } } }

My automation is not returning a list of issues in the email

Serena Dickson

I have created an automation to send an email with a list of issues due for review and everything works apart from the list of issues in the email. My automation:

When: Scheduled

Every week on Mon at 9:00am

Then: Lookup Issues

Search for issues using JQL

project="IP" AND IssueType="Risk" AND "Next Review Date">=1w AND "Next Review Date">=now() AND resolution="unresolved"

For each: Smart Value {{distinctAssignee}}

Then: Lookup Issues

Search for issues using JQL

project = "IP" AND IssueType="Risk" AND "Next Review Date"<=1w AND "Next Review Date">= now() and resolution = "Unresolved" and assignee= {{distinctAssignee}}

And: Send email

send email picture.png

So the email is sent but the issue list is empty. When I check the audit log it comes back with:

audit log.png

Where am I going wrong?

Accepted answers

Rachit Singhal_zohcl9

Hi @Serena Dickson ,

Can you share the snapshot of your email that you had received from this automation?

Please also check the email notification format of your account (recipient account)whether it is set to HTML or Text.

All comments

Rachit Singhal_zohcl9

Hi @Serena Dickson ,

Can you share the snapshot of your email that you had received from this automation?

Please also check the email notification format of your account (recipient account)whether it is set to HTML or Text.

Serena Dickson

snapshot of email - I hope that is ok.

email notification format is HTML

email snapshot.png

Bill Sheboy

Hi @Serena Dickson

I suspect your second use of Lookup Issues returned no issues due to a problem in your advanced branch.

Would you please post an image of your advanced branch?

Kind regards,
Bill

Rachit Singhal_zohcl9

Hi @Serena Dickson ,

The problem is either lookupissues not returning any issue or smartvalues are not codded properly.

Can you check in the audit log section of automation if it is throwing any error for this execution?

Serena Dickson

Hi @Bill Sheboy

Sorry for the late response. Below is the screen shot of my advanced branch.

Thank you

Serena

Advanced Branching.png

Serena Dickson

Hi @Rachit Singhal

This is what I get when looking in the audit log

Audit Log Risk Review.png

Serena Dickson

Thank you to @Rachit Singhal and @Bill Sheboy

I have managed to work out that the issue was within the email.

Rachit Singhal_zohcl9

That's great.

Bill Sheboy

Thanks for that information. Please try changing your JQL for the second lookup issues call to use the account ID value from the branch variable, like this:

project = "IP" AND IssueType="Risk" AND "Next Review Date"<=1w AND "Next Review Date">= now() and resolution = "Unresolved" and assignee= {{distinctAssignee.accountId}}

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud