Questions tagged [custom-list]

A custom list in SharePoint is a blank list in which you can add your own columns and views. Use this if none of the built-in list types are similar to the list you want to make.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 views

Column validation for a choice column to check for condition on other fields

I'm a newbee to SP. I have a list that has following columns in my custom list in Sharepoint Online. PrjStatus Name Start Date End Date SummaryLink and so on... PrjStatus is a choice column with ...
0
votes
1answer
16 views

Sharepoint List Field to Excel is Adding “#” and Numbers to Field

Using SP 2013 on-prem and created a custom list. One of the list form fields allows for multiple people to be added via our address book. Works great in SP, but a problem when I export the list into ...
0
votes
0answers
13 views

Create read only list views recursivelly and grant the permission

There is a custom list on my SP2016 server on premises. My colleagues need only read permission on given view (with many columns) of this list, but they should not see the columns not included in this ...
0
votes
1answer
53 views

SharePoint passing value of text box on click to update list column

I have a text box on one SP page. Upon click of the submit button, I need the numerical value/input to be sent to a column in a list. I have some coding put together from bits and pieces I've found ...
0
votes
1answer
28 views

Calendar List View that groups like values

I have a calendar that I'm using to track employee sick time. I have two fields from which I'm trying to create a new list view. "Employee Name" is a Person or Group field and "Occurrences" is a ...
0
votes
1answer
24 views

Average and Total in a Calculated Column

I am currently calculating the difference between created date and modified date in my SharePoint custom list. Is it possible to also calculate the average of the # of days, totalled by month? I ...
1
vote
1answer
34 views

SharePoint Custom form using SharePoint Designer

I have a requirement to create a form in a SharePoint List in which there will be 10 columns like col1,col2....col10. On submitting col1 to col5 an approval workflow should trigger and once request ...
2
votes
1answer
32 views

List Column that auto-increments from 100,000

One of our employees wants to have a column in his list that autoincrement from 100,000. I tried to use "ID" column, then create a "calculated" column that adds 100,000. That didn't help; id populates ...
0
votes
1answer
46 views

Number Reset as Beginning of the Month

I have an ticket tracking system in a SharePoint list that runs by a Fiscal year, month, then counts for the month. And my leadership wants to automate the number assignment. Ex: ABC (current ...
0
votes
1answer
39 views

Link multiple choice list column to the document/s to be uploaded in the document library

So I have items in the list which is linked to the documents in the document library using lookup columns where users can see how many documents have been linked to the selected list item. The ...
0
votes
0answers
13 views

How to link multiple sp list on one page or modern webpart

We currently have a on-prem solution that show a web part page with 6 webpart. 3 of the web parts are linked to a main webpart. The 3 webpart list changes based on what is selected on the main ...
0
votes
1answer
15 views

Each row on a list have it's own input form

Is there a way to have each row in a list have it's own form elements (text box's, drop downs, buttons, etc.) and update each item rather than use datasheet view? I want to create a list where the a ...
0
votes
2answers
39 views

Save As draft in SharePoint 2013 custom list form

I want to have two separate buttons in SharePoint 2013 Custom List Form. One is Save As Draft and the other is Submit. I have a choice field with column name Status with values Draft, Submitted, ...
0
votes
1answer
32 views

Sharepoint 2013 - word documents do not show their Sharepoint title or name

I have recently noticed that my search does not return the SP document name or SP document Title. It is a master library and has both the name and the title fields that are included. It doesn't work ...
0
votes
1answer
31 views

Counts for every option Doesn't match up with total count

LEE_MSFT corrected my code below. Code works well but the only problem i have that total item count is 319. But sum of each count is 21(Active),77(Closed),2(Partial),0(Special). Can anyone help me why ...
0
votes
1answer
14 views

migrate Access database to Sharepoint and preserve ID column

I would like to migrate access databases to SharePoint Online, and sometimes the built-in migration wizard fails. I can create the missing tables and relink them with a macro, but I have trouble ...
0
votes
2answers
42 views

SharePoint 2019 - how do I embed custom script

