Workflow not sent email

After i deployed the application, i couldnโ€™t send emails to the customers even though i have adjusted in the workflow. Please help me figure this out, thank you.

0 8 163
8 REPLIES 8

Have you checked the Audit Log if thereโ€™s an error?


After checking my Audit Log, i coudnโ€™t see any mistakes happended. Are there any solutions or checking methods which i can try? Thank you sir.
These are the following detail codes in 1 success action:
Error: โ€œSuccessโ€
Properties:
{
โ€œIfModifiedSinceDateโ€: null,
โ€œgetAllTablesโ€: โ€œTrueโ€,
โ€œsyncsOnConsentโ€: โ€œTrueโ€,
โ€œisPreviewโ€: โ€œTrueโ€,
โ€œapiLevelโ€: โ€œ2โ€,
โ€œtzOffsetโ€: โ€œ-420โ€,
โ€œlocaleโ€: โ€œen-USโ€,
โ€œtableTimestampsโ€: โ€œ{}โ€,
โ€œlastSyncTimeโ€: โ€œโ€,
โ€œappStartTimeโ€: โ€œโ€,
โ€œdataStampโ€: โ€œ8/17/2020 3:38:38 PMโ€,
โ€œclientIdโ€: โ€œ5b586d52-0521-46de-8386-79a2219c1411โ€,
โ€œbuildโ€: โ€œ12ca9763df86f135c448-1597390092254-171cbfa46โ€,
โ€œversionโ€: โ€œ1.000024โ€,
โ€œAppTemplateNameโ€: โ€œ3d79afb4-bd37-4bfd-a34a-3371292143b6โ€,
โ€œOperationโ€: โ€œApp syncโ€,
โ€œRecordTypeโ€: โ€œStopโ€,
โ€œResultErrorโ€: โ€œSuccessโ€,
โ€œAppTemplateVersionโ€: โ€œ1.000024โ€,
โ€œAppDefinitionChangedโ€: true,
โ€œTable:Productsโ€: โ€œLastModified:8/17/2020 3:38:43 PM, NotModified:Falseโ€,
โ€œTable:Customersโ€: โ€œLastModified:8/17/2020 3:38:44 PM, NotModified:Falseโ€,
โ€œTable:Order Detailsโ€: โ€œLastModified:8/17/2020 3:38:42 PM, NotModified:Falseโ€,
โ€œTable:_Per User Settingsโ€: โ€œLastModified:8/17/2020 3:38:44 PM, NotModified:Falseโ€,
โ€œTable:Ordersโ€: โ€œLastModified:8/17/2020 3:38:42 PM, NotModified:Falseโ€,
โ€œPerformanceโ€: โ€œ{โ€œVersionโ€:1,โ€œTimeโ€:โ€œ00:00:03.7281884โ€,โ€œPerformanceTimingRootโ€:{โ€œMidโ€:130,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:03.7281884โ€},โ€œChildrenโ€:[{โ€œMidโ€:63,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:03.7280536โ€},โ€œChildrenโ€:[{โ€œMidโ€:244,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.0146236โ€}},{โ€œMidโ€:155,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5213300โ€}},{โ€œMidโ€:117,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:5,โ€œValueโ€:โ€œ3โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:03.0189904โ€},โ€œChildrenโ€:[{โ€œMidโ€:116,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œOrder Detailsโ€},{โ€œPidโ€:21,โ€œValueโ€:โ€œ03.38.41.897098โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4178925โ€},โ€œChildrenโ€:[{โ€œMidโ€:66,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4177875โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œOrder Detailsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4177018โ€},โ€œChildrenโ€:[{โ€œMidโ€:28,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.8906422โ€},โ€œChildrenโ€:[{โ€œMidโ€:25,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.7177070โ€}},{โ€œMidโ€:34,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1717966โ€}}]},{โ€œMidโ€:33,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:9,โ€œValueโ€:โ€œ17โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.5266074โ€},โ€œChildrenโ€:[{โ€œMidโ€:133,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.5257521โ€},โ€œChildrenโ€:[{โ€œMidโ€:95,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.2260277โ€},โ€œChildrenโ€:[{โ€œMidโ€:94,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.2258005โ€}}]},{โ€œMidโ€:238,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.2995014โ€},โ€œChildrenโ€:[{โ€œMidโ€:240,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.2991508โ€}}]}]}]}]}]}]},{โ€œMidโ€:116,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œProductsโ€},{โ€œPidโ€:21,โ€œValueโ€:โ€œ03.38.41.897098โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4196702โ€},โ€œChildrenโ€:[{โ€œMidโ€:66,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4195287โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œProductsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4194389โ€},โ€œChildrenโ€:[{โ€œMidโ€:28,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.4955866โ€},โ€œChildrenโ€:[{โ€œMidโ€:25,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.3224127โ€}},{โ€œMidโ€:34,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1719668โ€}}]},{โ€œMidโ€:33,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:9,โ€œValueโ€:โ€œ10โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.7948381โ€},โ€œChildrenโ€:[{โ€œMidโ€:133,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.7939495โ€},โ€œChildrenโ€:[{โ€œMidโ€:95,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.4830114โ€},โ€œChildrenโ€:[{โ€œMidโ€:94,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.4827620โ€}}]},{โ€œMidโ€:238,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3100847โ€},โ€œChildrenโ€:[{โ€œMidโ€:240,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3098471โ€}}]}]}]},{โ€œMidโ€:24,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:10,โ€œValueโ€:โ€œProducts_Schemaโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1286483โ€},โ€œChildrenโ€:[{โ€œMidโ€:221,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1282182โ€},โ€œChildrenโ€:[{โ€œMidโ€:222,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œRelated Order Detailsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1281741โ€},โ€œChildrenโ€:[{โ€œMidโ€:18,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œRelated Order Detailsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1281263โ€},โ€œChildrenโ€:[{โ€œMidโ€:253,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1280376โ€},โ€œChildrenโ€:[{โ€œMidโ€:380,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œRelated Order Detailsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1279692โ€}}]}]}]}]}]}]}]}]},{โ€œMidโ€:116,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œOrdersโ€},{โ€œPidโ€:21,โ€œValueโ€:โ€œ03.38.41.897098โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4201315โ€},โ€œChildrenโ€:[{โ€œMidโ€:66,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4199823โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œOrdersโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:02.4198608โ€},โ€œChildrenโ€:[{โ€œMidโ€:28,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5186956โ€},โ€œChildrenโ€:[{โ€œMidโ€:25,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1722510โ€}},{โ€œMidโ€:29,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1724199โ€}},{โ€œMidโ€:34,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1721009โ€}}]},{โ€œMidโ€:33,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:9,โ€œValueโ€:โ€œ9โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.7394264โ€},โ€œChildrenโ€:[{โ€œMidโ€:133,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.7382213โ€},โ€œChildrenโ€:[{โ€œMidโ€:95,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.4268369โ€},โ€œChildrenโ€:[{โ€œMidโ€:94,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:01.4266171โ€}}]},{โ€œMidโ€:238,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3111447โ€},โ€œChildrenโ€:[{โ€œMidโ€:240,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3107820โ€}}]}]}]},{โ€œMidโ€:24,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:10,โ€œValueโ€:โ€œOrders_Schemaโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1611992โ€},โ€œChildrenโ€:[{โ€œMidโ€:221,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1609914โ€},โ€œChildrenโ€:[{โ€œMidโ€:222,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œOrder Totalโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1604841โ€},โ€œChildrenโ€:[{โ€œMidโ€:18,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œOrder Totalโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1604270โ€},โ€œChildrenโ€:[{โ€œMidโ€:253,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1603314โ€},โ€œChildrenโ€:[{โ€œMidโ€:380,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:1,โ€œValueโ€:โ€œOrder Totalโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1602713โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1597278โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œOrder Detailsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1596810โ€},โ€œChildrenโ€:[{โ€œMidโ€:33,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:9,โ€œValueโ€:โ€œ17โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1593599โ€},โ€œChildrenโ€:[{โ€œMidโ€:217,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.1584341โ€}}]}]}]}]}]}]}]}]}]}]}]}]},{โ€œMidโ€:116,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œCustomersโ€},{โ€œPidโ€:21,โ€œValueโ€:โ€œ03.38.44.320854โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5993083โ€},โ€œChildrenโ€:[{โ€œMidโ€:66,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5992198โ€},โ€œChildrenโ€:[{โ€œMidโ€:32,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œCustomersโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5991255โ€},โ€œChildrenโ€:[{โ€œMidโ€:33,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:9,โ€œValueโ€:โ€œ2โ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5949399โ€},โ€œChildrenโ€:[{โ€œMidโ€:133,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.5935192โ€},โ€œChildrenโ€:[{โ€œMidโ€:95,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3110834โ€},โ€œChildrenโ€:[{โ€œMidโ€:94,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.3108699โ€}}]},{โ€œMidโ€:238,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.2822333โ€},โ€œChildrenโ€:[{โ€œMidโ€:240,โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00.2819818โ€}}]}]}]}]}]}]}]}]}]},โ€œIsEmptyโ€:false}โ€,
โ€œResultโ€: โ€œSuccessโ€
}

Also you have mentioned the app as deployed , however in the picture in the first post of yours the appis showing as not deployed.

Till the app is deployed the workflow emails go to only the app owner.

Just for the guidance, to share the experience.

when the workflow to send email is not fired, I always goes to the Mandrill site to see if there is any downtime for their services.

In the recent cases, there was cases I see it tooks hours the users receive the email out of Appsheet workflow, and I immidiately access Mandrill site, but there is no official reports of outage.

Then few hours laters, the email out of Appsheet workflow arrrived eventually.

It is still possible Mandrill, which is service Appsheet useing for Email workflow works badly, hence, i have been suggesting to swith to other or own service to deal with those stuffs, as Mandrill is not really reliable.

@TDhers

It was good example, where Mandrill dose not take it as outage, but those who use the service in Appsheet define it is outageโ€ฆ

Thank you for your information Tsuji, i have something up lately so i couldnโ€™t manage to read this useful information. Iโ€™m checking it now.

The screenshot i took is for checking am i do it right in the workflow, i have deployed it and it failed so i returned to propotype state. Thank you for reminding me.

Steve
Platinum 4
Platinum 4

Please contact support@appsheet.com for help with this.

Top Labels in this Space