How to use repeating process fields in an email
I trying to use the repeating Process Variables below in an email:
Using ${/pd:AP/pd:processFields/pd:EngRequestEmailInfo[0,(EngRequestEmailInfo)]}
to return all of the repeating values.
However, only the first row is displaying:
Do you know how I can get the repeating process fields to display in the Email?
-
You can use the Email Macro $XMLREPEATING2HTML() found here:
Hover your mouse over it and this help text pops up:
Note the part about the tilde character ~ You have to make sure you add that inside the brackets around your xPath. So in your example, it should look like this in the body of your email:
$XMLREPEATING2HTML(${/pd:AP/pd:processFields/pd:EngRequestEmailInfo~})This will then insert a formatted table in your email with column headings that match your field names and then a row for each item in the repeating element.
-
I am able to get the repeating table into the email perfectly now.
However, Iam having issues getting the date to format using the below macro:
$XMLREPEATING2HTML(${/pd:AP/pd:processFields/pd:EngSendEmailTrigger~})
$FORMATDATETIME(${/pd:AP/pd:processFields/pd:EngSendEmailTrigger/pd:DateTime},M/d/yyyy h:mm)
Is the combination of macros causing the date format to not work?
Appreciate any help!
Thanks.
Please sign in to leave a comment.
Comments
3 comments