Ok - another seemingly basic function. Once you were able to insert a webpart into a list - add custom script, text, what ever you needed. I am looking how and where I would find this sort of ...
0
votes
1answer
17 views

Rename 'Like' link in custom lists

Is there a way to rename the Like/Unlike links in a custom list where rating has been enabled? 'Like' in our case would be misleading so we would like to have it show up as something like 'Confirm'.
0
votes
1answer
19 views

Json Formatting

I am in a position where all I want to do is change the font color of a column to #002c77 no matter what the text within the text field says. I cannot for the life of me get it to work, and there I am ...
0
votes
1answer
88 views

Facing error 'Something went wrong Please try again or refresh the page' while adding OOTB custom list web part in Site Page in SharePoint online

I have been facing below error when I try to add custom list web part in Site page in SharePoint online sub Site. Something went wrong Please try again or refresh the page. Any idea about what ...
0
votes
2answers
13 views

Removing a List from a Search

I have a list where new users are added as they input there information. The problem is that if a user do a search they can pull up other users ss. How can I prevent other users from searching in the ...
1
vote
2answers
44 views

Wondering if a custom filter view to a list help the 5000 view threshold issue

Is the 5000 view threshold a server side issue or a client side? In other words, would I be wasting my time creating a client side custom "view filter" from the Allitems list it's still going to ...
1
vote
1answer
40 views

Custom List- Item Edit

