On a list we have two column "Content" and "Approved Content". It is a rich html field. Whenever the list item's approval status = "Approved", the workflow will copy the "Content" value to "Approved Content". Is it possible?
We need to do it because SPD workflow do not have ability to get the last "approved" value of list item. It always get the latest value regardless it is approved, rejected or pending. We need to email out the "Approved content" so we come up an idea to store in another field on same list.