Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

SharePoint FilterValue in URL with Hyphens, Periods, Parens etc

How do I escape/encode certain characters in a FilterValue part of SharePoint query string. I can use encodeuricomponent to get most of them, but SharePoint still needs hyphens, parens, periods, etc. ...
0
votes
1answer
22 views

Getting and setting multiple items from a Sharepoint list using CAML query?

I have a SharePoint list Catalog. Using camlQuery I can get a list item value called Price. With the following code I get the Price value of the list element which has the ID 5 and store it in a ...
0
votes
1answer
21 views

Person and group multible selections separate names

So I got this problem where the names stands after eachother, is there anyway to move Alexanders name under Jonas? See picture:
0
votes
1answer
12 views

Correct camlQuery to retrieve list item value via JavaScript and setting that value in another list

I have two lists: Catalog and Position. I want to retrieve the value of a list item in Catalogand use it for the value of a list item in Position. To get the list items' value Title, I used // Get ...
1
vote
1answer
20 views

Can I set List Validation Settings programmatically?

I want to set the Validation Settings of a List with PnPJS. Is this possible? alternatively: Is it possible to provision a List with specific Validation Settings in place? Thanks!
1
vote
2answers
27 views

(None) Value on Sharepoint List

I created a list in Sharepoint where one of the columns looks for values from another list. I'm using this list in Microsoft Teams to be populated, but when I select the corresponding column field, ...
0
votes
1answer
13 views

Column validation user message pops up for millisecond

So I got this column validation: =[Sleep]>TODAY() And user message "NO". And it works, I cant put a date back in time, but the user message "NO" is just popping up for a millisecond, someone knows ...
0
votes
2answers
21 views

JQuery - Set Person Field Value

