I’ve been using the following template on a workflow for sending email which is working well
However, when I customized the sam template as following, it is not giving result
Can anyone point guide me on what could be the issue with the second template above that not providing the result.
Hello @Neeraj_Malik, first of all, what does the error log say? you can check that on your log analyzer, because it’s hard to debug the template without knowing your column structure.
Error is around not able to find most of the columns
"Errors": "Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression 'Rel Subject Petrol' is invalid due to: Expression refers to undefined field. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[Rel Subject Ethanol]' is invalid due to: Unable to find column 'Rel Subject Ethanol'. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 1]*0.9' is invalid due to: Unable to find column 'COMPRT 1', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 2]*0.9' is invalid due to: Unable to find column 'COMPRT 2', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 3]*0.9' is invalid due to: Unable to find column 'COMPRT 3', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 4]*0.9' is invalid due to: Unable to find column 'COMPRT 4', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 5]*0.9' is invalid due to: Unable to find column 'COMPRT 5', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 6]*0.9' is invalid due to: Unable to find column 'COMPRT 6', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 7]*0.9' is invalid due to: Unable to find column 'COMPRT 7', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 8]*0.9' is invalid due to: Unable to find column 'COMPRT 8', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 1]*0.1' is invalid due to: Unable to find column 'COMPRT 1', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 2]*0.1' is invalid due to: Unable to find column 'COMPRT 2', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 3]*0.1' is invalid due to: Unable to find column 'COMPRT 3', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 4]*0.1' is invalid due to: Unable to find column 'COMPRT 4', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 5]*0.1' is invalid due to: Unable to find column 'COMPRT 5', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 6]*0.1' is invalid due to: Unable to find column 'COMPRT 6', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 7]*0.1' is invalid due to: Unable to find column 'COMPRT 7', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[COMPRT 8]*0.1' is invalid due to: Unable to find column 'COMPRT 8', did you mean 'SORD #'?. Error: Workflow rule 'Delivery Request Blend with Comprt' action 'Blend Release Email' Attachment template. Expression '[Invoice#]' is invalid due to: Unable to find column 'Invoice#', did you mean 'Time'?.",
Then your issue is that appsheet just can’t find those columns hehe, remember that all template expressions are evaluated from the context of the table from where the workflow is running, unless they are inside an start-end expression of course, but i don’t see any of those in your template, so you have to double check your columns.
There is no issue with the tables for sure which has been verified already. And can’t figure out the issue with expression in the template as the similar expressions are part of other working template
If you could share with us your column structure related to the template you’re building we could provide you with more insight.
@Rafael_ANEIC-PY
Just for debugging purpose I’ve changed the template to have only one expression PETROL - <<Rel Subject Petrol>> but no luck
Also tried changing the expression to the followings and still no luck
PETROL - <<[Rel Subject Petrol]>>
PETROL - <<Start: [Rel Subject Petrol]>> <<End>>