I am working in SharePoint Designer 2013 (the SharePoint site itself is SharePoint 2010, upgrading soon).
We have a list to keep track of our tasks as a team. People can update these tasks. Currently, we have a very generic email that goes out whenever someone updates the task that basically says 'Hey, a task assigned to you was updated, go check the list on SharePoint'. It is functional, sure, but I've been tasked with making the message more detailed.
Specifically, my question is can I show (in the email) the before and after column values after the list is updated?
I think I can accomplish this by duplicating the columns and storing the previous value in each of those columns, but the list has many fields and that seems really un-elegant to me. Is there a better way?
I have a workflow set up that is sending emails appropriately when the list is updated.
As an example, say I have this entry originally:
+---------------+--------------+----------+-----------+
| Task | Requested By | Priority | Due Date |
+---------------+--------------+----------+-----------+
| Update Report | John Doe | 1 | 7/20/2015 |
+---------------+--------------+----------+-----------+
The list is updated to lower the priority from 1 to 3 and move the deadline later, so the list now looks like this:
+---------------+--------------+----------+-----------+
| Task | Requested By | Priority | Due Date |
+---------------+--------------+----------+-----------+
| Update Report | John Doe | 3 | 7/31/2015 |
+---------------+--------------+----------+-----------+
After this action, I would like an e-mail that looks something like this:
Your task Update Report has been updated.
Priority from 1 to 3
Due Date from 7/20/2015 to 7/31/2015
Click here to view the task.
I may embellish that a bit more so it is not so plain, but that gets the point across.
Any ideas? A few hours of Googling has done wonders for my other workflows, but I am stuck here.