I wonder if anyone could help me please? I'm looking for a reliable solution to capture the field (In my case) Status which I need to include in my email notifications whenever an item updated.
My current solution which has proved unreliable has been creating an item in a list called transaction log with the time and date stamp, Status and the ID number so when my notification email is sent out it queries the transaction log list for the ID and Status and filter's based on the modified (less than) in the immediate list against the created column of the (transaction log list).
Thanks in advance,
What i understood is you want to send previous value of 'Status' field in the email notification when an item updates.
1. I think you created a new list 'Transaction Log' which will store 'Id' and 'Status'. In this case, when ever item updates in the main list, run workflow like
2. No need to maintain separate list, create a new column called 'Previous Status' in the main list and whenever item updates update the status value in 'Previous Status'. Send value of 'Previous Status' in 'Send Notification' action.
First time alone you will get empty value (when item creation) from second time onward you will get previous status correctly.