I have an action button that edits 3 fields (which results in 3 changes that need to be synced), and a workflow that sends an email when the value in one of columns changes. I use the ThisColum.Before and ThisColumn.After to check if it has changed.
The issues is that the workflow is sending 3 emails out for each of the values being changed, but I only need one email to go out. My users are complaining about the multiple emails. Can someone please help me to fix it so only one email gets sent by the workflow?
The workflow rule is: [_THISROW_BEFORE].[Approved]<>[_THISROW_AFTER].[Approved]