I am getting duplicate workflow emails in one...

AppSheet AppSheet Q&A
1

I am getting duplicate workflow emails in one of my apps.

It does it when the workflow is set to adds, updates, or both.

Any ideas of what may be causing the issue?

There is only one workflow rule total, and only one action setting the trigger to send it.

2

@Rosemary_Black I’ve seen this happen when the workflow rule has cc’d an email address like team@example.com, which forwards the email to each team member’s email address. This ended up duplicating the message. Could that be happening in your scenario?

I’d recommend taking a look at your workflow audit log and examining what the to: and cc: and bcc: fields are set to.

https://help.appsheet.com/behavior/workflow-sending-email/troubleshooting-workflow-emails

3

No one on the CC or BCC.

The rule only fires once.

Everything looks in order

“RuleName”: “RFI NoteFile”,

“EventType”: “Change”,

“Operation”: “Change workflow rule”,

“RuleEvalMode”: “Production”,

“TableName”: “Log”,

“RuleTableName”: “Log”,

“OperationUpdateMode”: “UPDATES_ONLY”,

“EventMatch”: “Workflow event successfully matched”,

“Condition”: “=[RFI Status Email]=true”,

“MatchesCondition”: “True”,

“Actions”: “Created 1 Actions”,

4

@tony

You know what’s strange, I have 2 apps that show that same app name of NewApp-592721.

They share the same app folder too.

I imagine this is part of the problem.

5

@Rosemary_Black

I looked at “NewApp-592721” with the App Id of “109ca9bf-382b-4f31-a09e-0e08335a0c4b”.

I checked the Audit History and see that the workflow rule “RFI NoteFile” was invoked at 10/2/2018 10:40:24 AM as the result of an Edit to the “Log” record with key “10/01/2018 23:50:52: 63” at 10/2/2018 10:40:14 AM.

If you are seeing unexpected workflow emails, can you tell me the exact date and time of those records in Audit History?

By far the best way to diagnose unexpected workflow results is to use the Audit History. The first step in doing that is to locate the exact record or records in Audit History for the workflow rule.

6

@Rosemary_Black Can you give me the name of the app, the name of the workflow email, and a timestamp from the audit log of a workflow rule that generated duplicate emails.

7

NewApp-59272 10/2/2018 11:52:20 AM It actually does fire a few seconds before this, but that’s before the conditions are met, I think it is sending an email then anyway.

idk.

thank you for your help!

8

That may not be the right timestamp, I am trying ti figure that out.

Working with a few time zones so want to make sure I am looking at the right thing.

9

@Rosemary_Black I’m guessing you meant NewApp-592721?

I don’t see any workflow rules in that app, though.

10

found it,

10/2/2018 10:40:24 AM is the UTC timestamp

11

NewApp-592721 - There is a workflow email

12

@Rosemary_Black I’m not seeing any workflow in your app definition. Can you copy/paste the URL to the page that’s showing the workflow rule definition?

13

@tony appsheet.com - Sample mobile apps for common scenarios Sample mobile apps for common scenarios appsheet.com

14

I am having the same issue with a workflow that was previously working just fine.

15

Several others have reported similar problems. Please contact support@appsheet.com for help with this.