Process running regardless of conditional event

[Ben_Rix]

I have a bot running on event change with adds or deletes. The event also has an optional condition:

IF(AND([_THISROW_BEFORE].[Session Reminder] <> [_THISROW_AFTER].[Session Reminder], [Start DateTime]>=NOW()), True, False)

From that I have a branch on condition process dependent on [Date]=TODAY() to run a send an SMS task.

Now, for some reason, the SMS are being sent regardless of the event change condition which should only trigger if a value change in [Session Reminder]

Does anyone see an error in my workflow here?

Regards
Ben

[Ben_Rix]

Not sure but it may be because I’ve not added ISNOTBLANK([Session Reminder] into my event conditional rule.

[Aurelien]

Hi @Ben_Rix

Some remarks:

Ben_Rix:

with adds or deletes

The below condition seems, in my opinion, contradictory with the previous one:

Ben_Rix:

[_THISROW_BEFORE].[Session Reminder] <> [_THISROW_AFTER].[Session Reminder]

This can only occurs with updates.

You may also want to simplify your expression:

Ben_Rix:

IF(AND([_THISROW_BEFORE].[Session Reminder] <> [_THISROW_AFTER].[Session Reminder], [Start DateTime]>=NOW()), True, False)

into (without the IF(), which is redundant here):

AND(
  [_THISROW_BEFORE].[Session Reminder] <> [_THISROW_AFTER].[Session Reminder],
  [Start DateTime]>=NOW()
)

About that:

Ben_Rix:

Now, for some reason, the SMS are being sent regardless of the event change condition which should only trigger if a value change in [Session Reminder]

What happens if you click on the “Test” button of your bot and try step by step to execute your bot ?
Similarly, did you check the Monitor ?

[Ben_Rix]

Thanks so much for your help, yes you were right, it should have been updates only and I am just working on simplifying my expressions. I also needed ISNOTBLANK added to the expression.