?
Solved

How can I use multiple workflow lookups in Sharepoint Online 2013 Workflow

Posted on 2014-08-05
2
Medium Priority
?
328 Views
Last Modified: 2014-09-04
I’m trying to build a workflow that starts with a conditional statement to route an email to multiple people based on a specific value.  I’m not sure how to do that with the existing workflow template tools.

Here’s an example of what I want it to do:

If Current Item:Neighborhood is one of “Red”, “White”, “Blue”
                Email Joe Smith
Else
                Email John Brown


Since "one of" is not a Conditional option, I thought I could use Contains and then specify the multiple neighborhood names in a string format, but I can get it to work.  

Example:
If Current Item:Neighborhood contains ["Red", "White", "Blue"] then
email Joe Smith
else
email John Brown.

This does not work.  Ideas?
0
Comment
Question by:GStoner
2 Comments
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 2000 total points
ID: 40304275
Try:

If Current Item:Neighborhood = "Red" or Current Item:Neighborhood = "White" or Current Item:Neighborhood = "Blue"
 then
email Joe Smith
else
email John Brown.
0
 

Author Closing Comment

by:GStoner
ID: 40304331
I figure this out shortly after posting the question, but forgot to add an update.  Thanks for you comment.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

621 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