EMAIL workflow doesn't work but notification does

[Atlas]

Hi,

I have a workflow that works with if this true condition. I get notifications to phones. But in the same rule email EMAIL function doesn’t work. I did define some email content and PDF file. Is it may be an issue?

When I create another workflow with the same email and default content it does work.

Thank you in advance.

[Aleksi]

Hi, have you checked what the Audit history is saying for the reason? You can find it from Manage > Monitor > Audit history > Launch log analyzer > Search the correct Workflow > Click details.

[Atlas]

Audit Log Details
Properties:
{
“AppTemplateVersion”: “1.000281”,
“RuleName”: “Notification”,
“EventType”: “Change”,
“InvokedBy”: “Update”,
“ServerName”: “INSTANCE-EUROPE”,
“ServerRegion”: “europe-west4-gcp-prod”,
“IgnoreSecurityFilters”: true,
“TableName”: “JENERATÖRLER”,
“RuleTableName”: “JENERATÖRLER”,
“OperationUpdateMode”: “UPDATES_ONLY”,
“EventMatch”: “Workflow event successfully matched”,
“Condition”: “=OR([_THISROW_BEFORE].[LOKASYON] <> [_THISROW_AFTER].[LOKASYON],\n [_THISROW_BEFORE].[KULLANIM AMACI] <> [_THISROW_AFTER].[KULLANIM AMACI],\n [_THISROW_BEFORE].[KULLANICI] <> [_THISROW_AFTER].[KULLANICI])”,
“MatchesCondition”: “True”,
“ActionNotPerformed”: “2 errors present.”,
“ActionResults”: “Created 1 ActionResults”,
“Action Type”: “Email”,
“Action Name”: “Send Mail”,
“Errors”: “Error: Workflow rule ‘Notification’ action ‘Send Mail’ Attachment template. Expression ‘TARİH’ is invalid due to: Expression refers to undefined field. Error: Workflow rule ‘Notification’ action ‘Send Mail’ Attachment template. Expression ‘LOG_ID’ is invalid due to: Expression refers to undefined field.”,
“EmailTo”: “a.gokturk@atlasgcc.dz,apps@atlasgcc.dz”,
“EmailCC”: “”,
“EmailBCC”: “”,
“EmailFromDisplay”: “apps@atlasgcc.dz”,
“EmailReplyTo”: “noreply@appsheet.com”,
“EmailPreHeader”: "410kw JENERATÖR | J-002 | ARIZALI | BABA HASAN 2400 ",
“EmailSubaccount”: null,
“EmailSubject”: "410kw JENERATÖR | J-002 | ARIZALI | BABA HASAN 2400 ",
“EmailTitle”: “Alert: Update to application ‘JENERATORLER’ table ‘JENERATÖRLER’”,
“EmailAttachment”: “Name: ‘JENERATÖR TESLİM FORMU BABA HASAN 2400 TODAY().pdf’ Archive: AttachAndDoNotArchive FileName: ‘’ MIME Type: ‘application/pdf’ PageOrientation: ‘Portrait’ PageSize: A4 AttachmentByteLength: 0 AttachmentTemplateHasCustomFonts: False AttachmentTextLength: 0 PDFCount: 1”,
“EmailOtherAttachments”: “”,
“AppTemplateName”: “fecf9c1f-f3df-4feb-8a87-65a40f03fb78”,
“Operation”: “Workflow action”,
“Result”: “Failure”
}

[romanus]

What message appear when you Test the workflow?

[Atlas]

