Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

My question is similar to this post.

I just want my workflow to send an email when the "project lead" field changes. I currently have a workflow that fires once when the item is created, simply waiting for the field to contain a value, then sending the email.

How in the world can i get this to work? I've tried creating workflow variables, but haven't had any success. Do I need multiple workflows? An additional column in my list? that seems unnecessary.

This should just be one simple workflow that runs whenever an item is created or changed - monitoring the "project lead".

I can't get the logic straight. pretty frustrating. any help is appreciated.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

What I would do in this situation is create an additional field for project lead that is hidden from the forms. On item creation, a workflow populates this field with the value of the project lead.

Then you create an on change workflow that compares the project lead field with the hidden field. If they are the same, then you know a different field was updated and you simply end the workflow. If they are different, then you know this field was updated. You then email the user and then update the hidden field to the new value.

If the project lead is edited again, the workflow will refire and email the user.

share|improve this answer
    
thanks much. i'll give it a go. –  Bill Feb 9 '13 at 3:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.