Rows of items containing columns of information.

learn more… | top users | synonyms (1)

21
votes
4answers
9k views

Deleting all the items from a large list in SharePoint

What is the most efficient way to delete all the items of a large list in SharePoint? The code should take Query throttling limits into consideration.
7
votes
4answers
12k views

How to submit data from repeatable table in infopath form to a sharepoint list?

I have a infopath form created from a sharepoint list content type. In this form I need to add a repeatable table to send data to another sharepoint list. So when people submit this form the original ...
7
votes
5answers
18k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
9
votes
2answers
9k views

Show custom action in ribbon for only one list

Does anyone knows how to show a custom action in the ribbon for only one list? At this moment I've got multiple custom lists, but my button is added on all of them. I only want to show it on one ...
4
votes
2answers
5k views

Using Default List Forms for Edit & View

Is it possible to configure a SharePoint 2010 list to the default form for editing and viewing while displaying my custom InfoPath form only for new items?
2
votes
1answer
4k views

Dropdown lookupcoloumn in sharepoint list form (newform.aspx)2010

I have a dropdown lookupfield in newform.aspx sharepoint form...unlike choice dropdown the lookupdropdown is 'input' field and not 'select'.. so i raise an onchange event using jquery ...
3
votes
6answers
7k views

List 'add new item' link at top of list

The 'add new item' link which is always located at the end of the list. Is there a way that we can add a similar link at the top of the list?
8
votes
1answer
3k 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 ...
3
votes
3answers
14k 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 ...
1
vote
2answers
390 views

Create security field

How can I implement security field for SharePoint list? For example, the list should have field that contains salary. This field should be displayed for the Managers, but should not be displayed ...
5
votes
3answers
7k views

Best method to create custom NewForm / EditForm

I am new to sharepoint development and need to create some custom NewForm/EditForms for a new custom list I am creating. It seems like I have two choices: ...
3
votes
4answers
19k views

Is setting permissions on views now possible?

In the previous SharePoint version of SharePoint you couldn't have permissions on list views. Is this now possible on SharePoint Foundation 2010? So for example I have a list and 2 views but I want ...
2
votes
4answers
2k views

How can I Make a Dropdown box in a Form Field Conditionally Read-only/locked?

I have a drop down box form field (with values level1,level2) in SharePoint list. How can I lock the drop down box selection in the edit form.aspx whenever the condition is level2?
5
votes
3answers
16k views

Change Title (linked to item with edit menu) to different column

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 eg: Title (linked to item) Title (linked to item with edit menu) I want to have ...
4
votes
2answers
3k views

SharePoint Lists' EditForm & DispForm

I haven't been able to find any information regarding this, so I hope you guys can help me out on this. Since all lists in SharePoint all have an EditForm.aspx and a DispForm.aspx I am wondering if ...
3
votes
2answers
2k views

All versions of one item in list

