.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

workflow lookup between 2 fields in 1 list

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
hi, how can a create a workflow lookup in 1 list between 2 fields. i wan to compare if the 2 fields are in the same row. i create a list with users name and their approvers. the approver must be the unique approver of the user in the same list. can i do this with the workflow in sharepoint designer? thnx

View Complete Post

More Related Resource Links

Updating a List item field value in a SPD Workflow is setting Date fields to null

Hello everybody,I faced a very weird behavior while creating a workflow in SPD against a Document Library.Here is the case:1- Create a document library in sharepoint site.2- Add a custom column of type DATE.3- Upload any document to the library4- Edit the item metadata and set the custom date field to any date you want.5- Now using sharepoint designer, create a very simple Workflow with only one action that updates the current item "Title" field to any value. (Note: In my case I set the workflow to start manually and not automatically)6- Save the workflow and then start it on the uploaded item.7- Now check the value of the date column after the workflow is finished.8- You will see that the Date field is Empty... (very weird)Notes:   1-This behavior will not appear on a standard list. it is only appearing in a Document library.  2- I am using WSS 3.0 SP2 + MOSS 2007 SP2. Also SharePoint designer 2007 SP2Did anyone face this situation and does it have a fix, or am I doing something wrong here... Please help.Regards,Maheed

Move custom list (with lookup fields) to another Web Application

Is it possible to move a custom list with lookup fields to other custom lists from one web application to another? Creating list templates does not work and breaks the relationship. Thanks.   Neil

Creating new List Item with Lookup, Owner and DateTime fields WebService



I've created a function that creates a List Item, given a bunch of values (Using the WebService). This works fine when I try to populate plain text fiels. But in the list item there are a few picklists and an owner field. When I try to populate these, I get no error but the new record is not created:

      //batch.SetAttribute("OnError", "Continue");
      batch.SetAttribute("ListVersion", "1");
      batch.SetAttribute("ViewName", "");

      batch.InnerXml =
        "<Method ID='1' Cmd='New'>" +
        " <Field Name='ID'>New</Field>" +
        " <Field Name='Title'>" + title + "</Field>" +
        " <Field Name='Owner'>" + owner + "</Field>" +
        " <Field Name='Status'

Infopath will not allow to customize list forms if the list contains lookup fields with "link to ite


I am posting this here, because the error message is a little misleading: It will say that you may have an incompatible field types, corrupt fields, or fields are mandatory and should not be. As a remedy it's suggested to either make them non-mandatory fields or to delete them and recreate them.

Solution: Just lookup to your field without the "link to item" option. 


Workflow - Create New List Item with lookup field


I have an 'Item list' that has 'ItemName' as a string. The Workflow creates a new 'Task' when a new Item is created. The 'Task' has 'Item Name' as a lookup to that 'Item list'.

I want the Workflow to "Create New List Item" and fill in the 'ItemName' lookup (in Task) with the 'ItemName' string (in Item).

The workflow won't do it because they are different 'types'. Is there a way around this?   

Using Workflow Initiation Form to Modify the Value of a Lookup Column in a List Using a Custom Looku



I am trying to develop a workflow and an associated initiation form that will allow a user to update a column in a list that is a lookup column. I have code working so that the lookup options are being properly pulled from the list and populated in the drop down on the initiation page. However after  completing the initiation page and starting the workflow, with a value selected in the lookup list, the value does not get properly updated; it appears to be updating with a null value.

The following is my code for the XOML and Initiation ASPX file. The name of the Lookup Column is "Primary Technical Category" with an XSLT name of "Primary_x0020_Technical_x0020_Ca." The Initiation Variable is also Called Primary Technical Category (PrimaryTechnicalCategory without spaces as SPD renames it). 

I would greatly appreciate any assistance!

Thanks, Michael

XOML File:

<ns0:RootWorkflowActivityWithData x:Class="Microsoft.SharePoint.Workflow.ROOT" 

Workflow. Copy item to new list - problem updating additional fields in the new list record




I'm having a couple of problems


I have a list, List A. On a couple of triggers I want list A to copy fields to a new record in List B.

Many of the columns are the same Say, column1, column 2, colmn 3. The Copy Item is working fine.


I then want to amend several fields in the new record in List B to reflect the new info from list A, and create info in a fields (say ListBcolum4 type choice and ListBcolum5 single line).

For the life of me I cant get this to work... ive tried updating fields, creating items...

A pointer on how to do this would be greatfully received.

Custom Form Fields not appearing in Workflow Tasks column list when try to Update List Item


UPDATE:  This problem seems to be solved by closing and reopening the Workflow xoml wizard.


I have created a 3 step workflow and at each step I have a Collect data from user task that I use to Update my list item.  I actually have 4 options (If Else clauses) per step and for each option I have to collect the same data from a different user.  So I'm aiming at using "Update list item" 12 times in this workflow.

