Rows of items containing columns of information.

learn more… | top users | synonyms (1)

29
votes
7answers
15k 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.
8
votes
4answers
16k 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 ...
9
votes
2answers
12k 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 ...
10
votes
4answers
29k 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 ...
7
votes
5answers
27k 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 ...
4
votes
2answers
7k 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?
10
votes
1answer
6k 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 ...
5
votes
7answers
21k 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 ...
2
votes
1answer
5k 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
10k 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?
3
votes
4answers
23k 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
2answers
286 views

Possible to specify the GUID when adding a List to a SPListCollection?

I found this documentation which goes over how to add a list, but it doesn't seem possible to specify a GUID if you use this method. Is there any way to create a list and specify the GUID? I am ...
0
votes
1answer
141 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
20k 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 ...
2
votes
2answers
5k 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?
1
vote
2answers
471 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 ...
7
votes
3answers
6k 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 ...
6
votes
3answers
9k 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: ...
6
votes
5answers
5k 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 ...
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?
2
votes
4answers
3k views

Possible to save a list template and maintain lookup relationships?

My issue is that I have two lists that I would like to move with their data. While I am able to save both as templates and then upload to the new site, none of the lookup columns in my parent table ...
4
votes
2answers
3k 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 ...
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
7answers
5k 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
2k 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
1answer
1k views

How to get approval status of a list item as a column to that list?

I have a Calendar list and an approval workflow. The workflow is initiated when a new item is added. The event gets approved in the task list. I want to get that "Outcome" column to the list. But when ...
1
vote
3answers
4k 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
195 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
541 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
7k 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 ...
15
votes
4answers
28k 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 ...
7
votes
2answers
890 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 ...
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 ...
5
votes
5answers
9k 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
11k 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
3k 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
1answer
4k 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

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 ...
2
votes
1answer
1k views

CQWP - dynamically setting the list

I have a Webpart that extends the content query webpart, that is currently pointed to List X. On the click of a button I want that webpart to be changed to point to List Y. This seems like a very ...
1
vote
1answer
660 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 ...
0
votes
1answer
9k views

The property or field has not been initialized. It has not been requested or the request has not been executed

I am getting this error and from what I understand this is when you try and access columns from the list item. I have tried various things including the line below: clientContext.Load(items, eachItem ...
6
votes
3answers
386 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.
4
votes
1answer
532 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
7answers
11k views

How to delete all items in a List using PowerShell

I am using following PowerShell script to delete all items of the List. It's working fine but take too long for huge lists. Is there any efficient way of clearing list items, something like truncate ...
4
votes
1answer
3k views

sharepoint 2010 Retention Policy not working?

I have created one simple document library and want to enable a retention policy for that, for this thing I have created one document library and have navigated to following steps: 1) Document ...