Email Template force image

[colt]

Hey there,

I need to SELECT a signature image in an email template manually from another table like:
<<SELECT(TableName[signature], [id] = [_THISROW].[id])>>

But when the email template is generated, appsheet replaces the select with the image URL instead of the actual png.

What am I doing wrong?

[WillowMobileSys]

What type is the “signature” column defined as?

Also, are you using the Email body section of your send Email task or are you creating a template document?

[colt]

Thanks for your reply,

The signature field ist defined as the AppSheet signature type.

I am creating a template document

[Steve · Accepted solution]

The SELECT() expression should be wrapped in ANY():

<<ANY(SELECT(TableName[signature], [id] = [_THISROW].[id]))>>