I have been developing this workflow over some days but the Custom Form Fields that I create in the "Collect data from user" task are not always available when I try to "Update list item".  By which I mean, I try to specify the "data source and field to perfom the lookup on" and I can select the "Workflow Tasks" list but the field that I just created in the "Collect data from user" task does not appear in the fields list!!!

I can't determine why a field doesn't appear.  I have tried using no spaces or special characters, keeping the name of the field short but for some reason my newly created field doesn't appear in the list.  The field does appear in the content type when I look at the settings for the "Workflow Tasks" list and the field appears in the "Workflow Tasks" list of columns and the site content type.&n

Define workflow lookup from other list not working


Hello All,

I have two list. one Expenditure(workflow is attached with this list) and other one is Functional VP.

in expenditure list i have column called as organization. this is choice column (HR, IT, Engg) and in functional VP there are two columns organization and Email Address.  for ex:

Organization        Email Address

HR                         ab@c.com

now when i select HR from expenditure list i want to send mail to the respective email ID from functional VP list. .... so for that .. i have put below action in SPD workflow.

look up details :

Source : Functional VP

Field : Email Address

Find the List item :

Field : Functional VP:Organization

Value : Expenditure:Organization

i am putting above logic in one variable and then in email To: field i am putting this variable. when i hard code above value field like (HR) it works.

but above logic is not working. i guess this is correct but i dont know why and where it is goin wrong.

if you could guide me. it wi

Attach Workflow to Task List, don't get option to manually start workflow via dropdown on task item



I am running WSS 3.0 with other workflows which are functioning correctly.  I created a new workflow in Visual Studio 2008 and was able to successfully run it in my dev environment.  I attached the workflow to a task list in my dev environment and was able to manually start the workflow by using the drop down workflow option and using the menus to manually start it.  I installed this workflow in our production environment and attached it to the task list (which had a SPD workflow attached to it which stopped working about a month ago).  I made sure that the option to manually start the workflow was checked.  When I tried to manually start the workflow, (hover mouse over title, drop down) there isn’t a workflow option.  The workflow also will not start automatically when a task is changed.


I attached this same workflow to a different task list in production and get the option to start it.


I have tried creating a small workflow in SPD 2007 and attaching it to the task list.  It shows that it is attached, when I look at the workflows that are attached to the task list, but I still don’t get the option to manually start it.


I have checked my security and I have fu

Trying to send email using Sharepoint Designer 2007 workflow and email enabled list


I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,


Workflow field not being added to list or views when adding a workflow


This problem just started happening in my entire site collection.  Anytime I associate a workflow to any list or doc lib the Workflow column that shows the status and links to the history is not beind added to the list or any views and is nowhere to be found.   Here's exactly what I'm doing:

1.  Go the List settings -> workflow settings -> add a workflow (for this example the OOB approval workflow)

2.  After adding I go to the List, the workflow column doesn't exist.

3.  I go to "modify view", and the workflow column is not listed in the available columns.

Any help is greatly appreciated.

Workflow Task And Relevant List Item


Hello there...

1. What is the name of  the field thats connect between the task item and  the list name or guid and the list item id or guid

2. SPD: how can when starting the workflow how can i ensure that the initial form variables will be saved at the workflow task list

Many Thanks



SPField of WorkflowEventType in the Workflow History List has value Workflow Initiated but when i ed


hi all

how are you

i wish anyone could help me in this problem

i have a sharepoint sequential workflow created in visual studio

when the workflow starts i log into the workflow history list that workfow is started using the LogToHistoryListActivity

i entered the hidden workflow history list from the browser for example:


i noticed that an item is created in the above list when i run my workflow

the field Event Type in the item above has the value of Workflow Initiated but when i edit the item i noticed that the field Event Type has a value of 0

so can anyone tells me how this field works and from where it is getting itsvalues

thanks a lot


Assigning users when creating a list item in a workflow


I'm using a workflow to assign tasks to users.  When I try to assign the task to a group (set in the workflow designer), the workflow gives me an error.  When I change the assign to property to a single user, the workflow works perfectly.  How do I get the workflow to assign the task to the group?  Or if that's not possible, can I get it to assign it to more than one user?


calculate fields in a list



how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High = 1 day, exclude weekends.



Need to pass parameters from URL to fields in Custom List


I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective fields. I send an email out with a link to the 'Form' that carries the parameters. I am trying to use the following javaScript but am unsure as to where to place this on the SharePoint page for it to work.



<script type="text/javascript">

function loadFormVars()
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name

alert("it works");

function getQuerystring(key, field)
key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var qs = regex.exec(window.location.href);
document.getElementById(field).value = qs[1];


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend