Representation of a list item within the SharePoint API.

learn more… | top users | synonyms

2
votes
1answer
332 views

SystemUpdate() in list item update

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

How to get an SPListItem from a Search Query Programmatically

I'm querying my Search Server and getting some results... How can i get the SPListItem linked to that object? I tried with many ways, but every method fails.. Here's my code: string ...
2
votes
1answer
202 views

Get all list items versions from client side

I am trying to get all versions from every item in a SharePoint list using only client-side through a web part. Following the exemple at ...
0
votes
1answer
1k views

Show list items in AngularJS ng-grid

retrieving SharePoint list items by REST with var app = angular.module('myApp', ['ngGrid']); app.controller('MyCtrl', function ($scope, $http) { ...
0
votes
1answer
24 views

Date value retrieved from an item keep on increasing every few seconds

I was trying to retrieve items from a SharePoint custom list called "Some Events" using JSOM. Title, Venue, EventDate were few fields I was retrieving. Every thing worked fine except EventDate. ...
1
vote
3answers
2k views

update SPList using csv via Powershell

knowing that is possible in PS, exporting SPList items to PS objects(link1 link2) what is the best way, to go into the other way: Create/Update an SPList from an exported csv or format-table.
1
vote
2answers
5k 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 ...
1
vote
1answer
389 views

Refresh parent page after closing list item dialog

I'm trying to refresh the parent page of a list when closing the dialog of a list item. Is there a way to achieve this with javascript somehow? I inspected the button in the DOM and tried to write ...
0
votes
1answer
27 views

Check Child Items When Parent Status Column Is Changed

What is a good strategy to prevent a change on a parent item in a SharePoint 2010 list if a related child item (i.e. the child of the parent) column is set to open? For example, I don't want to allow ...
0
votes
2answers
143 views

Redirect at the end of event itemupdated

I'd like to know if there are a way to make a redirection in an event receiver of a list itemUpdated and not updating. I need this because in my event, i create a file in a folder and of a document ...
3
votes
1answer
960 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 ...
0
votes
2answers
276 views

Unable to cast object of type 'Microsoft.SharePoint.SPListItem' to type 'Microsoft.SharePoint.SPFile

In code below, at mentioned line I am getting this error: How I fix this? SPList docLib = WSweb.GetList(WSweb.ServerRelativeUrl + "/Documents"); //SPList docLib = WSweb.Lists.TryGetList("Documents"); ...
1
vote
2answers
891 views

How to foreach through a list and get distinct values from specific columns C#?

I'm able to loop through a list on sharepoint and get the information I need from selected columns, but how would I loop through a list and get only distinct values from a column in C#. For instance ...
1
vote
2answers
366 views

How to detect SPFieldLookupValue from an SPListItem?

I have a SPListItem, with different fields (string, lookup, etc), that I have to iterate them and do different actions depending of the type. How can I detect if value is type String or type Lookup? ...
3
votes
3answers
4k 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
11k 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 ...
0
votes
2answers
382 views

Sharepoint2013 ctx and Js : Retrieve the value of a field from a list

I'm a totally beginner and totally stuck to a point in my Sharepoint project. What i would like to achieve: part 1 : retrieve the current user's Department's name part 2 : retrieve the department's ...
0
votes
0answers
154 views

is it possible to retrieve the current value in sharepoint list item before save

I have a sharepoint list. On the edit form of list item i have a custom action button to send the mail containg the contents of the list columns . If the user changes any value in a column and then ...
0
votes
2answers
117 views

Insert image from ActiveDirectory to SPListItem c#

First of all, I would like to ask question, do I need to insert image to Sharepoint as Image or byte[] array? I have tried both ways to do that. In both cases it returns me ...
0
votes
0answers
105 views

Change selected items order and merge using Javascript

I am now able to get the selected list items and merge its contents. Is there a way to reorder the selected items before merge? Or is there a way to get the items in the order in which they are ...
1
vote
1answer
52 views

email data from sharepoint list to specific people

I have a sp 2010 cutom list. Whenever the list gets updated, an email should be sent to some specific people and body of the email should be taken from "messageList" I searched net, most of the ...
0
votes
1answer
432 views

How to get the SPFieldLookup object from a SPListItem

I have an SPListItem from a SPList That contains a Lookup Field. How do I do to get the SPFieldLookup object from this item? I need to get the other fields from this object an not only the title.
1
vote
2answers
3k views

How to add grid lines to display form of a list item

I am trying to figure out how to make my display item form look like a table. I am using SharePoint 2013, and currently, the display form can be a bit difficult to read without lines separating ...
0
votes
0answers
22 views

Update list B when an update occurs in list A using event receiver

I have a Last A as Master list and List B as Slave List. Slave list is kind of back up list for List A. Whenever we add item to List A, the same item is added to List B, I achieved this action by ...
1
vote
2answers
106 views

Latest unique item from a SP list column

I have a SP2010 list.This list has a choice column. I want to create a view with the unique items(latest one) from this column. How to achieve this?
2
votes
1answer
43 views

SharePoint 2010 keywordQuery

I am using the keyworkQuery class to fetch some items from a Sharepoint 2010 list. I need to fetch also the Attachments for each item how can I do?. I tried: KeywordQuery kw = new ...
1
vote
1answer
145 views

Item Field returning value with hash character in Itemupdate

I am trying to get value of item field from the list. The field is a lookup field with integer value. When I am trying get the value it is coming like 9;#9 (shown below). But I need only 9. ...
1
vote
2answers
141 views

Sharepoint list items getting auto modified

Sharepoint list items getting auto modified. All the lists seems modified by a single user. But when checked with the user, he hasn't accessed this list at all. And the modified time stamps are all ...
1
vote
1answer
2k views

SharePoint 2010 - get list item from search result

I'm using FullTextSqlQuery to search items on specific list. Query returns results properly. Now I'd like to get SPListItem from search results. As I searched Internet, I found couple of examples, but ...
1
vote
1answer
277 views

Choose (select) person or group from sharepoint list column

Is possible to create a column to populate users and select them using AD group. I know we have person or group column which we can type. But I am looking by selecting from the dropdown list. How to ...
0
votes
1answer
114 views

Assigning a lookup value field, passes through as a blank string

I've currently got a new task list item for a certain content type (DMR) which fails to take through the lookup to the associated list. The statement prints the correct record number in the immediates ...
0
votes
1answer
32 views

Iterating through list items by name

I have a conditional statement that uses named columns of a list item. Eg. Stage 1, Stage 2, Stage 3.. Is there a way that I can iterate through them to satisfy the problem I'm having when stating the ...
2
votes
2answers
863 views

Basic question: Difference between List.items and List.ItemCount in SharePoint

Just for clarifying, I have written following two lines in Powershell script and see output as: $web = Get-SPWeb http://intranet; $list = $web.GetList("documents"); $items = $list.items; i see ...
6
votes
2answers
2k 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 ...
0
votes
1answer
41 views

Change Document content type by link to document

I've a document library and i've to delete document to replace it by a link to an external url. So i thinked to add a content type "link to document" Make a script client to change content type of my ...
0
votes
1answer
19 views

Delete document but keep meta

I've a document library with a lot of documents. The documents are in an other program and we 'd like remove the document from sharepoint and replaces by a link to the document in the other program. ...
0
votes
2answers
3k views

Update people or group field of sharepoint list C# code

I have a console app, it updates people or group field of sharepoint list. If the item["Approver"] value is a user value this app works fine. If the item["Approver"] value is a sharepoint group this ...
1
vote
1answer
306 views

How to check if the workflow can be started on SPListItem?

I have created a custom action for starting the workflow on list item. When user selects the item, an item from ribbon is enabled to start the workflow directly on item. I have created on application ...
1
vote
1answer
154 views

How to open SharePoint list row in own HTML page JavaScript?

I have a SharePoint-Hosted app with a survey with textareas and radio buttons. The textareas and radio buttons are connected with columns in a SharePoint list so the user is filling in all boxes and ...
1
vote
0answers
70 views

Sharepoint creating poco class from listitem [closed]

Is there a free tool for creating POCO class from list item ?
0
votes
1answer
648 views

Which of these is the best way to get a list item collection?

Performance-wise which of these methods is the best way to get a list item collection, and why? SPList list = web.getlist("listurl"); SPListItemCollection items = list.getItems(query); ...
1
vote
2answers
410 views

delete sp.listitem in client object

I've an issue to delete document in a document library. I did not get any exception but document is not getting deleted clientContext.Load(oldItem.File); oldItem.DeleteObject(); oldItem.Update(); ...
1
vote
0answers
69 views

how to add a link in a meta text multiline

I've a document library and inside a column multiline text. I've to set a link to an url. I've tried to set my item with. item["col"] = "<a href='myurl'>link</a>"; Sometime it works ...
0
votes
1answer
150 views

How to import term in TaxonomyHiddenList

As i'm in sharepoint 2010 and in sandbox solution, i can't use taxonomy field. I've created a new term store and i'd like import them in in the list TaxonomyHiddenList Like this, i'll be abble to do ...
1
vote
0answers
42 views

Sharepoint 2010 Adjusting lists limits to recomendations

I have huge list, which has too much fields of same type (e.g., Date and Time fields limit in list is 8, of that type I have way more). If those those limits are exceeded, list item data will be saved ...
3
votes
7answers
7k views

ArgumentException when trying to access SPListItem value

I have a tool to update all items in SP (link replacement). The tool works most of the time but sometimes it throws me an ArgumentException ("Value does not fall within the expected range."). Here is ...
0
votes
4answers
3k views

OfType<SPListItem>() says SPListItemCollection does not contain a definition for OfType()

I'm using Linq to SharePoint rather than CAML to query list data from SharePoint. See the code I have written: SPList productsList = SPContext.Current.Web.Lists["Products"]; ...
1
vote
1answer
2k views

List ItemUpdated Event not firing when updating item from code

I have a problem with my eventreceiver. It is set to fire on updating item from a list, and works very good when I update that item from Sharepoint's web UI. However I have some code that goes through ...
0
votes
1answer
381 views

SPFieldCollection TryGetFieldByStaticName bug?

I had expected that if TryGetFieldByStaticName succeeds and returns a value, there would be an SPField in the item that has a static name equal to what I used in the TryGet... call, but no? I.e. can ...
0
votes
2answers
1k views

Adding items to SP Folder inside document library

I have a folder inside a document library. Inside this folder I need to check the existence of a sub-folder and then, add a document and another folder to it programmatically. Lets say, my document ...