Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [list]

Rows of items containing columns of information.

11
votes
7answers
65k 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?
73
votes
11answers
56k 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.
37
votes
6answers
89k 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 ...
40
votes
4answers
119k 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 ...
17
votes
3answers
26k 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 ...
12
votes
4answers
33k 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 ...
2
votes
1answer
6k views

How can lists be made to support master-detail relationships?

It is often useful to have parent-child data when entering form data. Consider a typical job application. Under Work Experience you will add n number of entries each having a start and end date and ...
6
votes
5answers
11k 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 ...
3
votes
2answers
999 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 ...
2
votes
3answers
951 views

Calculate the average value of an array from sharepoint listitem

So I'm getting my listItems with a Camlquery, but i want to calculate the avg of the "price" rows This is the code I've used so far: function VisaLista() { namn = document.getElementById("...
25
votes
2answers
17k 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 ...
6
votes
2answers
23k 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?
15
votes
9answers
104k 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 ...
11
votes
1answer
31k views

Hide list column on new, edit item-OOTB

I have a SharePoint list. There I have created a new column "Department". I want to keep it hidden when adding new item and edit item. It should be visible in list view. No code base (OOTB).
10
votes
4answers
78k views

SharePoint 2013: “Find an Item” search box does not return results

We have 2 web applications, in one of the web application search is working properly and we are able to see search results from "Find an Item" box above the list name. However in the other web ...
8
votes
6answers
45k 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 ...
5
votes
3answers
20k views

How do I handle the large List with more than 5K items in SharePoint 2010?

Have developed a simple request tracking application on SharePoint 2010; it stores the info on the SharePoint List. I would expect ~100items / week getting stored on the root folder of the list(as ...
3
votes
2answers
5k views

Event Reciever run with elevated previledges

I created one event receiver and deployed it, but only users who are site collection admins are able to view this web part. I have included the SPSecurity.RunWithElevatedPrivileges but the same thing. ...
6
votes
1answer
9k views

Make CAML query with in rest api call

I have a SharePoint list and i need to get the list items by using JSOM.how to add CAML query with in the API method? i have used the below code var url = "/_api/Web/Lists/GetByTitle('list')/...
6
votes
5answers
15k views

Sort order issue

I'm having an issue sorting data in ascending order. Right now the sort order is: 1.0.0 10.0.0 10.0.1 11.0.0 2.0.0 2.0.1 3.0.0 3.0.1 3.1.0 What I want is: 1.0.0 2.0.0 2.0.1 3.0.0 3.0.1 3.1.0 10.0....
4
votes
2answers
4k views

SharePoint list views - different permissions for different views

I have a SharePoint list that is currently setup so that users can only see the items they create. What I'm wondering is if there's a way to create a view or duplicate the list or something for one ...
4
votes
1answer
14k views

Exporting item list version history

Okay, here is what I'm able to do: Export a list from SharePoint to excel. View an individual item's version history within the online SharePoint. What I am trying to do is export this version ...
3
votes
1answer
4k views

Calculated column with ID removes ID number on update

I'm using SharePoint 2013 and I have a calculated column in a custom list, called "Project ID" that has the following calculation: ="DS-000"&ID The first item in the list has the "Project ID": ...
2
votes
1answer
17k views

Display List View from Subsite on Parent Site

I've got a list setup on a HR subsite that keeps tracks of Scheduled Vacations for employees. I'd like a way to display a certain view from this list as a web part on the Parent of this site. I ...
0
votes
1answer
4k views

SP 2016 - Display list from Parent site in sub-site

I need to display a list from a parent (really the site collection) on a sub-site. I've found multiple answers referencing this link. However, this post is from 2012 and discusses a solution for ...
0
votes
6answers
270 views

Removing Duplicate Value in Rest Api

I have a small requirement where in i need to remove the duplicate values from the array that i am getting. Overview In the below code, what i am trying to do is to get top 1000 employee names(Should ...
7
votes
3answers
34k views

Sharepoint list column limit

We are designing a system where data from forms will be stored in sharepoint lists. Problem is there are many fields around (260). What is the better way to handle this ?
6
votes
3answers
40k 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 ...
5
votes
5answers
50k views

Filter a list view using URL parameters

I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...
6
votes
1answer
12k views

How to get all items with a specific content type using REST Api

There are five Custom Lists in a site collection, all have same content type. I would like to get all items from those five lists using rest api. Is there a way to get all items from all lists having ...
2
votes
2answers
7k views

Dropdown lookup column in Sharepoint list form (newform.aspx)

I have a dropdown lookup field in newform.aspx form. Unlike choice dropdown the lookup dropdown is input field and not select So I raise an onchange event using jWuery $(document).ready(function() { ...
1
vote
2answers
11k views

Using CAML Query to Retreive from Multiple Lists

I am creating an applicant tool which contains the following lists: Applicant; Applicant Answers; Job Questionnaire; Job Title The lists are related as follows: Applicant.ID = Applicant Answers....
7
votes
2answers
29k views

How to use GroupBy in CAML query

I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items Date Order 08/10/2012 5 08/...
3
votes
3answers
2k views

List set for anonymous but public cannot view

I have 2 lists, one allows anonymous access but the other does not. Here are the details of what I setup and what I've checked to resolve this (they should both Illow anonymous access). Each list has ...
2
votes
4answers
7k views

How to verify in Javascript Object Model if a List Exists

How can I verify if the list I'm trying to retrieve in Javascript really exists? My code is: function Search() { var context = SP.ClientContext.get_current(); this.site = context.get_site(); this....
2
votes
5answers
7k views

Can you restrict a list to add item only but not read?

Is it possible to create a list where you can add items to a list but not view items in a list?
1
vote
1answer
2k views

Event SPListItem Recurrence Text?

Is there a way to get the text displayed for the "Recurrence" field on the View Item screen for an OOB "Event" list item through the object model? For example, I see: "Every 1 month(s) on the first ...
5
votes
3answers
2k views

Send alert to a user when the 'assigned to' is changed in a list item

I have a list with a people or group field, it is set up to allow only one person or group to be selected. I would like a user to receive a notification when a list item is assigned to them. I tried ...
4
votes
1answer
6k views

“Show filter choices” link instead of actual values in a list column filter

I have created an standard list with a few simple text columns. Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when ...
1
vote
2answers
3k views

Color custom list items based on Status using OOTB

I want to change color of the list item row based on the field value without any code. For Example : I do have custom list with fields Title, Status(Pending,Running,Completed). I want to color list ...
1
vote
2answers
3k views

Not all views being displayed in my web part

Issue: Not all views being displayed in my web part. When selecting a view in my web part it only shows 30 views. How do I get it to show all views created for a list if there is more then 30?
0
votes
3answers
591 views

Issue with calculated column

I have a calculated column CRM ID with simple formula =CONCATENATE("CRM")&ID. The formula concatenates ID field with string CRM. The issue is: Sometimes when user update list records, the CRM ID ...
21
votes
7answers
76k views

Sharepoint Lists vs. Sharepoint Libraries

Fundamentally, what is the difference between the two? I'm in the really early stages of working out what's what with sharepoint and I can't seem to tell the difference between the two.
13
votes
1answer
20k views

PowerShell - create list from list template in list template gallery

Using PowerShell on a SharePoint 2010 site, how can you create a new list from a list template found in the list template gallery?. I want to be able to add several lists at once (just in numerically ...
26
votes
6answers
71k 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?
6
votes
2answers
54k 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 ...
35
votes
5answers
78k views

How to remove Title column in SharePoint 2013 List?

I want to remove "Title" column created by default in SharePoint 2013 List. I googled many times.But I got only solutions for SharePoint 2010 version only.Those Solution is not working for this latest ...
6
votes
2answers
11k 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 ...
11
votes
1answer
11k views

Programmatically find lists by template ID

I am looking for an efficient way to programmatically find all SharePoint lists with a given template / type in the current site collection from within a sandbox solution. NB: I'm obviously aware ...
5
votes
1answer
7k 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 ...