Rows of items containing columns of information.

learn more… | top users | synonyms (1)

22
votes
4answers
11k 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
13k 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
22k 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
10k 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?
3
votes
6answers
15k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
9
votes
1answer
4k 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 ...
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
8k 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?
6
votes
3answers
20k 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 ...
6
votes
3answers
4k views

ListInstance with predefined data, prevent adding records to list with same name on deployment

I have a feature which on activation has to create a list called Scanners. Only one column from the list (Title) is actually used in my app. The list needs to be pre-populated with some values. To ...
0
votes
1answer
29 views

SessionStorage caching when getting items from a list

SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady); var listTitle = []; var listUrl = []; var listIsActive = []; var listOrder = []; function sharePointReady(){ var siteUrl = mysite; ...
3
votes
3answers
16k 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
424 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
8k 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
21k 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?
4
votes
2answers
4k 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
3answers
1k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
1answer
2k 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
189 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
522 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.
10
votes
5answers
6k 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 ...
13
votes
3answers
23k views

Hide the “Add new Item” option below the sharepoint 2010 list

I have a sharepoint 2010 list, I want to hide the option "add new item" which resides below the list, any suggestions?
10
votes
1answer
4k views

Understanding Data Sheet view list better in SharePoint 2010

I would like to know more about the features of Data sheet type lists. Can I use conditional modification to the data sheet rows, for example changing the color if a column value equal 'X' ? Can I ...
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
605 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
4answers
9k 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
2answers
3k 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 ...
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 ...
1
vote
1answer
225 views

How to customize the XsltListViewWebPart?

I would like to have submission feature on the List List structure would be Mon-Fri is considered as a week, user would be asked to select the current week's Friday from the calendar. It ...
6
votes
3answers
331 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
3k 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
1answer
225 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
2answers
2k views

Hide/Show field on list form based on value from another field

I need to hide field 'B' when the value in field 'A' is NOT equal to 'Other'. This is a custom list form. Is jquery the way to go?
2
votes
4answers
5k 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
500 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
2k 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
954 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
114 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
1k views

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

I want to create a paginated view that shows me ALL the items, 30 items at a time. I have a list with 8000 items. The item limit is 5000 items, so I got this error on the "All Items" view: This ...