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

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

SharePoint Designer 2007 Workflow needs to initialize lookup field value and store it

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
This is for a governance tracking list. I have two tables: Roadmap and Roadmap Status In Roadmap, there are two fields of interest that are lookup fields to Roadmap Status:Title they are Status and OldStatus When an item is entered in Roadmap, I want to force the initial Status to "Submit" from Roadmap Status. I don't see any way in my workflow to to lookup that item in Roadmap Status and place the pointer (I'm assuming it is a GUID) into the field. The value is also stored in OldStatus to catch changes as I'm trying to force order of status in a few cases but not all. I'm doing it with a Lookup instead of Choice because the business tends to change the terminology they like and this way I don't change it in several places plus it allows them to change it in the list instead of someone changing the list field values. I've seen several places on the forum where people have a similar problem and Lambert Qin has given an answer but it never fits this scenario exactly. Do I have to go back to Choice columns? I only have Designer and would rather not have to learn another tool for a simple SharePoint implementation. Thanks for any help!

View Complete Post

More Related Resource Links

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,


MOSS 2007 - SharePoint Designer Workflow failing when using group vs individual user

I am creating a simple workflow in SharePoint designer that will email a selected user when a list is modified.  I am applying the condition "if modified by" in Designer.  This condition works fine and the email is sent when I select a specific user myDomain\username.  It does not work when I attempt to associate a SharePoint group with the "if modified by" filter. In my example the list has only one SharePoint group associated with it, this is the only group with permissions for the list.  The group contains multiple users. The workflow is successful with the following scenario: if modified by myDomain\user1 or if modified by myDomain\user2 The workflow fails with the follwoing scenario: if modified by mySharePointGroupName  (which includes myDomain\user1 and myDomain\user2) This would be an ungodly if statement with a large membership SharePoint group.  This would also be a nightmare as people leave the organization and their account credentials are left in the large if statement in the workflow.  Looking for the modified condition when associated with a group seems like the logical way of doing this. I also tried "myDomain\domain users" which accounts for all user in my domain, this failed as well. Any advice would be greatly appreciated.

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to pro


how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to production server. 

 i create a workflow in a list with SPD 2007 . I want to deploy it to production server who i can do this.

Thanks and Regards Er.Pradipta Nayak

Sharepoint Server 2007. Sharepoint Designer workflow not starting for one user only.


We have created a custom workflow in SPD that is attached to a document library within a MOSS 2007 teamsite.

The workflow is set to trigger when a new item is created in the document library.

Previously, the workflow has worked fine for all users but recently has stopped working for one user only.

For the problem user, what we are seeing is that when a new item is created in the document library, the attached workflow never starts.  There is no error, the workflow just does not get triggered.  However, if the problem user goes to an item in the document library and clicks on the workflow she can manually start it and it works fine with no error.

This user has the same permissions on the site as others who do not have any problem.

In the course of investigating this problem, we have temporarily increased the problem users permissions on the document library to full control (was contribute before) but this has had no effect on the problem.  Authentication is being done via Active Directory.  We have tried removing the user from the site and re-instating her but again this has no impact.

Does anyone have any idea how we could fix this problem or further debug it?

i want to create sharepoint 2007 workflow with E-mail notification in sharepoint designer ?


i want to create sharepoint 2007 workflow with E-mail notificationin sharepoint Designer .

my Workflow Scenario is :


Step-1 employer send document for approval to manager .

step-2 When manager will approve or reject . status will send to the emloyer through mail.

step-3 when manager will approve than document is going for approval by main manager.

step-4 if approve or reject status will send it to employer and manager.


plz help me .. for this. how i create in sharepoint designer . plz send me any exmaple of this.



[Sharepoint 2007] How to loop few tasks/activities in Visual studio workflow designer ?


Hi all,

I would like to create a workflow which have 3 tasks.

First the workflow create a task and assigned this task to a user. The user has to choose 4 dates in the year.

For each date chosen of the year two tasks will be created. The first task will ask the user to arrange a meeting.

When the first task has been completed a second task is assigned to the user asking for some feedback of the meeting.


How can i loop these 4 dates easily ?




SharePoint 2007 Designer workflow Migration from a Webapplication.


Is it possible to migrate the workflow (SharePoint 2007 Designer Workflow) from a SharePoint 2007 Webapplication to another SharePoint 2007 Webapplication?If so, how?

Can I use the tool  @http://spwflmigrator.codeplex.com/ for the same?

Crazy Nick | MCTS | India

Workflow in Sharepoint Designer 2007


I have a requirement of creating a task list with workflow. The workflow logic is 1. A enteres information and informs B,C,D and E. 2. B,C,D or E can enter their part of information and after each and every information is entered, the status changes accordingly and finally once all the information is entered, the status changes to completed.

This workflow is simple and requires only sending email to alert users to enter their part of information. It need not be sequential as anyone can enter information in any order. Is it possible to do it using Sharepoint Designer 2007?

