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

Posted on 2014-08-05
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
                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.  

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

This does not work.  Ideas?
Question by:GStoner
    LVL 9

    Accepted Solution


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

    Author Closing Comment

    I figure this out shortly after posting the question, but forgot to add an update.  Thanks for you comment.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    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…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now