{
“$type”: “Nirvana.Data.WorkflowActionResultEmail, V2API”,
“Attachment”: {
“$type”: “Nirvana.Data.WorkflowAttachment, V2API”,
“AttachmentArchive”: “AttachAndDoNotArchive”,
“AttachmentFileName”: “”,
“AttachmentMimeType”: “application/pdf”,
“AttachmentPageHeight”: 0,
“AttachmentPageOrientation”: “Portrait”,
“AttachmentPageSize”: “A4”,
“AttachmentPageWidth”: 0,
“AttachmentByte”: {
“$type”: “System.Byte, mscorlib”,
“$value”: “”
},
“AttachmentByteEncoded”: “”,
“AttachmentTemplateHasCustomFonts”: false,
“AttachmentText”: “”,
“Name”: “JENERATÖR TESLİM FORMU DEPO TODAY().pdf”,
“AttachmentByteLength”: 0,
“AttachmentBytePresent”: false,
“AttachmentTextLength”: 0,
“AttachmentTextPresent”: false,
“PDFCount”: 1
},
“Bcc”: ,
“Body”: "apps@atlasgcc.dz tarafından " P 01 " ve " C41300724-A " seri numaralı 015kw jeneratör aşağıda bilgileri yazılı şantiyeye teslim edilmiştir.

DEPO
YEDEK ",
“Cc”: ,
“FromDisplay”: “apps@atlasgcc.dz”,
“MailTemplate”: “FINAL-DATACHANGE”,
“OtherAttachments”: {
“$type”: “Nirvana.Data.WorkflowAttachments, V2API”,
“WorkflowAttachmentList”:
},
“PreHeader”: "015kw JENERATÖR | P 01 | ARIZALI | DEPO ",
“PreserveRecipients”: true,
“ReplyTo”: “noreply@appsheet.com”,
“Subaccount”: null,
“Subject”: "015kw JENERATÖR | P 01 | ARIZALI | DEPO ",
“Title”: “Alert: Update to application ‘JENERATORLER’ table ‘JENERATÖRLER’”,
“To”: [
“a.gokturk@atlasgcc.dz”,
“apps@atlasgcc.dz”
],
“ProviderType”: 0,
“ProviderApiKey”: “LFAwmMpIFKPpRm7ikwlSxQ”,
“ActionDefinition”: {
“$type”: “Jeenee.DataTypes.AppWorkflowRule+ActionDefinition, Jeenee.DataTypes”,
“Name”: “Send Mail”,
“ActionType”: “Email”,
“AppWorkflowAction”: {
“$type”: “Jeenee.DataTypes.AppWorkflowActionEmail, Jeenee.DataTypes”,
“To”: null,
“ToList”: [
“=“a.gokturk@atlasgcc.dz””,
“=“apps@atlasgcc.dz””
],
“CC”: null,
“CCList”: ,
“BCC”: null,
“BCCList”: ,
“ReplyTo”: “”,
“FromDisplay”: “”,
“PreHeader”: "<<GÜÇ>> JENERATÖR | <<[KAPI NO]>> | <<[DURUM]>> | <<[LOKASYON]>> ",
“Subject”: "<<GÜÇ>> JENERATÖR | <<[KAPI NO]>> | <<[DURUM]>> | <<[LOKASYON]>> ",
“Body”: "<<USEREMAIL()>> tarafından " <<[KAPI NO]>> " ve " <<SERI NO #>> " seri numaralı <<GÜÇ>> jeneratör aşağıda bilgileri yazılı şantiyeye teslim edilmiştir. \n\n <<[LOKASYON]>> \n <<[KULLANIM AMACI]>> ",
“BodyTemplate”: “”,
“BodyTemplateDataSourceName”: “google”,
“AttachmentContentType”: “PDF”,
“AttachmentTemplate”: “DocId=1cDgQq8AMMiGryYu0_ohA_6N-oFSAQRO2CmRwTTMOojA”,
“AttachmentTemplateDataSourceName”: “google”,
“AttachmentName”: “JENERATÖR TESLİM FORMU <> TODAY()”,
“AttachmentArchive”: “AttachAndDoNotArchive”,
“AttachmentFolderPath”: null,
“DisableTimestampSuffix”: false,
“AttachmentPageOrientation”: “Portrait”,
“AttachmentPageSize”: “A4”,
“AttachmentPageHeight”: 0,
“AttachmentPageWidth”: 0,
“OtherAttachments”: null,
“OtherAttachmentList”: ,
“MessageChannelName”: null,
“UseDefaultContent”: false
}
},
“AppErrors”: {
“$type”: “Jeenee.DataTypes.AppErrors, Jeenee.DataTypes”,
“RecordInfo”: false,
“RecordWarning”: true,
“AnnotateErrors”: false,
“Errors”: [
{
“$type”: “Jeenee.DataTypes.AppError, Jeenee.DataTypes”,
“Severity”: 0,
“ErrorCode”: “ERROR_WORKFLOW_INVALID_EXPRESSION”,
“Description”: “Workflow rule ‘Notification’ action ‘Send Mail’ Attachment template. Expression ‘TARİH’ is invalid due to: Expression refers to undefined field.”,
“ComponentDescriptor”: {
“$type”: “Jeenee.DataTypes.AppComponentDescriptor, Jeenee.DataTypes”,
“ComponentName”: “BEHAVIOR_WORKFLOW”,
“EditorPropertyId”: “ErrorPaneHeader”,
“SchemaPath”: null
}
}
]
}
}

[Atlas]

I tested the workflow, adn did troubleshoot the errors. Now it works, thank you.
Just a question, the << … >> expressions are in the template, all need to be in the same table?

[Aleksi]

Are you able to describe a little more with this “all need to be in the same table”? Do you mean on a template? Are you able to take a printscreen from that template?

[Atlas]

Sorry for the bad explanation.
Yes I mean in a template, can I use column names from both tables?

[Aleksi]

In generally no, you can’t, BUT… It totally depends what kind of template structure you have. For that specific question, we should see your template. For example if you are using Start: & End expression, you can read columns form another table just like <<[Column]>>.

[Atlas]

Thank you very much.

[Aleksi]

You’re welcome