.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

Updating a list item based on the value of a different list item

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Ok, I've searched everywhere and have gotten mixed information about whether this is possible with standard Sharepoint functions.  I new at Sharepoint, but I'm doing this to help out the department which is short of help right now.  Here's what I'm intending to do - We need a small ticketing system to track software requests.  I created a basic list that accomplishes this fine.  I created another list with criteria that software must meet in order to be approved called software evaluations.  I made a "choice" column called approval status in both lists that have the following options: Approved, Pending, Rejected.  I'd like the softwarerequests.approvalstatus to mirror whatever the softwareevaluations.approvalstatus column value is.  I created a workflow using SPD and it's seemingly easy to use.  I attached it to the softwarevaluations list and set the following as the matching criteria: if softwareevaluations.approvalstatus = "approved" then softwarerequests.approvalstatus = "approved". It mentions that the values aren't unique, but I accept anyway.  It doesn't do anything and I'm thinking it might be because it doesn't know what "issue" to reference.    I feel I'm all over the place right now, so it might be easier if someone just asks me what you need to know to help.

View Complete Post

More Related Resource Links

Updating an item in one list based on data from another

I thought I understood this fairly well, but it seems that I am missing something.  I have created a change management site that uses a calendar list to mark upcoming changes to our IT systems.  I have also created a second list to track some information about the change items that I don't want to show up on the calendar, such as what the outcome of the change was or if the change process was properly followed.  So I have the calendar list and another list called results.  I know that there needs to be a unique identifier that each list item will have in common, so in the results list I created a column called Change Number.  When a new change item is created in the Change Management calendar a workflow runs that notifies some people that a new change has been submitted, and the last step in that workflow creates a new list item in the results list and sets the Change Number field to be equal to the current item ID field.  That part is working right now.  When I create a new change item I can open the results list and see that there is a new item and it has the proper number in the Change Number field. What isn't working is when I try to take actions in other workflows that use data from both lists.  An example is notifying the creator of the change that it has been approved.  When the list item is changed a workflow starts that

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

Dynamic list item title based on date created & regional settings?

I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

Updating list item values in SharePoint Designer using code

Is it possible to programmatically modify the SharePoint objects using SharePoint Designer Object Model. By that I mean coding in SharePoint Designer (not Visual Studio). For example, can we access the list items of a list programmatically and change their values? I can do all this in Visual Studio using SharePoint Object Model but I don’t find a way of achieving this by using programming in SharePoint Designer. I searched through http://msdn.microsoft.com/en-us/library/bb208639(office.12).aspx but no success. If the answer is yes. Can someone please give example(s) or point to some articles etc? Thanks in advance.

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.

No title displayed in the "New" item creationfor a list based on a created list template.


Hello everybody,

I have a problem with a sharepoint list template. I created a custom list in MOSS2007 that I saved as template. The problem is that the new list based on that saved template doens't display the Title (changed on project's name) when I want to create a new item. So after creating new items, their Project's Name (Title) is set to (none) for all of them because I couldn't specify any Project's Name (Title).

I was back to my original list and when I create a new item, the Project's Name is displayed so I can fill it. I searched in the list settings and nothing was special.

The columns are required in both lists, there is no management of content types (maybe a hidden field but NO!), the list is a typical list with basic settings.

Has someone an idea?

I want to reuse this list and the Project's Name (Title) is very important (!).


Thank you.

Improve the Performance of updating sharepoint list item from a Grid


Hello All,

I have a requirement where i have a Telerik rad grid which has a datasource of sharepoint list.
When you edit a record from the rad grid, I have to update the particular record and update the record.

I have a sharepoint list which have more than 150 columns in it.I am using sharepoint object model to update the sharepoint list item by saying
 When I do that,it takes a lot of time to update the record.Is it because of so many columns or
i have more than 20000 records in the sharepoint list.Is there any better way of doing it.

One of my thought is that it might be taing so much time on update as
it has to create the content type for that particular list item.
Is there any way that if we can already define a content type for that list so that
the process of updation will become fast.

Any ideas to improve the performace is greatly appreciated.

Thank you,


problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

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

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



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?


KPI to calculate list item clicked most ?


Hello All:

Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?


Thanks in advance

SharePoint Developer

Concurrent update in sharepoint list item



How the concurrent for sharepoint list item are are handled.

if two or more users are working on same item. Then how sharepoint process multiple update request for particular list item.

link from one list item to another item in the same list?


I have a list in which it is possible for one item to be related to another list item in the same list.  I am trying make a column in the list which would contain a hyperlink to the related list item.  The primary column is called Bill Number, and the secondary column is Companion Bill Number .  The Companion Bill Number is the one I want to be a hyperlink to the list time in which that number is the primary Bill Number.  (hope that made sense!). 

I thought I could create a hypertext link out of the Companion Bill Number dynamically in a workflow action that runs on item creation.  I tried this by using the string builder to create a string for the hypertext link that I set to a workflow variable.  It looks like this  <a href="listURL.aspx?ID=[%Bill:CompanionBill%]">[%Bill:CompanionBill%].  Then in another action in the same workflow I tried to set the CompanionBill column to the variable value. 

What I ended up with was, instead of the number as a hyperlink, the text in the column reads as [%Bill:CompanionBill%].  I'm thinking this is failing because of the workflow process doesn't have the value of CompanionBill at the time I am asking it to set the variable value.

Any ideas on how I might make this dynamic link creation work?

When editing a list item the fields are not blank.


This is a recent issue that I have in which I have a "Issue Tracking" List that maintains the workflow of contract renewals.

When an person goes to edit an existing list entry, the description field (standard) has the original text in the box. Prior to this the original - or any older text from a prior change was listed outside and just below the box - and non editable.

That's not the case anylonger.

Any thoughts?



Video: Field and List Item Validation in SharePoint 2010

SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)

How to Set a list item's createdby or modifiedby field as a User(deleted from AD)



I have to migrate data from SQL DB to SP list. But its old data and some users who created/modified the record has been deleted from the AD. Now I need to set the CreatedBy / ModifiedBy Field of the item accordingly. How to achieve this?

And when I tried to modify the "Editor" and "Author" field through Object Model, it works. But its not working through Webservice. What is the reason behind this?

Please help me find an optimal solution for this...


Thanks and Regards,

/* John JB */

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