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

expressions
(Andrew Eills) #1

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

(Andrew Eills) #2

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!

(Aleksi Alkio) #3

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.

(Andrew Eills) #4

@Aleksi_Alkio

Ah, that makes sense.

Thx