I am getting duplicate workflow emails in one...

workflow
(Rosemary Black) #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.

(Tony Fader) #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

(Rosemary Black) #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”,

(Rosemary Black) #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.

(Philip Garrett) #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.

(Tony Fader) #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.

(Rosemary Black) #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!

(Rosemary Black) #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.

(Tony Fader) #9

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

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

(Rosemary Black) #10

found it,

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

(Rosemary Black) #11

NewApp-592721 - There is a workflow email

(Tony Fader) #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?

(Rosemary Black) #13

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