Run workflow when Certain field Changes

Posted on 2011-05-02
Last Modified: 2012-05-11
I have a workflow at the moment which emails when a item is created as the status is "pending".

I work like this workflow to also email when an item is marked as "closed"

This works fine but if I change any items e.g. the description. The email is sent again as the may possibly still be set as pending.

I have read many articles that I need to create multiple fields for each column and perform a compare. Is this the only way to do this even in version 2010?

Question by:CurtinProp
    LVL 3

    Accepted Solution

    Let the workflow write a value to a tempory column, not visible in the views and content types. Check both values. If both values are not equal to the defined values, send the email. Otherwise don't send it.
    LVL 2

    Author Closing Comment

    Exactly what i've done.


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
    I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now