Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [splistitem]

Representation of a list item within the SharePoint API.

25
votes
1answer
37k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the item["Field"]....
25
votes
2answers
17k views

SPList.Add() vs SPList.AddItem() SharePoint 2010

Using some test code i found out that SPList.AddItem() executes slight faster then SPList.Add() - does anyone know why is it so ? DateTime start = DateTime.Now; SPList ...
17
votes
4answers
67k views

How to set ListItem Lookup Field value

How do I set a ListItem's Lookup field using code? SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true); SPListItem item = file.Item; item["DocumentID"] = DocID.ToString(); item["...
17
votes
2answers
33k views

Safest way to get a date from Sharepoint into a C# datetime field, using object model?

If I have a Sharepoint list item with a date field. How can I get the field value populated into a c# datetime object? For example: DateTime validfrom = Convert.ToDateTime(item["validfrom"]); ...
10
votes
2answers
31k views

Fastest way to retrieve an item by title?

Currently I am using a foreach loop to find the item I want by its title using the following code: SPList list = web.Lists.TryGetList("DocumentLibrary"); foreach (...
10
votes
2answers
10k views

PowerShell: Update People Picker Field with domain\Username

I'm trying to get this to work in PowerShell: $spListItem[$ppField] = "domain\username" $spListItem.Update() This gives me the following error: Exception calling "Update" with "0" argument(s): ...
10
votes
3answers
3k views

Multiple Lookup field , how to return better deliminators using object model?

I have a multiple lookup field, and when I do this: string myValue = oItem["MyLookupField"]; I get this string back: [id];#[displayText];#[id];#[displayText] or a real example: "5;#C3;#15;#P3" ...
10
votes
2answers
624 views

Efficient way to retrieve all list items

I am retrieving all items from list containing around 4000 items. But it seems to take longer time to fetch all items which is ~15 to ~22 seconds. Is there any best way to fetch all items from list in ...
10
votes
2answers
855 views

Is it possible to create a “Link to a Document” in a Document Library using a CAML Batch Command with UpdateListItems?

I have a Document Library in WSS 3 which has the "Link to a Document" content type enabled, and I want to use a batch command (via lists.asmx updatelistitems) to create a series of links. Here is the ...
9
votes
3answers
26k views

How to read a User field value for a list item

I've got a content type that contains a filed of the type user. When I want to read the ListItem I just get a string containing the users name instead of a object which contains Name, Username, E-Mail ...
8
votes
2answers
10k views

How to get attachment URL programmatically From SharePoint list item?

How to get attachment full URL programmatically From SharePoint list item? Explanation: I have adding new item with attachment. Now I have to bind that attachment link to grid. When click on that ...
8
votes
3answers
7k views

How to get SP.Folder for SP.ListItem in SharePoint 2010 JavaScript Client Object Model?

I have a custom button on ribbon for document library and need to disable it if current SPListItem is an empty folder. To disable button I use EnabledScript attribute of CommandUIHandler. I can get ...
7
votes
2answers
28k views

Getting an ItemCount with filtering in SP2013 using REST api

I am attempting to return an integer (itemcount) of the items within a SP2013 list. I have done this easily using the stock standard json method. However I have a need of counting the splist items ...
7
votes
3answers
19k views

Cannot get field value of list item through JavaScript

I try to get the value of a list item (that is currently selected). I know that I must load it into the context but even with loading the field explicitly I get the following message. Microsoft ...
7
votes
1answer
2k views

ItemUpdated event handler runs four times

I have a list in the rootweb, and a list in a subweb. I want to update/add when something changes in an item in the subweb. This method is invoked in an ItemUpdated event receiver. The problem is that ...
6
votes
1answer
4k views

Attach a file to the list item

I attach a file to the list item when it is updating and when new item added. Additional condition when item updating - if the file already exists, remove it and replace the new one. I receive events ...
6
votes
3answers
645 views

SPList.GetItems(view) vs SPList.GetItems(query)

Which solution from the two is the most efficient one: 1. Using SPList.GetItems with a given view as a parameter 2. Using SPList.GetItems with a given query as a parameters and then retrieving from ...
6
votes
2answers
3k views

How can I tell if a document is 'being published'?

I need to use the relevant event receiver to tell if a document is being published, is this possible? I will settle for has 'just been published' - i.e. I have no preference between itemupdating and ...
6
votes
2answers
3k views

SPListItem.SystemUpdate updates SPListItem.File.ModifiedBy

As can be seen from the debug image when I call SystemUpdate(false) of a SPItem, that SPItem's File object's ModifiedBy attribute changes to "SHAREPOINT\system". Sorry, it's a bit weird way to present ...
5
votes
3answers
294 views

item[ID] doesn't return item[ID]

I have a peculiar issue, following is the code : var item = list.Items[ID]; The problem is that the returned item is actually the Items[ID-11]. I can verify that from dispitem.aspx?id=[ID] Since ...
5
votes
3answers
2k views

Get multiple list-items by URL with one Rest API request

I have an array with multiple SP list-item URLs. I want to get all data from every list-item . I solved the problem with a loop that does a Rest API Request for every single URL. I don't like this ...
5
votes
1answer
8k views

loop splistitem in folder in powershell

I'm trying to loop all splistitem in a folder of a library. I can get my library and have folder but i'm not able to get the items inside the folder. When i display the listitem for folder, i've the ...
5
votes
3answers
5k views

Invalid SPListItem. The SPListItem provided is not compatible with a Publishing Page

Whenever I try to save or publish or check in the web-interface, I get this error. The test-environment did not have this issue, and I've only added a single web part to the page and tweaked the CSS ...
5
votes
2answers
186 views

How would I get the Fields which are enabled and the position from left

In my SharePoint list, I have modified the view like this. I want to get the 'Display' value and 'Position from Left' value for the fields. Is is possible with CSOM or another way?
5
votes
1answer
500 views

List items updated programmatically do not save changes?

I have a custom content type, and a custom list definition based on that content type. I am adding two new fields to the content type in a feature upgrade. Adding the new fields to the content type ...
5
votes
1answer
62 views

How to set calculate column result in another item

I made a list for Event Planning, the columns name are: Row(to change the order) Subject start time duration end time(sum of start and duration) I need to copy each end time to start time of ...
5
votes
2answers
3k views

Converting ListItemCollection to List<t> efficiently

I am getting items from a sharepoint list, like below, and then appending these to a list of the object type. I can't help but feel this is a slow way to populate this list, looping through each list ...
5
votes
2answers
670 views

SPQuery returning different before and after using RunWithElevatedPrivileges method

I am having a huge problem here. I am executing a query looking for a SPListItem, when I execute this query with user identity it works well, retuning the fields "Author" and "Editor" that I need. ...
5
votes
1answer
658 views

Get SPListItem from LINQ

I have used SPMetal to create a data context. I can query my lists. The queries return an object of the type of list that they are in. Is it possible to convert this type into a normal SPListItem ...
5
votes
2answers
1k views

Problem with CAML SPQuery ItemChildCount result

I know that this query works fine SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef Name='ItemChildCount' Ascending='FALSE' /></OrderBy>"; But my ...
4
votes
3answers
6k views

Find creation time for list elements (including documents)

I know SharePoint has some hidden fields for list items. I need to check the timestamp for when a list element was created, is this possible? The reason is I must allow the item to be edited for the ...
4
votes
2answers
28k views

REST to get list item by Id

I am always comfortable using JSOM, and I have used less of REST calls to access lists and its Items. But now I have a requirement to use only REST to get item by its ID. Is there any code snippet ...
4
votes
2answers
12k views

How do I get the url for attachments on an SPListItem using C#?

I have an SPListItem for which I would like to get the urls of all its attachments. The urls will be used as part of my custom web part which has an SPList of SPListItem items.
4
votes
2answers
11k views

Set default value in a document library column via Powershell?

I'm looking for a powershell script that allows me to set the default value for a column in SharePoint. Thanks
4
votes
2answers
631 views

People or Group field returning semicolon hash then Name

In querying the properties of a list item, I found that returning the value of a people or group field that the value would be returned in the form 1;#George Grainger Using the code: properties....
4
votes
1answer
2k views

SystemUpdate() in list item update

What's the advantage/reason for using SystemUpdate() over Update() when list data update?
4
votes
3answers
4k views

Get SPListItem by UniqueID

I'm trying to retrieve AN SPListItem from his UniqueID. I can have his document library url like http://mysharepoint.be/MYDOCUMENTLIBRARY but when i try to get the SPList from the name "...
4
votes
3answers
4k views

Add New List Item With Attachment Via Excel VBA

I have users that have a schedule template in Excel (2010). I'm wondering how I can code via Excel VBA to create a new list item and attach the Excel worksheet they are using that contains the ...
4
votes
2answers
5k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
4
votes
1answer
4k views

Updating a SPFieldMultiLineText field

I have an SPListItem. I have a field on the item of type SPFieldMultiLineText. How can update the value of that field?
4
votes
1answer
409 views

Fetching and displaying more than 5000 list items

I am aware of the list items threshold of 5000 items. But I need to display more than 5000 items on a SharePoint Hosted Addin and on a .net website. How can I overcome this constraint? Also, I do ...
4
votes
1answer
272 views

Available options in SharePoint 2016 on-premise to print list items and have a custom print page with header,footer, etc

I am working on a team site collection inside my sharepoint 2016 on-premise. and i have added a custom list. now our customer asked us if we can implement the following to be able to print the list ...
4
votes
1answer
469 views

SPListItemVersionCollection - iteration performance

This question is related to my issue described here: SharePoint 2010 Performance troubleshooting On SP 2010: Does anyone knows if there is some performance limitations while using ...
4
votes
2answers
6k views

Locking SPListItem for entirely server-side update

I am using code similar to the following to apply an update to an SPListItem, after necessarily elevating to System privileges on said item. Because this can be called multiple times for the same ...
4
votes
2answers
67 views

Automatically create HTML pages on adding an item in SP 2013 list

So I am very new to coding. Please bear with me. We have a SharePoint list wherein we store employee details. The task is to automatically create a new page with predefined UI -every time a new ...
4
votes
1answer
618 views

Get actual item from SPRecycleBin

Similar to this question, I need to permanently delete only specific items from the recycle bin. I need to know more than just their names, however, and SPRecycleBinItem seems to have only have a ...
4
votes
1answer
543 views

Caching SPListItems with Permissions

I have a versioned list that I need to cache list items for. The effect of which being: If a user has permission to view non published items the cache can return the item pending approval. However ...
4
votes
2answers
216 views

Editing list item with custom field creates a new list item on current date and time

Based on How to add new field to custom list (See edit!) It is a different question relating to the above so thought I'd create a new question as the above was technically answered. But after adding ...
4
votes
1answer
205 views

Delayed Writes & Implications for Cross-Process Synchronization

Simple scenario: OWSTIMER creates a new SPListItem, populates it and calls .Update(). It then fires an HTTP request over to w3wp.exe (front-end app-pool) to invalidate an in-memory cache held there. ...
4
votes
0answers
432 views

SharePoint Online Ribbon Custom Action : Pass multiple itemId in CommandAction's Url

I am developing custom ribbon action using SharePoint hosted app. and this is working fine.When i select any list item and click on custom action then i can get selected list item id. <...