Issue with Template using <<Start>> and <<End>>

[Caden_Davis]

I am using a form with a header/lines setup and upon additions to the header table, I’m sending the data through to a task (based on some conditions) to email the submitted information out.

I wanted to change the reply-to address so I’m using a non-default output configuration and I chose to let AppSheet create the output body template for me:

However, when I get the email, I’m missing all of the “lines” and only get the header information even though the lines are referenced exactly as this document lines out:
Using Start expressions in templates | AppSheet Help Center

When I look at the event monitor, the referenced lines (VC) just shows: “” even though there are lines which reference the header.

Event Monitor

Data source (showing a line w/ the same header ID)

It seems like a bug, but maybe I’m using the wrong approach?

[1minManager]

Your START formula is missing the key column e.g.

<<START: [Related PO Request Lines][Key Column]>>

[Steve]

The original <<Start>> expression was fine: [Related PO Request Lines] is already a list of Ref.

[Caden_Davis]

@1minManager thanks for your reply!

I added that and I’m still getting the same results.

[1minManager]

1minManager:

[Related PO Request Lines]

Check that this column is not actually empty in the App

Also try this as well <<START: Select([Related PO Request Lines][Key Column],TRUE)>>

[Caden_Davis]

@1minManager well, the column “Related PO Request Lines” is a Virtual Column with the formula REF_ROWS(“PO Request Lines”, “Header ID”)

To clarify, am I supposed to be using the key column of the reference table (“PO Request Lines”) or the header table (“PO Request Header”)?

Here’s what I have:

[Steve · Accepted solution]

help.appsheet.com

Troubleshooting Workflow Emails

Resolving problems with workflow emails.

help.appsheet.com

Workflow

Send Email, SMS, or Notifications on Add, Update, or Delete.

[Caden_Davis]

Thanks Steve!

This worked!