Workflow Email not sent occasionally

Hi,
I have a problem with sending of emails where occasionally, no emails were being sent out.
The “Send Email” workflow is triggered during ALL_CHANGES event with condition ISNOTBLANK([Email Subject]).
[Email Subject] is a hidden field where it gets updated only during certain Actions for e.g. Approve/Reject.
And in these actions, I defined the [Email Subject] based on the action made by the users.
The “Send Email” workflow also does two reaction in the sequence of Email and TakeAction, where the Data Change Action updates the [Email Subject] to “”.
Below is screenshot of the workflow

An Action where [Email Subject] is being updated

Problem, there were times where no emails were being received by the intended recipients, we’ve also checked in Google Workspace Admin that no emails with the subject were received by the recipients.
The Action “Approve Country Head” has also proven to be working as expected in other times.
And in the Google Sheet source, the Email Subject column was indeed updated with the intended subject and then deleted from the cell right after.

Is this not a reliable way of managing emails, I understand that this might seem like a workaround to simplify the condition for sending emails and email subjects.
Are the actions in the workflow triggered in order? I can only imagine the data was not updated in time for the workflow to be triggered or the Reset Email Subject action was triggered before Send Emails.
Will the Offline/Sync settings affect the workflow as described above?

Any help/advice will be appreciated.
Thanks in advance.
JS

What does the workflow log tell you?

1 Like

Wasn’t able to find any related logs as the incidents were reported after 24 hours.

Haven’t had a reported case recently to check on the logs but here is a case where the email was sent successfully.
Any advice would be greatly appreciated.

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

2 Likes

Hi Steve,
Thanks for the advice, while providing the details for support I found out that a semi-colon ; was included in the recipient address because it was a free text field for users to key in email addresses.
True enough, support at appsheet tested it and confirmed it was the cause for the missing emails.
I would change the field type to Email if it would accept mutliple addresses.
Do you have an idea how to validate email address in a Text type field or allow mutliple email addresses in the Email type field?
Thanks.

Excuse me , What is your Plan user (Pro or Premium or Bussiness plan) ?

I just had to handle this myself recently! A relatively new function will do the job:

4 Likes

That is perfect Steve, thank you for the help again!

1 Like