Rows of items containing columns of information.

learn more… | top users | synonyms (1)

3
votes
1answer
2k views

How to determine the List Template (SPListTemplate) that was used to create a list?

I am using the following code to create a custom list from a custom list definition. Is there a way, after the list is created to determine which definition it was created from? SPListTemplate ...
3
votes
2answers
3k views

Sharepoint External Data field with multiple values

I need to create a list column which contains external data (from BDC). The field has to contain multiple values. But I haven't found a way how to make a external-data-field take multiple values. ...
3
votes
3answers
27k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
3
votes
2answers
3k views

Is it possible to limit the visibility of list items to not only just me (the author), but anyone from my company too?

I have a custom list on a SharePoint 2010 extranet site which users from various external companies can add items to. The list's Permission Settings page allows you to make all items visible to all ...
3
votes
4answers
7k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
3
votes
3answers
1k views

Creating email subscription service via SP 2010

Is it possible to create an email subscription service in SharePoint 2010? We have an ASP.NET app where users sign up to receive a bi-weekly newsletter. Our SharePoint installation is currently ...
3
votes
2answers
1k views

How many workflows can a SharePoint 2007 Library / List contain?

What is the maximum workflow can a Library & List in SharePoint 2007 can have? Information in http://technet.microsoft.com/en-us/library/cc262787.aspx mention that SharePoint 2010 can have 15 ...
3
votes
3answers
3k views

How can I use Powershell to move a list from a development to a production Sharepoint 2010 box?

I'd like to copy a list (and its contents) onto our production server. I've been trying to use the Export-SPWeb cmdlet, using this article as a reference, but I can't seem to get it to cooperate. I've ...
3
votes
2answers
2k views

Can I access the service definition for the web service for a specific SharePoint list?

I have a problem accessing the web service ?wsdl for SharePoint lists, although I can see the list of operations. For example, for the following URLS: http://team/sites/test/_vti_bin/Lists.asmx - ...
3
votes
2answers
149 views

Remove comma (thousands seperator) in number field without using calculated item

Is there a way to achieve this without adding a calculated item with this format = TEXT([Customer Number], "0") ?? I'm using sharepoint 2013.
3
votes
2answers
53 views

Can you have multiple Excel worksheets for one SharePoint List?

I know you can create a table in Excel and export that into SharePoint as a list. I want to know if you are capable of having two or more Excel files updating a single SharePoint list. We want two ...
3
votes
1answer
963 views

How to get SharePoint Online list url using Powershell?

I can retrieve a title $list.Title, but a title is not the same as url. In C# I can get list.DefaultViewUrl, which doesn't seem to be an option in Powershell. I found this solution with ...
3
votes
5answers
11k views

Is there a way to duplicate or copy a list into the same site

So here is my problem. I have a site collection. In this site I have a list (ListA) that has lots of columns and lots of attachments and lots of items and over the threshold. I would like to create a ...
3
votes
1answer
93 views

Identify List Template (stp) from SPList Object

I have custom list templates (stp) based on Generic List template. I have created several lists using stp files. How can I identify from which list template (STP file) the List was created. The ...
3
votes
1answer
2k views

SharePoint Lists web service UpdateListItems not updating items

I developed a MS Excel-AddIn with a WPF User Control to display and update MS SharePoint List Data. I used Lists Web Service to communicate with the list data. I can load list data to my Excel ...
3
votes
1answer
5k views

SP2010 Javascript REST API: updating list item using MERGE and POST

I am trying to use REST API approach in javascript to update a sharepoint list item where I have an id. So I use GET and POST to create records, but per MSDN article it looks like the way to do this ...
3
votes
2answers
2k views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
3
votes
1answer
2k views

Delete list items and bypass recycle bin

I have a list with about 15,000 items and I need to empty it by permanently deleting everything in the list. I have other items in the recycle bin that I don't want to disturb. Here's the script I'm ...
3
votes
1answer
179 views

Apply formatting logic before rendering field in SP list

I am relatively new to SP development; I am trying to do the following in SP 2010: I have a list field containing e-mail addresses separated by semicolons. I would like to insert a newline character ...
3
votes
1answer
2k 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?
3
votes
3answers
900 views

Unneeded DIVs added to content

Why does SharePoint add the following to text entered into rich text fields of list items? <div class="ExternalClass85AC900AB26A481DBDC8ADAE7A02F039"><p>....</p></div> We've ...
3
votes
1answer
88 views

Creating a view in SharePoint 2010

I have a ticketlist which has ticket_id for 2 different locations, tickd1,tickd2,tickd3,tickd4 for Dallas ticka1,ticka2,ticka3,ticka4 for Atlanta Now I am trying to create 2 views, one for ...
3
votes
2answers
2k views

Create list using a Workflow

I have a list of projects called "Project Reference." I want to create a new project list (for project tracking) called "[Project Name] Tracking" when someone adds a new project to Project Reference. ...
3
votes
4answers
3k views

Cannot change value in a choice column for some documents

In a hosted WSS 3.0 environment I have a standard document library with some extra columns. For some reason I cannot change the value in a choice column (called: "Status"). The value always is reset ...
3
votes
2answers
1k views

Web Service UpdateListItems User Permissions