Sharepoint Designer 2007, DataFormWebPart, Field as DropDown


Hi together,

I'm trying to use this webPart in Designer. I already successfully made a connection my SQL-Server to show data. I'm able to edit data.

Now I want to customize the edit part of the form. I already discovered the part of the edit-template in sourcecode (xsl).

I already pasted the following

<asp:DropDownList runat="server" id="ff3{$Pos}" __designer:bind="{ddwrt:DataBind('u',concat('ff3',$Pos),'SelectedValue','SelectedIndexChanged','id',ddwrt:EscapeDelims(string(@id)),'@country')}" />

Now how (or where) can I define the datasource of the combobox... Either from scratch or antoher dataconnection (table) or from the already entered values (like in the filter).

Is there somewhere a good tutorial for this?




SharePoint Designer 2007 People lookup in Dynamic String returns undesired value


Background: SharePoint 2007 servers with Site Collection Admin access, using SPD 2007.

While attempting to build email body and subject line text using Dynamic text action in a workflow, I can add a look-up to a field (defined as People/Groups) to return a value for the email text. While this does give that correct reference to the Person, the returned value is the Account value, not the Name value.

Example Text Returned: ...a new vaation request has been submitted by Domain\JSmith for your review and approval...

Desired Text Returned: ...a new vaation request has been submitted by John Smith for your review and approval...

In the People and Groups: User Information page it show the following fields:

Given that I can see that the standard built-in Task Notification emails used in SharePoint 2007 show the Name, not the Account, I'm wondering how/if I can do the same in my dynamic string look-up.

Looking at the XOML XML code I see the lookup, and I'm not disuaded by editng the code by hand (by opening as XML in SPD) instead of the using the SPD GUI for this.

Here's how the look-up is coded by the SPD GUI:

SharePoint Designer 2007- Terminate a workflow automatically.



How to terminate or cancel a running workflow automatically through SharePoint Designer???

I know that there is a action known as "Terminate workflow" to stop the workflow manually.

Whenever an item is changed, automaticaly start this workflow". Whenever an item is in "In Progress" state, waiting for event date and then sends the mail ( pause state ).
Any help greatly appricated...
Srikanth Reddy.

How to update Workflow variable cross-workflow in SharePoint Designer 2007?


Hi All,

created two SharePoint designer 2007 workflow, which attached WF1 to Pages and WF2 Workflow Tasks List,

then I created a workflow variable in WF2,

can I update the variable in WF2 by action in WF1?

appreciated any help, thank you.

How to create a multi-stage workflow in SharePoint Designer 2007


Hello everyone,

I'm new at creating workflows and have only created a very basic one. I was handed a task and creating the following workflow and I have no ideal on what to do.

Here is what they want to happen.

 The user submitts the form and depending on what he chooses in the Segement Report Access field will determine on who it goes too. The user can choose multiple options. The options are our 4 divisons. Each division has one approver assigned to it. We created a list for this and then in the form it's a look up value.


The user choose two of the four options. (Sheet and Color) So the workflow needs to send and e-mail to the Sheet user to approve the request and it needs to send another e-mail to the Color user to approve the request. Now if they both reject it, the workflow would stop and send a message to the user saying your request has been rejected. But if one user approves it and the other one rejects it, it needs to go to the next step, which would be sending an e-mail to the user who sets up the account. They want him to be able to see which parts were approved and which parts were not approved.

Once he's setup then we need to send an e-mail to the requester saying that it's been approved.

Sorry if they is long, I just have no ideal where to start or how to start this.



How to attach a timer in a workflow sharepoint designer 2007


I created a survey in sharepoint designer 2007. Now i want to attach a workflow which will send email to end user after 30 days when certain task is completed and send them the link in the page where user can go click the hyperlink and access the page and fill out a survey.

I am done with survey part and i also know how to create particular workflow but i am stuck how can we attach that timer into workflow so it gets trigerred after 30 day of certain task is completed and send email.

How can we do that, can you please help me.

Any help is appreciated.

Thank You 

Navin Pokhrel

SharePoint Designer 2007 workflow



I am working with  SharePoint Designer 2007, when i create my workflow, i have in the condition list : "if modified by specific person", me i would like to find "if modified by specific  any member in a specific group ",

it 's possible to do it with SharePoint Designer 2007?

thank you

SPD 2007 Workflow: Fetch a value from a lookup field? (Case Mgmt for Govt Agencies Template)


Hi, I need a workflow on a list which will fetch a value from a lookup field in another list.

With the "Case Management for Government Agencies" template, the "Case" field in the Tasks list ls a lookup field on the Cases (Case Number) list.  Now, I just can't find a way of mapping the proper Case Number from the Cases lists using a workflow stated in my "Decisions" list.  Moreover, the workflow completes but the Case field in the Tasks list remains empty (although it is a mandatory field: "must have a value") ?!?

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

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