Is it possible to see all versions for one item in SP list a different way than through version history? We have one extensively used list with 100, 130, 150... with a lot of (multi-line and rich ...
3
votes
6answers
4k 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 ...
2
votes
1answer
1k views

Which view is the “Current view”?

I have got a SharePoint 2010 website with a WebPart-page and a few WebParts on it. One of the WebParts displays a list/a view of a list. The views of that list have been updated due to business ...
1
vote
3answers
3k views

IMporting all Contacts from OUtlook Public Folder into Sharepoint list?

What is the best way to import all contacts from outlook public folder to a sharepoint contacts list? We have about 3000 contacts and I understand going over 2000 items in a list hits performance. ...
1
vote
3answers
183 views

List Security in Sharepoint

I need to set permissions for a list that looks like this: I have two different teams, each with a team lead and 3 team members. The team members should not see each others data. Team leaders have ...
0
votes
3answers
514 views

How can I set a field value in a display form when a list item is first read?

I have a list with multiple columns. This list may include multiple records. I want the value of a specific field to be changed when a special record is read for the first time.
9
votes
5answers
5k views

Which is the easiest way to migrate entire List to a new new site?

Hi I need to migrate a list with 800+ items to a new location but within the same site collection. Which is the easiest way to do it. I want it to be a exactly same with all data, attachements etc ...
8
votes
2answers
2k views

How can I create an Entity Relationship Diagram for SharePoint lists?

I'm trying to design/document a collection of lists with lookups in an Entity Relationship Diagram. Currently I'm using Visio's built-in ERD template, which is most of the way there, but it lacks two ...
6
votes
2answers
448 views

Anonymous access: Add an Item to List without allowing to View the List

I'm creating a 'Contact Us' webpart with form to allow anonymous user to send a message which will be added to a SharePoint List. However I cannot grant the anonymous user the permission to Add ...
5
votes
5answers
7k views

What's the best way to move a list from one site to another?

I know you can backup site collections with stsadm -o backup, and you can backup sites with stsadm -o export. But what's the best way to copy a list. I've tried to use the save as a list template and ...
2
votes
3answers
8k 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 ...
4
votes
3answers
2k views

How to add event receivers to all the lists in a site collection?

What is the best practice around adding event receivers across all the lists in a Site Collection?
3
votes
2answers
1k 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 ...
6
votes
3answers
289 views

Filter out folders from a user alert against a list

I have created an alert for a user against a list (more specifically, a document library). I want the user to be notified of all changes regarding list items (documents) and not any sub folders. ...
6
votes
2answers
3k views

Renaming Title Column in SharePoint List Definition

I am defining a custom list content type for SharePoint (using VSeWSS 1.3 and schema.xml). I want to change the display name of the default title field ('Title') to 'Serial Number': <Fields> ...
5
votes
1answer
2k views

Is it possible to return only the count of the query?

Is there any way to return only the count of the rows from a Sharepoint query? I would like to get only the count of the result returned by sharepoint query.
5
votes
5answers
4k views

SharePoint List Item Permissions

Does anyone know of a way to implement permissions within a SharePoint list so that items are only visible to the person who created it (or potentially who the list item is "assigned to", as in like a ...
3
votes
1answer
2k 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

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
3
votes
1answer
214 views

Best Practice to handle items modification in SharePoint 2007

From my understanding, there is no checkout function inside a SharePoint 2007 List. So, what is the best practice that SharePoint Professionals and Expert do to make sure that a item of a SharePoint ...
2
votes
4answers
4k views

Design Workflow that Emails People in Assigned To (Except for Created By)

We have a custom list that tracks work tasks in our department; we track our own work and use it to assign work/tasks to other colleagues. I have a people/groups column called AssignedTo and need a ...
2
votes
1answer
462 views

How to count number of finished tasks over total tasks in a sharepoint 2010 list to display in KPI

My problem is this: I need to create a dashboard/kpi in SP2010 that will show the progress of a certain project. The progress should be counted via the number of tasks/milestones completed in the ...
2
votes
1answer
3k views

custom attachment field in List

I would like to know, can I create a custom attachment field in a list. I know I already have one attachemnt field in the list, how ever I would like to have one more field, where I can attach files ...
2
votes
1answer
1k views

Visio Diagram link to SharePoint 2007

May I know what are the steps to create a office layout inside Microsoft Visio Diagram, then link this Visio Diagram to SharePoint List, such that when my mouse hover at a particular location in the ...
2
votes
1answer
856 views

“Access denied” while loading the BCS list from the database

I have tried to display data from SQL Server to a SharePoint page through BCS services using SharePoint 2010 designer. While loading I am getting this error: Access denied. You do not have ...
1
vote
1answer
108 views

How exactly do SharePoint 2010 List Views behave?

I was under the assumption that once I create a list, I can drop it on as many sites/pages I wanted and they would behave as views of the original list and stay in sync. In other words, If I were to ...
1
vote
1answer
730 views

How can I configure a View filter/index to go around the item threshold?

I have a list with 8000 items. The item limit is 5000 items, so I got this error on the "All Items" view: This view cannot be displayed because it exceeds the list view threshold (5000 items) ...
1
vote
2answers
777 views

Any way to only include a particular page (such as DispForm.aspx) in Search Results?

I'm trying to create a search scope in SharePoint 2007 that searches all lists in a given site. But I want the results to only include the actual list item itself, not the all items form or anything ...
1
vote
2answers
1k views

Retrieving a lookup Value from a List using jquery and REST

I would like to get the lookup Value from a List item depending on it's Title. My List is set up similar to the following example: ColumnA : a | b | c lookupB : 1 | 1 | 2 The jquery: function ...
1
vote
2answers
2k views

How to disable new/edit/delete of SharePoint list/library views

In our SharePoint portal we have some custom views defined for list and libraries. I have created the views using list event receiver. Now I need to disable the new/edit/delete views option from ...
0
votes
1answer
2k views

Getting items from rows 4-8 in a Sharepoint list using CAML query?

Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint: How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
0
votes
5answers
4k views

Export List in SharePoint 2007 to List in SharePoint 2010

I have a SharePoint 2007 list that I want to copy over to an existing SharePoint 2010 list. Both of them have the exact same columns. What is the best way to do this? I tried opening both of them in ...
7
votes
1answer
648 views

Where to load data in the lifecycle of custom webpart

I have a webpart where I access a sharepoint list and render contents of that list. At the moment I'm fetching the data in CreateChildControls(). When a button is clicked the data will be fetched ...
7
votes
3answers
8k views

How to delete the undeletable list

Somehow a developer has managed to royally screw up a site collection. The site collection has the Publishing Feature enabled and it's working fine. A botched migration from 2007 to 2010 has caused ...
6
votes
1answer
346 views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...