Solved

SharePoint Designer 2007 workflow lookup on multiple fields

Posted on 2011-02-28
10
1,001 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:MonsterBM
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
10 Comments
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 125 total points
ID: 35001264
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
 

Author Comment

by:MonsterBM
ID: 35001837
Not sure if this will do it.

I need to know: Is Approved = Yes where Workflow Item ID = xxx and Content Type = yyy
0
 
LVL 14

Assisted Solution

by:GeorgeGergues
GeorgeGergues earned 125 total points
ID: 35001948
on your comparison , use the [Compare any datasource ]

See attachment
 Any Data source


 AND Condition

best of luck
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:MonsterBM
ID: 35013722
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
 
LVL 14

Assisted Solution

by:GeorgeGergues
GeorgeGergues earned 125 total points
ID: 35013834
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
 

Author Comment

by:MonsterBM
ID: 35014051
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
 
LVL 14

Assisted Solution

by:GeorgeGergues
GeorgeGergues earned 125 total points
ID: 35016500
Start with the ID related condition first
0
 

Author Comment

by:MonsterBM
ID: 35022382
I'm sorry this is not enough information. Please elaborate.
0
 
LVL 17

Expert Comment

by:GreatGerm
ID: 37693315
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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

Suggested Solutions

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

739 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