Rows of items containing columns of information.

learn more… | top users | synonyms (1)

4
votes
2answers
2k views

CAML: Possible to query non existing field?

I'm using SPSiteDataQuery to fetch list contents from 2 different lists. List A) has the fields CustomField and Title List B) has only Title Is it possible to build a (filter) query with ...
4
votes
3answers
3k views

How to get visible SPField's for a specific list view

I am trying to enumerate a list based on a selected view - basically, programmatically doing what is visually shown when viewing a list. I will be using this to output a file, so I am first getting ...
4
votes
1answer
12k views

Calculated field Date formula

I have a date field, and it has the date in the format - 11/2/2011 11:40 AM How ever my requirement is to get the date in the format - 02 Nov 2011 11:40 AM For that I created a calculated field for ...
4
votes
4answers
238 views

Possible to create a column that users can upload an image to?

I'm trying to create a column in a list that users can upload a picture to. I found the Hyperlink or Picture, but this requires that users specify a URL for the image. Is there way to create a ...
4
votes
1answer
15k views

Make another column linked to item with edit menu in sharepoint 2013 list

How can I change the column in a SharePoint list that has the link to the item and the link to the item with edit menu Ex: I currently have "Area" that is (linked to item with edit menu), but I want ...
4
votes
2answers
2k views

How do I programatically change the default value of, or remove from default view, title column using javascript?

Using the JSOM in SharePoint 2010, if I am creating lists programmatically using something like: this.myField= oList.get_fields().addFieldAsXml('<Field DisplayName=\'Key\' Type=\'Text\' />', ...
4
votes
1answer
1k views

Error using javascript to retrieve a SharePoint list's items

I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...
4
votes
1answer
1k views

Change URL description programmatically in list C#

I have this list with artists that I manipulate with C#. I can get all te values of the list with this code part and change SPListItem listItem = properties.ListItem; SPWeb artistWeb = properties.Web;...
4
votes
7answers
317 views

Permissions for List or Library Columns

Is there any way to give permission to a specific field of a list or library? I want one of my users for example cannot add or edit data in a specific column. Can I set permissions to the form and its ...
4
votes
3answers
12k views

How do I populate a SharePoint list from a SQL table?

I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.
4
votes
1answer
8k views

Add New List Item with SPServices anonymously

I have an HTML5 + jQuery application with a built in contact form that I wanted to hook into Sharepoint, and Lists seemed an ideal way to do that. I used the jQuery library SPServices to get this up ...
4
votes
2answers
9k views

how to give Role permission to list programmatically?

I have set my web permission to Inherit Permissions as well as Lists.and programmatically i have add SPUSER to web with assigned 'Restricted Read' access Role. and also associate SPUSER to List1 ...
4
votes
3answers
964 views

What options are available to me to find lists that were created using a specific list definition?

I have many lists, some of which were created using a custom and now-obsolete list definition. I need a programmatic way of finding out which lists were created using that old definition. Currently ...
4
votes
1answer
2k views

dropdown box on change event in SharePoint list forms

I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I ...
4
votes
1answer
1k views

powershell not finding shared document library?

There is a document library called "shared documents" in the site I type at the prompt when running this script. The script returns the titles of several document libraries, but not "shared documents"....
4
votes
2answers
3k views

Remove list instances upon feature deactivation

I have a feature put together in Visual Studio 2010 that creates 3 external list instances. These get created just fine when the feature is activated, but upon deactivation they remain on the ...
4
votes
2answers
145 views

Deleting Content type from “List Items” using Powershell

I want to delete a custom content type from all items that are using that content type in a list/library. Is that possible using powershell? if yes, then I want to know after deleting CT, which ...
4
votes
2answers
881 views

Camlquery: Getting items from top root folder of list

I know how to get items from a folder inside a list (example below) CamlQuery caml = new CamlQuery(); caml.FolderServerRelativeUrl = "/folder/path"; But how do you get the items from just the top ...
4
votes
2answers
2k views

Site Access request error for site owner “Request Approval Failed”

I have a user who is listed as a site owner on the site with full control. User also has full control permissions to access request list. Now when he goes to Pending request page and tries to approve ...
4
votes
1answer
3k views

how to iterate through all folders inside subfolders of root level folders

below is the code to iterate through root level folders which downloads folder starts with "a" and download sub folders from it starting with any letter. I want to download all the folder levels and ...
4
votes
3answers
2k views

JSLink override fields - can I gain control over TD?

I have an external list, I'm modify fields using: SPClientTemplates.TemplateManager.RegisterTemplateOverrides(context); Basically this modifies the text inside the TD (see code below) <td class="...
4
votes
3answers
30k views

Create Custom New Edit and Display form for sharepoint list

I am new to SharePoint and I have created several custom lists. I would like to use visual studio 2010 to create new EDIT/NEW/DISPLAY forms for this list. I can't seem to find anything on the internet ...
4
votes
1answer
236 views

Tracking User Activity for badges

I'm creating a QA site similar to Stack Overflow on SharePoint. I'd like to be able to integrate some badges into the System. I've thought of a few ideas, but I'd love some divergent thinking on ...
4
votes
1answer
491 views

SharePoint 2010 - Modified Calender View

I want to filter the Calender in my SharePoint 2010. All Items with a Enddate older than 7 days must be hidden. I found no way to modified the Calender View to filter the elements because the field "...
4
votes
1answer
4k views

How to get ALL list items regardless of view using Lists webservice

I have a list with only one view exposed on it (default view). That list has a filter with a field Assigned To = [Me] so all users logged in can only see their own list items. This list items get ...
4
votes
1answer
3k views

Workflow not triggering on new item in e-mail enabled list

A simple workflow with only one step, update column, is set to "start on new item" on a E-Mail enabled list. When we send an email to the list, the email gets processed and a new item is created but ...
4
votes
3answers
86 views

Announcement strips domain name from link

This is a weird one. So I post an announcement in an announcements list. In the message body I create a link that points to a document library and am sure to include the domain name in the link. ...
4
votes
2answers
95 views

2010 - List Permissions, Allow Add but restrict View

I made a Contact Us List on my Sharepoint because there is no Webpart for 2010. People can Click a link in my mainpage, and they directly get to the add form of the list. Now I want to restict the ...
4
votes
1answer
4k views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
4
votes
1answer
3k views

Help converting XmlNode to DataSet/DataTable, from SharePoint Web Services, Lists.asmx

This is my first post here, but used this site a lot :) My question is how I can convert an XmlNode, obtained through the Lists.asmx SharePoint web service, to a DataSet / DataTable. The reason I ...
4
votes
3answers
5k views

error activate feature list template/instance in site definition

i've created a SiteDefiniton project and a Sharepoint ListDefinition project. In the SiteDefinition I created a listinstance of my template, but in deployment the activation of the ListInstanceFeture ...
4
votes
4answers
2k views

Issue tracking only see issues you created

Is it possible to make an issue tracking list only allow users to see the issues they have created? Normally under list settings I would do this under Advanced Settings but that option does not seem ...
4
votes
2answers
215 views

Go to specific page in large list

I got a list that have about 200 items and growing. Is there a way to navigate to a specific page of that list? Something similar that are on forums all over. Or a dropdown? We are using Sharepoint ...
4
votes
3answers
538 views

How can I get two List Items using one Caml Query?

I need to get data from two customs lists that I created. However only the first list item is queried allowing me to use the data in the Home Page list item only, but I need both. var listItems; var ...
4
votes
1answer
240 views

Employee Birthday Reminder

I have SharePoint Online and I have custom list for employee profile information. I need to create workflow to send me/or HR Dept e-mail reminder before employee birthday by (x) days. How can this be ...
4
votes
3answers
501 views

How do I create a list from a template and create all views with Powershell?

I am trying to imitate the process of creating a list from a template in the UI by using a Powershell script. When you create a list from a template with the UI, all of the original list's views are ...
4
votes
3answers
722 views

Soap + Rest: Trying to understand differences for selecting fields between the two

I'm working on a Java-Application that integrates with SharePoint. The different SharePoint services are currently requested via the SOAP API. I am now working on an abstraction layer to also ...
4
votes
4answers
3k views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
4
votes
1answer
658 views

Search list with appending text field history

I have a list with several thousand items in it. The list has a text field called "Actions" that is set to "append changes to existing text". This field is used to record details of actions taken. ...
4
votes
3answers
1k views

How to check membership from current user and set readonly of some fields when override ListFieldIterator?

I have created a custom ListForm template and overide the ListFieldIterator. I have for example 10 fields in my content type. 5 of these 10 fields must be shown for the creator of the item. The ...
4
votes
1answer
726 views

SharePoint 2010 list vew schema - View element

guys, I am trying to understand list schema view. For example AnnouncementsList contains in schema 3 views: <View BaseViewID="0" FreeForm="TRUE" Type="HTML" MobileView="TRUE" TabularView="...
4
votes
1answer
518 views

SharePoint List View Threshold Error on Delete and Re-load of Data

Foremost, I am not an administrator of SharePoint site and have very limited controls on my page. Earlier, I had created a list (custom list with Datasheet view). I had created over 20 views (one ...
4
votes
1answer
207 views

Add a Three-State Workflow by Code?

I want to add a three-state-workflow to a list. I know how to add this via Designer but - to keep manual works low - I want to achieve the same goal by Code. This is what I need: Add a three-...
4
votes
1answer
1k views

Declarative OnQuickLaunch property not working in SharePoint 2013

I have a question about the OnQuickLaunch property in SharePoint 2013. I've created a new SharePoint 2013 project in Visual Studio with a document library List instance in it. All I have is an ...
4
votes
1answer
120 views

formula to limit date entries to specific month

In my "time off" custom list I have start date and end date. I want to make the user splits up the entries if the time off spans months. In other words if the entry starts Oct 25 and ends Nov 5 I want ...
4
votes
1answer
2k views

How I can block to change view in list SharePoint Foundation

How I can block change view in ShrePoint list?Even when I add user Read Only permission to some list, person be able to change view in this list. I want to block change view but I don't know how. I ...
4
votes
1answer
4k views

Export list to excel with filters?

I have a list with the setting that a user can only read/edit items they have created themselves which works fine, however, if they click Export to excel (which they should be able to) then all ...
4
votes
1answer
143 views

Force user to enter a column in the list

When ever a user changes a particular field in a SharePoint List, Can I force the user to enter another field? For example, I have got two fields, lets say A and B. When ever a user changes / update ...
4
votes
1answer
4k views

Exception from HRESULT: 0x80131904 - when using Custom List Forms

Can anyone help ? I run into a strange problem. I have a custom List designed in Visual Studio 2010 with Custom Content Type.When I add Item to the list using default forms everything works ok. ...
4
votes
1answer
2k views

Failed to find the list schema for FeatureId list template ID 10000. Cannot create list in web “at URL ”Lists/ListTest"

I am trying to create a SharePoint list declaratively but I have the error above. According to this site I should put the feature id on the list instance xml definition, but after doing it, the error ...