.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

How do you update a Lookup Field from CAML by Name rather than ID

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :SharePoint
Hi, I have the following batch update in my code: xml += "<Method ID='" + currentID + "' Cmd='Update'>"; xml +=   "<Field Name='ID'>" + ID + "</Field>"; xml +=   "<Field Name='FileRef'>" + fileRef + "</Field>"; xml +=   "<Field Name='Title'>" + doc.NewFileName + "</Field>"; xml += "<Field Name='Keywords'>" + doc.Keywords + "</Field>"; xml +=   "<Field Name='Select_x0020_Type'>" + ((doc.TypeName == "General") ? 1 : 2) + "</Field>"; xml +=   "<Field Name='Population'>" + "Demography" + "</Field>"; xml += "</Method>"; The Population field is a lookup. It works if I put the ID of the ListItem in there, but not if I put the name - I need to put the name in. Can anyone help? Thanks. John.  

View Complete Post

More Related Resource Links

update a lookup field from different site


class FeatureReceiver:SPFeatureReceiver


public override void FeatureActivated(SPFeatureReceiverProperties properties)


SPList _SPList = (SPList)properties.Feature.Web.Lists["DestinationList"];

_SPList.ParentWeb.AllowUnsafeUpdates = true;

 using (SPSite oSiteCollection = SPContext.Current.Site) // or give a destination site collection here...
                     using (SPWeb oWebsiteRoot = oSiteCollection.OpenWeb("/sites/Source1/Source11"))
                        SPList oList = oWebsiteRoot.Lists["SourceProjectList"];

Lookup field which allows multiple choice - problem when query with CAML


I created one simple list and added one column - lookup - I've chosen some source list and field, then marked "Allow multiple choice". I created new item in that list, by adding more than one valie to that coulm.

The problem is, when I use CAML query, that column has such values:


and it's suppose to be like this:


do You have any idea, why it doesn't query first ID?

CAML query on Lookup field returns no items



I have a problem with a very simple CAML query that works on WSS 3, but not on SharePoint 2010. The query is:

<Where><Eq><FieldRef Name='CUSTTABLE' LookupId='TRUE' /><Value Type='Lookup'>5624</Value></Eq></Where>

Where CUSTTABLE is the lookup field and 5624 is the ID of the item that the lookup value points to.

This works fine on WSS 3 but on 2010 it returns no results, I expect 5 results as I manually created 5 items that points to the item in the other list.

I'm not getting any errors, and queries on other non-lookup fields work as expected.

I have also tried changing the Type='Lookup' to Type='Integer' as someone suggested that might be the problem.

Has something changed in 2010? What is my next steps to figuring this out....



SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


wss2.0 update/delete/hide lookup column that does not display any values


Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.

CAML with IsNull and and MultiChoice field

We are running into an issue combining a IsNull and EQ query on a single column combined with an OR. We are building the query using U2U, so its not a syntax error (presumably). Has anyone been able to do something like this: 1 column with multiple choices allowed Query against the column and try to find items where the value is either equal to something valid for the column OR null. The same behavior is exhibited with IsNotNull.

Update field Linq

HelloI want to update one field of one record using linq. I use below codeDim p1 = (From p In db.Products_          Where p.ProductID= 1320 _                 Select p).Single        p1.CategoryID= p1.CategoryID+ 1        db.SubmitChanges()The issue is above query first execute select command and then Update command. and then update all fields of selected record. and this cause overflow to DB.I need to only update one field value. How Coudl I get below sql command. (only update one field)update Productsset CategoryID= CategoryID+ 1where ProductID=1320

Update a field in a gridview to False on a Button Click

 Hi, Ive got a list of records in a gridview (from an SQLDataSource) where a field value is set to True.  I've also added a "reset" button in a template field at the start of the row in the Gridview. What I would like to do is allow the user to click the reset button on a particular row and 'reset' the true value to 'false' (updating the source data). Are there any idiot proof tutorials to do this??? Many thanks for your help! Fiorano

Update Managed Metadata Field with using Lists.asmx service

Hello! I am trying to update Managed Metadata Field with using Lists.asmx. I know that I must use this format WSSID;#VALUE|GUID. But I don't Know how I can get WSSID and VALUE Guid! Can I get them with using lists.asmx! Thanks!!

DataView WebPart with lookup and person field

Hi I want to insert a dataview webpart, using REST, referring to a list with look-up fields and people fields. The results I receive are the ID's instead of the values. How can I get back the corresponding values? TIA Sjokke

WSS Lists - Lookup field information missing in Excel 2010

Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 

Can I update Project Field value via some javascript?

Hi there, I've a webpart that's designed to update some project field value, this webpart is  located on a Project Details Pages. On this project details page, there is another MS Build-in webpart call Project Field webpart. Now when I clicked the Save ribbon button, the project field webpart will raise some client calls, at the same time my custom webpart will raise a post-back(update value via PSI) call which will kill the client calls..So is it possible for me update the project filed value via some javascript? so I'll no longer raise a postback. Or is it possible for me to capture the client calls event for MS webpart, then I can fired my own PSI code? Thank you,   Regards, Joe

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

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!

event receiver to update created field of uploaded document

Hi,   I need to update the created column with the document creation time . 1) First should i use ItemAdding event or Item Added event 2) how do i get the file created properties and assign it to the cdocument library created column.

Generic ListItem Field Update function?

Just wondering: is there a built-in utility function to set field value for any field type? E.g., SetFieldValue(SPListItem, object value1, optinal object value2, optional object values) You know so boring to update fields considering so many different types. I bet MS guys did one somewhere!? thanks,

Multiline text field in document library and item update from Word trouble

Hi I have faced a bit of odd problem. Here is the scenario: I have document library with text columns (multiple lines of text) that are set to unlimited length. I have a workflow that runs with Word documents (.docx) that stores information in XML to this field. Everything works perfectly until document is edited in Word and saved back to document library. After Word saves my document in document library, the multiline text field is "cutted", only 7 rows of text is saved to my field. I have tried hiding my text field, making it sealed or readonly, but still Word breaks my field. Funniest thing is that when editing document in Word, this field should not have any changes (meaning that I dont show my "long text field" in document information panel back in Word). I have tried also creating event handler to handle itemupdating event in document library where I switch spweb.parserenabled property to false and in itemupdated event I switch it back on. Also I have tried to remove all line changes from XML with no luck. This XML saving to long text field works perfectly with many other places but in this one environment this does not seem to work :( I am looking forward to any suggestions what to try next. I have been wondering about using the eventhandlers and trying to "protect" my text field with some logic but that is still just a thought.   T

Lookup field issue after restore

After restoring a site collection in MOSS 2007, lookup fields cannot link up with the parent list. May I know if this problem fixed in MOSS 2010? Besides, the list item GUID in MOSS 2007 are changed after restoring. Does this case still appear in MOSS 2010? Thanks!
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