Trello Report Automation Failing to pull data from board

[Creighton Hayes]

Hi, all! 

I'm trying to build a weekly automation report in Trello to send me a report of all current projects . I have the below data in the automation sequence:

every friday at 7:00 am, create a report in variable "Current Projects" with all cards in list "Current Projects" using pattern "\"- [{cardname}]({cardlink}) ({cardmemberusernames}) => DUE on {cardduedate}\",", and send an email notification to "my email address" with subject "Weekly Report: Internal Projects" and message "\"Current Projects:\n\n {$Current Projects}"

I am getting blank results when I run a report (see below). 
Any advice on how to tweak this pull? 

[Hannah Humbert - Simpla Workflows · Accepted solution]

@Creighton Hayes have you tried removing the space in the report name?

[Creighton Hayes]

Yes, unfortunately produces the same result with no space or one space between the colon and 'Internal' and colon/no colon. 

[Brittany Joiner]

@Creighton Hayes i think @Hannah Humbert - Simpla Workflows means the space in {%Current Project}. I think its not handling the space in that variable name? Maybe try renaming to Current instead of Current Project and see if that works?

[Hannah Humbert - Simpla Workflows]

Thank you @Brittany Joiner!! Should've elaborated 😅 So yeah, try the following instead:

every friday at 7:00 am, create a report in variable "Current" with all cards in list "Current Projects" using pattern "\"- [{cardname}]({cardlink}) ({cardmemberusernames}) => DUE on {cardduedate}\",", and send an email notification to "my email address" with subject "Weekly Report: Internal Projects" and message "\"Current Projects:\n\n {$Current}"

Or you could try CurrentProjects, or maybe even Current_Projects could work.

[Creighton Hayes]

Thanks, y'all - that did the trick!

[Brittany Joiner]

@Creighton Hayes woohoo! glad to hear it! feel free to accept this answer so others who are looking for help know there's a solution in here!

[Hannah Humbert - Simpla Workflows]

Woohoo! 🎉 Not sure why that didn't work with the space but glad that fixed it for you!