Questions tagged [list]
Rows of items containing columns of information.
521
questions
11
votes
7
answers
86k
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
77
votes
11
answers
76k
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,669
41
votes
6
answers
114k
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 ...
- 743
40
votes
4
answers
135k
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,724
14
votes
4
answers
36k
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
65k
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).
- 2,110
5
votes
3
answers
38k
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 ...
- 51
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 ...
- 502
8
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,745
6
votes
5
answers
70k
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 ...
- 415
10
votes
3
answers
25k
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,115
5
votes
3
answers
10k
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,371
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,548
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,745
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
988
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
0
votes
1
answer
2k
views
Validation Column Not Working
I have a Validation Setting column which seems not to be working with the formula =RTW>=StartDate and I get error:
'Something went Wrong'
However it works if I have the formula =RTW=>Today() ...
- 63
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 ...
- 2,002
17
votes
10
answers
121k
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 ...
- 273
10
votes
4
answers
92k
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 ...
- 1,740
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
16k
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,086
6
votes
5
answers
18k
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
6k
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": ...
- 177
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. ...
- 2,002
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
1
answer
5k
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 ...
- 33
3
votes
1
answer
14k
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 ...
- 202
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 ...
- 337
8
votes
2
answers
37k
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
8
votes
2
answers
46k
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 ...
- 115
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 ...
- 1,037
7
votes
3
answers
50k
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
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 ...
- 583
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,252
2
votes
5
answers
9k
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
716
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,623
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
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() {
...
- 2,002
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
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,340
1
vote
1
answer
6k
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((...
- 535
1
vote
2
answers
4k
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?
- 11
1
vote
0
answers
3k
views
Change column name in view using json view formatting
I have a view in SharePoint online where I need to override column name with a custom value.
Is it possible to do this using JSON View Formatting?
Ref:
https://docs.microsoft.com/en-us/sharepoint/dev/...
- 249
1
vote
2
answers
2k
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
1
answer
3k
views
SharePoint Online - formatting column headers
I have created a modern list in SPO with JSON conditional formatting on the row and view levels.
One conditional formatting snippet I've added hides the cell text (row level) based on the current user....
- 47
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