[_THISROW_BEFORE] <> [_THISROW_AFTER]

Is this expression available in Display expression of an Action?

I have a grouped: execute a sequence of actions:

In the second action (Sync) I’m checking for the before and after values of the which are set (or not) in the first action (Ref Set). If true, I am running an action to sync my app.

With this setup it simply doesn’t run. If I remove the expression from the Behavior o the Sync action, it works.

No, [_THISROW_BEFORE] row state is not available inside of actions. You should see an error in the Audit log explaining this as the reason the action didn’t execute.

I hope this helps!

@WillowMobileSys

So is there another solution so the actions only runs if the column changed?

Yes. Use a ChangeCounter type column. Set the initial value to zero, set the column to watch as [checkedOutBy] and the Mode to “Reset”.

On each Save of the row, the ChangeCounter will either be:

  • zero - no change to the specified column
  • 1 - column value changed

Then your action can simply inspect that ChangeCounter = 1. NOTE: updates made by actions should also reset the ChangeCounter but you should test and confirm - if you have that scenario.

I hope this helps!