I created a custom list, Team - users have "Contribute only without edit & Delete" , Team - has "Contribute without delete" But 2 nd team can not edit the list item wise, (I also can not edit ...
0
votes
2answers
101 views

Connect two sharepoint lists

I do not know programing, but I can use SharePoint for my requirements. I want to connect two SharePoint lists in to one. Lookup column is not enough to meet my requirement, is there any way to link ...
0
votes
0answers
23 views

Cascading Dropdowns SharePoint Online

I replicated the example from Cascading Dropdown on my SP Dev site. Created a Locations list with Location and Dept. Leaving Powerapps and Publishing I then try to create a New Item in my list. I ...
0
votes
0answers
20 views

Search Box Query Settings

I am trying to setup my search box to query only from the three list webparts I have on the same page. I have gone into the manage result sources but have been unable to make this happen. Can ...
0
votes
0answers
90 views

How to jump specific page using pnp js for sharepoint pagination

I am using pnp js Get Paged Items for pagination in my SPFx webpart. sp.web.lists.getByTitle("MyCustomList").items.top(10).getPaged(); Suppose I have 150 data in a list. I set 10 data for a page. So ...
0
votes
1answer
28 views

Find out SharePoint custom list items for which metadata is missing SharePoint 2013

We have a SharePoint 2013 custom list which is holding around 600000 records. Now I want to find out list items for which metadata is not filled.
0
votes
1answer
19 views

List view showing only items with attachments

I have a need to create a view on a SharePoint list that shows only items with attachments. Any idea how I can achieve this? Through Microsoft flow, I can see a hidden field called "has attachments" ...
1
vote
1answer
62 views

SharePoint List Formatting

I need to do a databar format on a choice column with text inside. Is this possible? I can get it easily enough with the given JSON formatting code but i cannot seem edit the code below enough to ...
0
votes
1answer
20 views

Increment count

I have an SPO list where I want to do an event tracker. It will track if an instance happens it increments by one, and we keep tracking for a year. At the end of the year the tracker reset to 0, and ...
0
votes
1answer
44 views

What is the URL for a Custom List with only ListID?

I need my app to create a URL to a Sharepoint Custom List AllItems view. Within the app, I can only see https://mycompany.com/ and ListId=xyz. Constraints: I do not have access to the Custom List ...
0
votes
1answer
20 views

Using Modal Pop up but it automatically refreshes page

I used the following technique to create a Modal Pop up on my SharePoint Page: https://jqueryui.com/dialog/#modal-form It works create but when the Modal dialog screen appears, it refreshes on its ...
0
votes
1answer
24 views

Update REST query based to get items from List in SP 2013

I have a query in REST API which is : var i = _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists/GetByTitle('Pages')/GetItems(query=@v1)?@v1={"ViewXml":"<View Scope='RecursiveAll'><Query&...
0
votes
1answer
462 views

The page you requested is temporarily unavailable. We apologize for the inconvenience, please check back in a few minutes

I am adding and updating 56 columns(include people picker column) and 4999 rows in sharepoint list through excel using rest api but after some time i get throttle temporary issue and it does not ...
0
votes
1answer
30 views

Calculate max(num) +1 with calculated value? (Help please)

I want to do this: MANUEL 1 PEPE 1 MANUEL 2 LUIS 1 I want to get the number by a calculated value, but if the name is duplicated get the max(num)+1. Example: if (NEW.INPUT) exist find max(...
1
vote
1answer
26 views

Using sharepoint to send an emailed question, and then respond via email which updates the list

I'm creating a Sharepoint site for multiple support teams. Basically, what I'm looking to do is: 1. Have a list where employees can submit a question 2. Once the question is saved, an email ...
0
votes
1answer
40 views

How Can I Get URL Column to Open in New Window in SharePoint 2016

I added the Site Column "URL" to my custom List. Now I need to have the Link open in a new window. This is SharePoint 2016 so I can no longer use a Calculated Column to do this. Any Ideas? Bismarck
1
vote
1answer
21 views

How to create a site template and add fields to list automatically. For detailed question. Please find below

I need to first create a site template which consist of project name, description, attachments and appointment fields. Then automatically add few of their fields to the project management list. How ...
0
votes
1answer
48 views

403 FORBIDDEN code posting to list

I am trying to post to a list with a custom form. Each time I try to submit my for the console prints out a "403 FORBIDDEN" error. I have Site Collection Admin rights for the entire site. Here is my ...
2
votes
1answer
54 views

Is it possible to highlight the first 5 rows in a SharePoint view?

I have a view that sorts items based on a date field, from earliest to latest. The order will change over time, as users make edits to the item dates. I would like to apply formatting that will ...
0
votes
1answer
26 views

Error processing policy updates

I've seen error event with Event ID 7997 in the Event log. Task category is Information Policy Management. Error processing policy updates for site http://site for list listname. Error: System....
0
votes
3answers
57 views

Simple flow to update a specified time/date field with the current time not working - see screencaps

I have created a very simple workflow that should update any item that is created/modified with the current date-time, leaving all other fields the same. However, the current time is applied to ALL ...
2
votes
1answer
64 views

SharePoint Online - Add a ranking column

I want to add a new ranking column, which automatically ranks all the date/time values from the 'Timestamp' CalcField from oldest to newest (e.g. 03/03/2019 14:00 = "1"... 02/09/2019 12:00 = "10"). ...
0
votes
0answers
26 views

Custom Save on List Instance

I have already configured a way on how to call a code behind method on click of Save button. I want to get the field values from the form. What is the way to do it? Code Behind:
0
votes
1answer
40 views

Can i prevent modifying 2 fields when editing a list item using list validation

I am working on a custom list inside a classic team site. and inside the edit form i added this jQuery code to disable 2 fields (so those fields will only be set when creating the item):- $("input[id^...
0
votes
2answers
37 views

Users cannot view a customized List (needs add and customize page permissions)

I took over a SharePoint site that has customized code to display a list. About two weeks ago, I changed all the groups from "Edit, Contribute, Read, and Approve" permissions to "Contribute" because ...
0
votes
0answers
16 views

Populate Fields when Clicking “Save” on Custom List

I have a SP 2013 Custom List with 2 automatically generated numbers. Currently, they are queried and populated upon selection of input values for the first 2 fields. The form works great for a single ...
0
votes
0answers
20 views

SharePoint Online Lookup Column lagging

It started about a week ago, and it only has about 50 items. what is the best approach to tackle this. Thank you in advances.
0
votes
2answers
44 views

selectively hide webpart on homepage

My homepage has an embedded view of a list called Project Info which displays important project information. One of the fields is a choice field called ProjectStatus which can read either Pending, ...