How to set person field on form load and save the field value when item saves. I have added following code in script editor web part NewForm.aspx. But this is not working. Appreciate your support. $(...
0
votes
0answers
24 views

Multiple choices person or group - error in power bi

I got this problem, when i've choosed several technicians like pic below I get this error in Power BI "1 of the loaded queries contained errors", and the column gets blank. If I change the sharepoint ...
1
vote
3answers
29 views

Changing Members Edit Permission Level

I have a Sharepoint List where members can populate with information. But some members are creating new columns, which has caused confusion for other users. Is possible to block the "+ Add Column" ...
0
votes
1answer
15 views

Changing list column width with Script Editor doesn't break line

I have a webpart that has a list with columns. To change the width of these columns I inserted a Script Editor and used this code: <style> .ms-vh-div[displayname='Beschreibung'] { width: 450px;...
0
votes
1answer
16 views

Modify SharePoint List column width of custom webpart with HTML source

I have a custom webpart called Available seminars: I want to modify the width of certain columns. On the Internet it is written that I have to use <style type='text/css'> .ms-vh-div[...
0
votes
1answer
12 views

Date is correct, but String is not being recognized as a valid datetime

I use this to get the current date with one month added to it: var date = new Date(); day = date.getDate(); month = date.getMonth() + 1; month = month + 1; if((String(day)).length == 1) day = '0' ...
1
vote
0answers
23 views

Add a formatting rule for a text in a form [closed]

Is there any way of creating a formatting rule for a title or text? I want to make a text appear when I set true a checkbox. I know how to do it with a texbox but not with plain text. Thank you in ...
0
votes
0answers
25 views

SharePoint List: hit highlight on search results

I have a SharePoint list containing categorised multiple lines of text. I want to search keywords in the Search Box (example below) and results highlighted within the body of text. Without using CRTL +...
0
votes
2answers
19 views

How to let a user edit a list via forms. But don t allow them to access to the list page on sharepoint 2010

I want to know how to only allow x users to edit a list but only with the form. This means that the user shouldn``t be able to see the list page.
0
votes
0answers
37 views

SharePoint Online - JSON Column Formatting

I have a List Lookup in my form. This gives the user the ability to choose multiple unique values. The problem I am having is that the values are being translated back on to the SharePoint list with ...
0
votes
1answer
21 views

Easy sync sharepoint lists

I have sharepoint 2016 in azure cloud (installed on VM in the cloud). I have 2 custom lists in the same site collection - list A and list B with the same collumns. I need to sync any changes on ...
0
votes
1answer
30 views

Function adds an element to list every time someone opens a form

I have a form in which a user chooses "Standard", "CAD" or "Manager" which will add an element to a list automatically. The function onChangeMassnahmen() will check if the checkbox is checked: ...
0
votes
0answers
25 views

Sharepoint check if connected user has the right to modify a list item

In a SPFX Webpart I need to know if the connected user has the right to modify a SharePoint list item. To do so, I use a function of PNP JS : sp.web.lists.getByTitle("ListTitle").items.getById(...
0
votes
1answer
33 views

Call a list value into a table on a SharePoint page

I am trying to call a value from a List into a cell in a table on a different SharePoint page. The table is composed using html, and I think that is where I'm having trouble trying to connect the dots....
0
votes
1answer
24 views

SharePoint 2010 List Custom ID Column Creation

My team is trying to create a custom ID column for our SharePoint 2010 list. The column should show YYMMDD-ID, with YYMMDD the date the item was created and ID the ID of the item. I tried using =[...
0
votes
1answer
27 views

Fill SharePoint list element field (people picker) with JavaScript

I want to add a list element via JavaScript which works (almost). After the help from a user here I got this function fillStandard() { console.log("Standard"); var posInvest = "Invest"; ...
0
votes
1answer
29 views

Adding list element via JavaScript gives error

Please note that I'm doing this for the first time. I want to add an element to a list via JavaScript. Therefore, I tried this: function fillStandard() { console.log("Standard"); var ...
0
votes
1answer
25 views

How to share a customised SharePoint form by PowerApps to all SharePoint Lists

I have a multiple lists which are similar, in other words they have the same fields, In order to customise a SP List form, I use PowerApps (for example to manage field visibility for a certain users)....
0
votes
1answer
29 views

How to refresh Sharepoint List Web Part in jquery?

I had added one SharePoint list web part. I want to need refresh web parts without refreshing the whole page using jquery or SharePoint default.
2
votes
1answer
28 views

Sharepoint Lists: Order of choices in filter drop-down

In a list, at the filter drop-down section, choices are in ascending order. Is it possible to display the choices in descending order?
0
votes
1answer
21 views

SharePoint 2013 Column Returning as “Null” rather than Double

The below list contains columns which are simply years (set to contain 0 decimal points). The current columns are 2016, 2017, 2018, 2019, and 2020. In use, the end user selects a date on a calendar ...
0
votes
1answer
28 views

Query a single line of text filed using CAML <Contain> will return all items

I have a list inside SharePoint online site collection. the list contain a field named Processed which is of type single line of text, and only one item have a value inside this field while the other ...
0
votes
1answer
27 views

Disbale editing row in sharepoint based on column

Is there any way to disable a row in a SharePoint list based on a column value? I have a time off list that I would like to disable once it has been approved. So if approval status is approved you ...
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
2answers
35 views

Deny Access to Item for Group of Users

My client has a requirement to deny access to items in a SharePoint list to a particular group of users. By default, the list is shared with "Whole Company", but if an item is marked "No Contractor"...
0
votes
1answer
25 views

URL to open a list element in dialog box on a specific site?

I have a link (https://mysite/tools/EmployeeList/Lists/Zutrittsberechtigung/DispForm.aspx?ID=284) that is sent per E-Mail. This link opens a list element in it's DispForm.aspx: The user wants this ...
0
votes
3answers
38 views

CAML error when querying SharePoint List for more than one input

I have a CAML query which retrieves data from a SharePoint list. It passes for 1 input, but fails when there are 2 or more. Error: Microsoft.SharePoint.SPException: One or more field types are not ...
0
votes
0answers
23 views

How to get rid of an extra radio button choice created by SharePoint Lists? [duplicate]

I am creating a list on SharePoint and want to include a simple field in which users can answer a question by choosing a radio button. When I save my changes I see that Sharepoint has included an ...
0
votes
2answers
45 views

Add text to top of DispForm.aspx dependant on specific field value

I need to add the word "Jersey" in red/bold to the top of the Display Form page on a SharePoint online list when 'Jersey' is selected from the 'Location' dropdown field. Please could you let me know ...
0
votes
1answer
24 views

Hide quick launch for specific group permission

I have a list which contains multiple users that they will access it from 2 different groups permissions, Members (Read Only), Visitors(View Only). What I have tried to do: When they are assigned to ...
0
votes
1answer
56 views

SharePoint Online: Calculated field with week number starting Saturday

I've found a few ways online to calculate the week number but none that allow me to start the week on Saturday. Here is the formula that I tested, but doesn't give me Saturday-Friday. =INT(([Time In]-...
2
votes
3answers
65 views

Change the Yes/No Column Type into a Checkbox for a SharePoint Online List

I am having trouble trying to find out how to change the Yes/No Dropdown to a Checkbox while in quick edit mode. I am on a SharePoint Online list and have tried a few different things without any luck....
0
votes
1answer
43 views

Updating a column using choices from other lists

I have a list A with a choice column (Choice 1,2,3). And a list B with the same choices column B. I have also a third list, List C with column A and B which are updated through workflow from the ...
0
votes
0answers
20 views

Managing Content Type using REST API

How can i manage Content Type in SharePoint List using REST API, it's look like a very wide question, isn't it ? well what i'm looking for exactly is: How to change content type visibility option to ...
0
votes
0answers
31 views

Error 415 (uns. media type) when creating new item list on SP Online using REST API and POSTMAN

As you can see I'm successfully authenticated to my tenant as I can retreive the List info. But I just can't create an item. I always get an 415 error "Usupported media type" whatever the headers I ...
0
votes
1answer
29 views

CSS code to adjust column widths using static name instead of display name

I'm currently using this code to adjust the width of specific columns by referencing the display name: English version: .ms-vh-div[DisplayName = "Recent History"] { width:300px } However, I've ...
0
votes
1answer
31 views

Is it possible to recover a deleted column from a list in SharePoint 2013?

I accidentally deleted a column from a list that contained a lot of entered data. I have no backup of this data, is there any way to recover?
0
votes
1answer
8 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
4
votes
2answers
70 views

Temporarily disable alerts in specific list in SP Online?

We need to do a maintenance that will modify a lot of items in a list where the is a lot of alerts. We don't want to send notifications to the users and we can't simply delete the subscriptions (the ...
3
votes
2answers
148 views

If exceed 24 hours show “23:59:59”

So I got this calculated column called "Due time" with this format in it: =IF([Hours]<24&&[Minutes]<60;CONCATENATE([Hours]&":";[Minutes]);"23:59:59") I only get syntax error with ...
0
votes
2answers
32 views

Get list of all content type associated with a list

I am using client code using JQuery and rest API where I have a requirement to bind a drop down control with the content type names associated with a particular list. I am working on SharePoint ...
0
votes
1answer
19 views

COUNT of items in list, with more requirements

Here's my current predicament: I'm trying to assign a COUNT value in one list to a column in another list (on the same site, of course). But, here's the twist - I want a COUNT of columns of a certain ...
0
votes
1answer
32 views

How to update “Person or Group” column in SharePoint List using REST API

I am looking for a way to update a column of type "Person or Group" using HTTP Request of type REST. Thank you.