I'm trying to do an AJAX SOAP call to the Lists web service, specifically UpdateListItems. The query isn't malformed, and is working appropriately when using a user with full permissions. When a ...
3
votes
2answers
427 views

How to dump and XML file from a Workflow

I would like to dump an XML file to a specific location based on a workflow. Whenever someone creates an element on my list I want to create an XML file and save it to a disk location. Any good ideas ...
3
votes
2answers
5k views

Updating a List Instance

I have a List Instance in Visual Studio. However, every time I deploy the solution, Visual Studio says there is already a list instance with the same URL on the site collection and it needs to delete ...
3
votes
1answer
484 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 ...
3
votes
2answers
4k views

Silverlight unhandled exception on AddGallery.aspx

I try to create a new list in SharePoint 2010 with AddGallery.aspx and the Silverlight app gives me An unhandled exception occurred in the Silverlight Application right when I click the "Create" ...
3
votes
4answers
2k views

Content deployment - synchronizing lists in two environments

I'm working on a project with a typical scenario where authors are maintaining content on internal network (let's call it InAuthoring) and uses "content deployment" feature to flush the content to ...
3
votes
2answers
269 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 ...
3
votes
1answer
47 views

How can I get a listitem/page related resources from code behind

In the GUI it is possible to get the resources used by a page as shown by the image. Now I would like to get this information in the code behind so that I can modify only pages that are using a ...
3
votes
1answer
196 views

change NavigateForFormsPages value to true using CSOM

I'm searching for a way to change NavigateForFormsPages property using CSOM but no luck till now. Anyone has idea to do it using CSOM
3
votes
2answers
557 views

Dealing with Person column when someone leaves the organization?

We have a list which has a person (people picker) column. This column pulls from (is validated against) several possible sources including Active Directory. If a name cannot be found when ...
3
votes
1answer
600 views

Get distinct values via mechanism used when clicking “Show Filter Choices” on a Sharepoint list using Javascript

As many other people on this site seem to need, I'd like to get an array (or equivalent) of the distinct values in a field for a list. The canonical way of doing this is to retrieve the entire field ...
3
votes
1answer
62 views

Downloading Problem

we have requirement where we are downloading huge data in GB's. i have created powershell script which works very fine for Normal download of document library whose list threshold values not exceeded. ...
3
votes
1answer
681 views

How to Update “Created By” column through workflow?

I am trying to make the Blog comments and discussion replies to be Anonymous. The only way to do this (a simple way) is through hiding the created by column in the view. Is it possible to update the ...
3
votes
2answers
1k views

How to move/copy items from one custom list to another custom list without Designer?

I'm a guest to the site and after seeing the great quality of Q&A's believe it's worthwhile to 'put this out there' in the event anyone may be able to assist. Brief background: I have ...
3
votes
2answers
131 views

How can I identify columns independent from language?

I've got a webpart which reads several values from a list, while developing local I've got a column "Due Date", but when I upload my webpart to SharePoint online (Office 365) we have a German version ...
3
votes
1answer
10k views

How to retrieve all items from a list (with custom fields) by javascript object model

I need to get all my custom fields from my list by Javascript Object Model.. The code I wrote down is this: var items; $(document).ready(function () { ...
3
votes
5answers
21k views

How to remove default columns from a custom list?

Is there any option to remove default columns(eg: Created By, Modified By) from a custom list? I do not want to hide the columns for a view, but I need to entirely remove/modify the default columns. ...
3
votes
2answers
69 views

Architecture: How do you store single pieces of information?

I am building a solution in which each Site Collection represents a single contained unit. The members of that unit will be using SharePoint to track information that describes their unit at the root ...
3
votes
3answers
4k 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 ...
3
votes
1answer
288 views

How to pull the total # of items from one sharepoint list as a column in another list?

The site has a list (List A) that links to multiple comments lists. For each item in List A, a unique list exists to capture comments related to that item. Users want to know how many comments have ...
3
votes
2answers
2k views

Drag and Drop SharePoint List by row for change items order

I have problem in one of my project. Requirement is it be able to drag and drop items in list to change their order. I try with HTML5 http://msdn.microsoft.com/en-us/magazine/hh852596.aspx but i did't ...
3
votes
4answers
16k views

Display List or Library on another site as WebPart?

I want to display my list on another site in same site collection. I edit List with SPDesigner, select the view and save it to site gallery. After these steps, I added the view webpart on my another ...
3
votes
2answers
911 views

Document Library Permissions being bypassed when using “Open with Windows Explorer”

SharePoint 2007 Document Library has permissions set for user A to "Read". User A is able to go to Actions -> Open in Windows Explorer and delete files. This seems like a very large security loop ...
3
votes
1answer
328 views

Trigger a workflow when user added to permission group

I'm not sure if this is even possible so here goes: I have a calendar list. After creation of the list I will add a choice field to the list in an event receiver where the choices will be the email ...
3
votes
1answer
8k views

How to filter items in a list that have a specific date that falls in last, this or next month?

I want to show only items with a specific date that falls in last, this or next month? For example: If today is the 7/13/2010 it should show only the items between the 1st of June and the 31st of ...
3
votes
4answers
962 views

CQWP Link to List Item

I cant seem to get my custom CQWP to link to a list item. If i look at everything exposed in the CQWP (using the showxml trick) the only thing close is the LinkURL which takes the format ...