SharePoint Designer 2007 workflow lookup on multiple fields

I am trying to create a workflow which checks the value in a task list using the Workflow Item Id and the Content Type. So far it appears SPD 2007 only allows lookups on a single value. So how do i create an "and" search on a Task List where multiple tasks have been assigned by the same list?

Example: Workflow Item ID = 107 AND Content Type = "Contract Approval"

No Code solutions preferred please.
MonsterBMAsked:
Who is Participating?
 
GeorgeGerguesConnect With a Mentor Commented:
From the Designer , select the Condition dropdown ( Item - > Content TYpe =xxx)

then do the same again  Condition Dropdown ( Current  Item - >  antoher condition yyyy)

designer will automatically format that as a (AND Condition )


best of luck.
0
 
MonsterBMAuthor Commented:
Not sure if this will do it.

I need to know: Is Approved = Yes where Workflow Item ID = xxx and Content Type = yyy
0
 
GeorgeGerguesConnect With a Mentor Commented:
on your comparison , use the [Compare any datasource ]

See attachment
 Any Data source


 AND Condition

best of luck
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
MonsterBMAuthor Commented:
Ok, I guess it should have been obvious. It appears that SP will scroll through the list until all the matches are found but I am uncertain how to define the lookup. I can't just pick a list and column in that list and ask if it matches my search value, say "107". I also have to define additional criteria within the lookup.

The Source and Field are obviously the name of the list to search and the column in that list, but under "Find the List Item"  I am uncertain which field and matching value I should enter. Do I look up the Workflow ID or some other matching reference?

Sorry if these questions seem elementary but defining lookups in SPD2007 can be confusing at times.
SPD2007-Define-Workflow-Lookup.bmp
0
 
GeorgeGerguesConnect With a Mentor Commented:
before that you should select the List (that is the first step )
...

next you will need to pick the first field (let us say ID ( and match ID field to the value (107))
0
 
MonsterBMAuthor Commented:
Is this what you mean?

I understand Source and Field under "Lookup Details". My confusion was about Field and Value under "Find the List Item"


Multi-Compare-Workflow-SPD2007.bmp
0
 
GeorgeGerguesConnect With a Mentor Commented:
Start with the ID related condition first
0
 
MonsterBMAuthor Commented:
I'm sorry this is not enough information. Please elaborate.
0
 
GreatGermCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.