Automation Block - Add Chart to report returning no items

[Oggy172]

I'm trying to add a chart to a report (pivot table)

The app is a multi-sheet application if that makes any difference.

When I try to "Add Chart to Report" the charts lookup is blank, though the chart is public / in  a space I can access / app is specified.

Below is my flow, am I missing something obvious? 

What exists above the screenshot is just an app reload webhook with some custom python code / and I want this to run after that event, so I don't think it should be impacted ?

though the full flow is:

[Oggy172 · Accepted solution]

Worked it out, its because I'm using the new pivot table (which isn actually a chart) and so it isnt populated by the automation.

Shame we cant have expand/collapse to a dimension & use them in automations like this