Workflow - Templating Context of 'Send Email' Action

[nhassan (Noor Hassan)]

I want to include the oldValue and newValue of department changes from the triggered JSON payload into the email body saying e.g user has changed department from (oldValue) to (newValue).

I don’t know whether it’s possible to include the variables and JSON for these two values in the templating context of ‘Send Email’ action.

I tried a few combinations but without any luck.

For example {"oldDept.$":"$.trigger.changes.attribute.oldValue","newDept.$":"$.trigger.changes.attribute.newValue"}

Any suggestions on how to achieve this?

Thanks

[jesvin90 (Jesvin Joseph)]

Hi @nhassan,

Have you tried using the Define variable operator and using it inside the email.?

[sharvari (Sharvari Shah)]

@nhassan

{"oldDept.$":"$.trigger.changes.attribute.oldValue","newDept.$":"$.trigger.changes.attribute.newValue"}

I would suggest you try it as below:

$.trigger.changes[?(@.attribute == “department”)].oldValue

[jesvin90 (Jesvin Joseph)]

This also seemed to work:

[nhassan (Noor Hassan)]

@jesvin90 and @sharvari you guys are amazing!!!

Thanks very much. Yes it worked.

[nhassan (Noor Hassan)]

@jesvin90 Thanks for the update.

I haven’t tried this but it seems also achievable by using Define Variable as you’ve mentioned.