Automation rule should send email based on lookup issues but it either sends duplicates or no emails

[Abiy Kaltiso]

What I am trying to do

Trigger: Every weekday at 8:30am

Action: Lookup stale issues based on a JQL query

Then: Email the assignees of those issues with a list of their stale tickets

Expected result: assignees with stale tickets should each get 1 daily email at 8:30am with all of their stale tickets in a list

Actual results: assignees get duplicate emails.

or

If I uncheck the box "Run a JQL search and execute actions for each issue in the query” on the scheduled trigger step then I thought that would solve the problem but instead it ends up not sending any emails at all with the error, “Could not send email, the ‘To’ address field is empty. If you have referenced a field it may be empty.” in the audit logs

The JQL I have in the screenshots are just test issues. Actually query to find stale issues will be be based on last updated date. 

[Edrick]

you need to create an action which create a variable and as the value of the variable add this {{#lookupIssues}}{{assignee.emailAddress}} {{/}} . Then use the created variable  on the to  for the email. 

[francis_pierre-louis]

@Edrick did this actually work? And @Abiy Kaltiso did you ever find a solution. Im having the same issue.

[Mauricio Heberle]

Did you try using the variable?

[Edrick]

im having the same issue, any more suggestions

[Mauricio Heberle]

Try removing the Jql from trigger 

[Abiy Kaltiso]

Hi Mauricio, as mentioned if I remove the JQL from the trigger then no emails are sent and I get the error in the audit logs, "Could not send email, the ‘To’ address field is empty. If you have referenced a field it may be empty.” 

[francis_pierre-louis]

Anyone resolve this?