Sharepoint Designer Workflow: Send out Additional Email depending on who modifies file

I have created multiple workflows in Sharepoint Designer 2007.  All kick off when a certain file is uploaded to the library..for example..

Conditions: If title field contains "XYZ"
Actions: Email: "ABC"

However, multiple departments make updates to these files, in which only those departments need to know that the file was updated.  I've tried adding an 'Else If' condition along the lines of:

Conditions: Else if modified by "John Doe"
Actions: Email "Marketing"

However, the initial workflow email does get sent out, when the file is first uploaded, however the modified condition doesn't kick off any email.  

I've also tried adding an additional step, using the same Conditions, but then it just fires off both emails at the same.  

Please help!
LVL 1
njmattAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Justin ImesFull Time SharePoint JediCommented:
have you checked at the beginning of the workflow to make sure the last option was checked to trigger workflow on each updated item?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
njmattAuthor Commented:
Yes, I've disabled that option.  There is no need for emails to be sent out to the entire company when HR does a minor update to the file.  For the time being, I have created separate "Update Workflows" that have to be kicked off manually.  But I'd like to automate the process.
0
MelMcCommented:
Make your statement Modified By John Doe or Created By John Doe so that the initial WF will kick off regardless if its a new one and will still work for modifications
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Justin ImesFull Time SharePoint JediCommented:
right, i should have elaborated... you would need the specific if then statement like melmc suggested, i wasn't saying to make it trigger on every single update, only trigger when the update matches your conditions.
0
njmattAuthor Commented:
MeIMc,

To clarify, are you saying to do the following:

Conditions:  If title field contains "XYZ"
                             and created by John Doe or modified by John Doe
Actions: Email "Marketing"

??
 
0
MelMcCommented:
Yes
0
njmattAuthor Commented:
I've tried that, however, I only have my username is the modified by and created by field, as well as the email field.   The initial WF never gets kicked off.  
0
MelMcCommented:
You have to start the WF on new otherwise it will never kick off on a new upload.
0
njmattAuthor Commented:
I have it set to start on new item created.
0
njmattAuthor Commented:
Closing question, implemented separate update workflows.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.