Solved: AppSheet Automation: Expression '[X]' is invalid ... - Page 2

V-A · 02-04-2023 02:54 PM

Creating an AppSheet email bot, I used the below in the email body (per AppSheet documentation here) :

<b>Date: </b>&lt;&lt;[Date]&gt;&gt;
<b>Title: </b>&lt;&lt;[Title]&gt;&gt;
<b>Notes: </b>&lt;&lt;[Notes]&gt;&gt;

The email received displays the column name, as below, without their values:

Date: <<[Date]>>
Title: <<[Title]>>
Notes: <<[Notes]>>

Using the below content for the email body (per AppSheet documentation here) returns the "Unable to find column 'X'" for each column:

<b>Date: </b><<[Date]>>
<b>Title: </b><<[Title]>>
<b>Notes: </b><<[Notes]>>

Which documentation is correct and how do I fix this? Thanks.

V-A

Your suggestion of using the symbols ("<<" and ">>") and applying the LOOKUP function as illustrated here by another forum member, and pasted below, resolved the problem .

If it helps anyone else, the expression template and expression applied are below.

Template to LOOKUP the last row in "My Table" (i.e. MAX(My Table[_ROWNUMBER]) and return the value of "Wanted Column" in that _ROWNUMBER:

LOOKUP(
  MAX(My Table[_ROWNUMBER]),
  "My Table",
  "_ROWNUMBER",
  "Wanted Column"
)

The correct email body setting for the most recent row's "Date" column is set as:

<b>Date: </b><<LOOKUP(MAX(Entries[_ROWNUMBER]),"Entries","_ROWNUMBER","Date")>>

Thanks.

AppSheet Automation: Expression '[X]' is invalid due to: Unable to find column 'X'.