We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SharePoint Designer workflow: how do I set "Exempt from Policy" on an item in a SharePoint List?

Medium Priority
1,562 Views
Last Modified: 2012-05-06
I have created a workflow using SharePoint Deisgher 2007 that kicks off when an item in the Sharepoint list expires.  I have set a policy on the list to expire the item when a certain date field for the item equals today's date.    The workflow sends out an email indicating the date has been reached; however I need to reset that date at the end of the workflow and turn off the "Exempt from Policy" setting for the item (the email is a reminder and needs to be sent every 5 days).   I have found a couple lines of code that will do this but I cant use code in a SharePoint Designer 2007 workflow (at least I havent figured out how to do that yet).  Can anyone help me with this?
Thank you.
Comment
Watch Question

Commented:
Do you need to use code, wouldn't it be possible to use either the 'Set Field in Current Item' or 'Update List Item' actions in SharePoint Designer?
You should be able to change the date and toggle the 'Exempt from Policy' fields this way.

Author

Commented:
Unfortunately the Exempt from Policy setting is not exposed in the Current Item via any of the standard actions that I can fine.  And I am not certain there is any way to make it exposed.

Commented:
How does the 'exempt from policy' setting get set in the first place?  If it's in Infopath for example you can promote a column so that it's accessible from SharePoint

Author

Commented:
It is added to the list item when it gets created.  A policy to check for item expiration sets it when the item expires.  It can manually be reset by going to the items drop-down menu and choosing View properties, but its not on the Edit Properties screen...which are the properties open to the workflow.

Commented:
Hm, you could always create a second value that can be read.  Then your workflows would be checking

if (inBuiltExpiration && myNewExpiration)

it's not the tidiest solution but it should be doable

Author

Commented:
The problem is the SharePoint expiration policy.  It automatically sets the Exempt from Policy flag in the list.  I cant tell it not to.   And the expiration policy is the only way I know of on how to kick off a workflow based on a value in a field (date).

Commented:
May be that you need to create a custom action for SharePoint Designer.  You'd then be able to put in the lines of code to reset the expiration field.
http://www.endusersharepoint.com/?p=1146

There are also a number of projects that improve on the OOTB workflow actions available
http://www.codeplex.com/SPDActivities
http://moss.sharepointsolutions.com/SharePoint-Add-ons/Products/Pages/WorkflowEssentials.aspx

If it doesn't allow you to modify the field though then might just end up being a custom action required.

Commented:
I am having the exact problem as Smolakm.  I have an Expiration Policy set up for a List in Sharepoint.  I have the Expiration policy set to kick off a custom workflow that simply sends an e-mail alerting the item's owner that it has expired.  The process then is for the owner to review and manually update a date for when it will come up for review again.  Unfortunately, the item automatically gets set to Exempt after the Expiration policy runs once.  I would like to prevent that from ever happening.  The items in our list should never be Exempt from the Expiration policy.  

Dhope, I looked through all the links you provided above and did not have any luck finding a solution.

Smolakm, did you ever find a solution for this problem?
Commented:
Unfortunately I have yet to find a solution to this.   I was planning on trying to create a custom timer job to kick off the workflow programmaticaly but have yet to investigate how to create that.  

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.