The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [splistitem]

Representation of a list item within the SharePoint API.

Filter by
Sorted by
Tagged with
25
votes
1answer
38k 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 ...
18
votes
4answers
69k 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
34k 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"]); ...
11
votes
2answers
32k 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
4k 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
652 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
857 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
27k 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 ...
9
votes
3answers
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
31k 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
20k 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
1answer
9k 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 ...
6
votes
3answers
658 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
313 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
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
202 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
521 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
4k 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
674 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
7k 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
7answers
10k views

Value does not fall within the expected range. But the field exist

I have the following problem. I have a list with a custom content type, when programmatically I want get an information from my SPListItem I get the following exception: Value does not fall within the ...
4
votes
2answers
32k 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
700 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
1answer
553 views

properties.ListItem.Url inside an event receiver is working well for discussion board items, while it fails for custom list (url will end with _.000 )

I am working on an event receiver inside my sharepoint server 2013. now inside the event receiver i use the following html code to build a link to the current item which cause the event receiver to ...
4
votes
3answers
5k 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
6k 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
2k views

Update readonly field using REST API

I am trying to update a list item using Rest API. Following is my code. It works and it updates all fields except "RichMessage" which is a Note field with RichText="TRUE" and readonly. I have tested ...
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
477 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
322 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
480 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
81 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
387 views

JSOM bulk SP.ListItem creation: get created Ids

I'm using this approach to bulk SP.ListItem creation: var ctx = SP.ClientContext.get_current(); var oList = ctx.get_web().get_lists().getByTitle('listTitle'); myObj.forEach(function(d,i) { var ...
4
votes
1answer
636 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 ...