SELECT expression in email template

AppSheet AppSheet Q&A
, ,
1

Hi. I have an email template in an automation that is not working. I have tested this expression in an action, but it is not selecting the right rows in the template. I get all the rows rather than only the ones that match [Email Receipt]. Apparently, I’m doing something wrong.

Parent table = Users (which is also the table selected in the automation event).

Child table = Leads with a ref column (UsersRef) pointing to the Users table. Key is ContactID.

My expression:

<<Start:SELECT(Leads[ContactId], [Email Receipt] = [Email Receipt])>>

…some other fields…

<>

Can anyone tell me what’s wrong with this? I need the leads that match Email Receipts between the Users table and the Leads table.

2

I got it working with:

<<Start:SELECT(Leads[ContactID], [Email Receipt] = [_thisrow].[Email Receipt])>>

1 Like