I'm using this workflow condition: ISNOTBLAN...

I’m using this workflow condition:

ISNOTBLANK([_THISROW_BEFORE].[TimeTrigger]<>[_THISROW_AFTER].[TimeTrigger])

Although the DateTime values in all the rows of the TimeTrigger column remain the same, the workflow is still being triggered.

Update event is set to UPDATES_ONLY

Is my expression in error?

Thx

Andy

0 3 333
3 REPLIES 3

SOLVED.

It was the ISNOTBLANK.

I removed it and all is working fine.

I must learn more about when and when not to use ISNOTBLANK!

I would use AND(ISNOTBLANK([TimeTrigger]),[_THISROW_BEFORE].[TimeTrigger]<>[_THISROW_AFTER].[TimeTrigger]). Then it won’t send the email if you update any other fields and [TimeTrigger] is still blank.

@Aleksi_Alkio

Ah, that makes sense.

Thx

Top Labels in this Space