Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
11 votes
7 answers
85k 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?
  • 111
76 votes
11 answers
74k 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.
  • 1,659
41 votes
6 answers
111k 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 ...
  • 733
40 votes
4 answers
134k 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 ...
  • 1,000
17 votes
3 answers
29k 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 ...
  • 2,704
14 votes
4 answers
35k 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 ...
  • 253
13 votes
1 answer
63k 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).
5 votes
3 answers
36k 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 ...
2 votes
1 answer
8k 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 ...
  • 482
7 votes
5 answers
14k 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 ...
  • 6,725
6 votes
5 answers
69k 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 ...
  • 417
10 votes
3 answers
23k 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')/...
  • 1,095
5 votes
3 answers
9k 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 ...
  • 2,329
4 votes
3 answers
24k 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 ...
  • 2,498
3 votes
2 answers
1k 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 ...
  • 6,725
2 votes
3 answers
1k 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("...
  • 445
1 vote
1 answer
735 views

Color Coding List Item by Web Part based on value

I am currently trying to get color coding on a list to highlight good medium and bad properties. I have tried to follow the examples shown here for color coding: SharePoint 2013 Client Side Rendering:...
  • 11
25 votes
2 answers
18k 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 ...
  • 1,982
17 votes
10 answers
120k 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 ...
10 votes
4 answers
91k 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 ...
9 votes
6 answers
48k 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 ...
  • 664
6 votes
1 answer
15k 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,096
6 votes
5 answers
17k 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....
  • 580
5 votes
1 answer
5k 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": ...
  • 167
3 votes
1 answer
10k views

Large list issue with CSOM

Let's say there is a list with very large number of records. Now applying a particular filter on a list also retrieves very large number of items, more than threshold value. Retrieving list item is ...
  • 273
3 votes
2 answers
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. ...
  • 1,982
3 votes
1 answer
13k 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 ...
  • 197
2 votes
1 answer
2k views

SharePoint Online list - format group headers to remove column name

I have a SharePoint Online list that contains employee documents for each of our staff members. I keep it grouped by employee name which is great, but the word 'Employee:' before each name is really ...
  • 23
2 votes
1 answer
18k 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 ...
8 votes
2 answers
41k 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 ...
8 votes
2 answers
36k 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/...
  • 407
7 votes
3 answers
49k 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 ?
  • 71
7 votes
3 answers
45k 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 ...
6 votes
3 answers
25k 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,166
5 votes
1 answer
8k 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 ...
  • 565
3 votes
3 answers
4k 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 ...
  • 1,242
2 votes
2 answers
13k 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....
  • 121
2 votes
2 answers
8k 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,982
2 votes
4 answers
8k 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....
  • 1,987
2 votes
5 answers
8k 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?
  • 3,773
2 votes
1 answer
502 views

SharePoint Online, how to disable new "Comments" feature?

Anyone know how to turn this OFF? I use my own field to track comments in our document approval system, this new feature confuses users. This icon appears in custom lists: PS: And what is this?
  • 1,591
1 vote
1 answer
6k views

Add new document templates to a library

I have created a document workspace library, but now users can only select one document template when clicking "New Document". I have found this screenshot above, but could anyone explain me where I ...
  • 179
1 vote
2 answers
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?
1 vote
2 answers
1k views

how to change the order of filter in reverse order?

This is my demo list, and I want to apply filter to it. However, notice that the order of the filter is alphabetic, but I want it in reverse. How can I make the order of the filter in reverse order? ...
  • 111
1 vote
2 answers
4k 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,356
1 vote
1 answer
5k views

SPFx R.C. post method, SPHttpClient.configurations.v1 undefined exception

I am try to convert this old school example. It was drop 3, now I need to convert it to SPFx RC version; private createItem(): void { this.getListItemEntityTypeName() .then((...
1 vote
3 answers
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 ...
  • 1,612
0 votes
3 answers
922 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 ...
  • 776
39 votes
5 answers
96k 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 ...
  • 503
28 votes
7 answers
106k 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.

1
2 3 4 5
10