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

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). broken trello automation.png
Any advice on how to tweak this pull?

Accepted answers

Hannah Humbert - Simpla Workflows

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

All comments

Hannah Humbert - Simpla Workflows

@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.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

trello

trello-cloud