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

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

Where am I going wrong?

[Rachit Singhal · Accepted solution]

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

[Rachit Singhal]

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 @Rachit Singhal 

This is what I get when looking in the audit log

[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]

That's great.

[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

[Serena Dickson]

Hi @Bill Sheboy 

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

Thank you

Serena

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