I have an announcements list that we use for alerts. This list has a working custom SPD workflow attached for emailing the posted alerts.
Recently, I setup and applied an information policy to the alert content type assigned to this list that takes the Expires date and runs a workflow that copies the expired items to another list (archive list) and then deletes the expired items
from the active list. The policy works great for newly created items. However, for the already existing 300 list items the Information Policy and its workflow do not work. In the Exempt From Policy column, these items are marked as follows: "This
item is exempt from policy. This item will not be expired until the exemption is removed. Remove Exemption..."
I cannot make the change in Data View because the Exempt From Policy status is set by SharePoint. It cannot be updated except by opening each item and clicking Remove Exemption. My boss has assigned me with finding a bulk method to make the change.
I've tried to create a workflow in SPD (with extended workflows added) to change the Exempt From Policy column status to nonexempt. Unfortunately, I cannot find a way to make this happen even though I googled this issue
View Complete Post