I'm having a bit of trouble trying to fetch comments for email notifications from activities that occur more than once. Here's a quick example
In the above scenario, this is what happens:
1) Next-Level Manager Approval sends a work item to a user. They enter a comment on the OOTB action form - "Comment 1". It is sent to Addtional Information.
2) Additional Information sends a work item to a user. The notification email contains the comment, "Comment 1" previously entered during the Next-Level Manager action form submission. The user enters a comment on the OOTB action form - "Comment 2". It is sent back to Next-Level Manager Approval.
3) Next-Level Manager Approval sends a work item to a user. The notification email contains the comment, "Comment 2" previously entered during the Additional Information action form submission. The user enters a comment on the OOTB action form - "Comment 3". It is approved this time and sent to the next activity.
4) The activity that follows Next-Level Manager Approval (on approval) sends a work item to a user. The notification email contains "Comment 1", when it should contain "Comment 3".
I am using the Last function to obtain the last entered comment - Last(SPComments/Comment/Body, ""). It does not appear that this will work if any activity executes more than once.
Is there any way to fetch the correct comment in this scenario?