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.
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.
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โ
}
What message appear when you Test the workflow?
{
โ$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
}
}
]
}
}
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?
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?
Sorry for the bad explanation.
Yes I mean in a template, can I use column names from both tables?
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]>>.
Thank you very much.
Youโre welcome
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |