I have an automation set up that is supposed to send an email each Monday at 8am letting people know the status of upcoming items that are due and a list of what is needed to complete them. The automation pulls the information from 3 different tables (using a particular view in each one) and inserts it into the email.
One of the fields it's supposed to pull is the 'Needed to Complete' field (long text field with rich formatting enabled). The automated email pulls all of the other fields fine, but will not pull in this one. And it's not just that the values are empty - the column isn't showing at all in the email.
I've tried retesting a few different times and it still will not pull that field in. Here's what the structure of the automation looks like:
Any idea why it won't pull in that one field?