Slice data in e-mail body

Hello all,

I have some data filtered in a slice. How can I reference this slice, and send all the rows of data in the e-mail body?

My Slice Name is “Stock To Order”
The primary key field is called “ID”
“Item” Column Exists
“Last_Known_Order_Code” Column Exists
“To Order” Column Exists

<<SELECT(Stock To Order[ID],TRUE)>>
<<[Item]>>, <<[Last_Known_Order_Code]>>, <<[To Order]>> 
<>

Errors
Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[Item]’ is invalid due to: Unable to find column ‘Item’.MORE INFO

Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[Last_Known_Order_Code]’ is invalid due to: Unable to find column ‘Last_Known_Order_Code’.MORE INFO

Workflow rule ‘New Workflow Rule’ action ‘Action 1’ Body template. Expression ‘[To Order]’ is invalid due to: Unable to find column ‘To Order’.MORE INFO

Any advice? Sorry, I am a graphic artist, not really good at programming.

Hi,

Without seeing your app, I’m typing this blind, but looks like you need a “start” expression. The correct syntax (again, hypothetically) would be:

<<Start: SELECT(Stock To Order[ID],TRUE)>>
<<[Item]>>, <<[Last_Known_Order_Code]>>, <<[To Order]>>
<>

There are a ton of examples on this help page: https://help.appsheet.com/en/articles/961746-template-start-expressions

1 Like