Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
1
vote
1answer
14 views

Formula to validate the column is not empty if a column contain a particular value

I need to add a column validation to my list. I have 4 columns. Status (Choice) Version OutCome (Choice) Effort If I choose Status as 'Completed', The other fields should not be blank.
0
votes
1answer
23 views

How to find the user who has created a draft item in a SharePoint list

I am trying to find out the name of a user who has changed something in an SP list. I am calling this API: https://tenant.sharepoint.com/sites/sitename/_api/web/lists/getbytitle('listname')/Items(ID)/...
0
votes
2answers
26 views

Can i define a default value for a HyperLink site column to include the item ID

I have the following column of type Hyperlink and I want its default value to include a url with the Id of the item, I tried to define the format inside the JSON but it did not work, as follow: So ...
1
vote
1answer
20 views

create items and edit items created by the user not working as expected

I have a SharePoint List in which I have set the advanced settings as below. Now, I have the SharePoint group that has Contribute access on the list. My expectation is that the user should only be ...
0
votes
0answers
14 views

How can I adapt card size dynamically in SharePoint Lists' Gallery View after hiding fields?

I had this exact question and followed its answers, which means that in Gallery View, when I have a blank field it simply shows up as a blank, instead of "-". Since in my case, some cards ...
0
votes
1answer
23 views

What is the maximum syntax formulas that I can use in calculated column on my Sharepoint list?

I have created 20 syntax formulas (IF(AND([Job Group]=) based upon two other columns on my calculated column field, but I seemed to have reached a maximum limit. I cannot load my 21st syntax formula ...
0
votes
0answers
12 views

Trying to upload the date type from excel to SharePoint list column

I am trying to upload date column value in SharePoint list column of "date and time" type. The below image of excel data: The "Date of Commissioning" value upload in SharePoint ...
0
votes
0answers
10 views

How to display sharepoint list items with Javascript

I managed to connect my website with sharepoint with the following code: var siteUrl = 'mywebsite'; var targetListItem; SP.SOD.executeFunc('sp.js', 'SP.ClientContext'); var clientContext = new SP....
1
vote
1answer
33 views

Calculated Column based on the other column which is of type choice in SharePoint list

I am very new to the whole SharePoint and excel formulas and I am in the process of learning. I have a list in SharePoint in which I have multiple columns. I want to create a calculated column based ...
0
votes
2answers
25 views

Set Target Audience by specific view in SharePoint List using Modern Experience

In Classic Experience, there's an "Edit Page" on settings where I can access and set target audience per specific view of SharePoint List, however, this is not possible on Modern Experience. ...
0
votes
1answer
27 views

Problematic ‘go to comments’ emailed link from mentions

We are having an odd issue with mentions/comments for a list we have in SharePoint 2019. When a user does a mention and creates a comment it sends the email you would expect to the user with the ‘go ...
0
votes
1answer
26 views

Vlookup between 2 Microsoft List

I have 2 sharepoint/microsoft list files. I want to create a reconciliation of two columns( x and y) in 2 separate files/lists(a and b) and spit out the differences into a new file or in a new column ...
0
votes
2answers
39 views

Update Sharepoint List Item with Javascript Client Side Object Model

For the past days I've been trying, with no success, to establish a connection to a sharepoint list (https://mywebsite.com/sites/concasbkcu/Lists/list_teste/AllItems.aspx) and update its items with ...
1
vote
1answer
19 views

jQuery Ajax Unauthorized error on POST

Trying to create my first web part for SharePoint online that writes to a list. But when I do a post using jQuery ajax I receive an Unauthorized error. Any help you be greatly appreciated. I am ...
4
votes
1answer
35 views

Can we render element based on the current field value in Column Formatting?

I am working with Column Formatting in Modern SharePoint Online List where I need to render different images based on the choice selected but by default need to show the text of default choice. I have ...
0
votes
1answer
47 views

Sharepoint to Sharepoint - Power Flow: How to update "manager's name" based on user's name in the *same* item when item is created or modified?

My Objective: I am trying to auto populate manager's field using flow at preview.flow.microsoft.com in a SharePoint lists. How can I achieve this 1- Add or modify item like below 2- Enter user's name ...
0
votes
1answer
40 views

Need to count number of days until value of another column is set to a specific value. [Days Open] counts until [Status] = Complete

I have a [Date Reported] column and a [Status] column. I want to count the [Days Open] value until the selection in the [Status] column is set to "Complete". Once set to "Complete",...
0
votes
2answers
20 views

AJAX Data From SharePoint List Not Carrying Over to Next Function

I have created fiddle with mock sample data that is formatted the same way as the AJAX response data. When I try to implement my script into a SharePoint script editor and debug it, it tells me that ...
1
vote
1answer
32 views

SharePoint calculated column based on other 2 columns

I am struggling writing the formula for SharePoint calculated column. I have 3 SharePoint Columns: [Vaccination date]; [Infected] - Yes/No choice; [No testing is not needed (date)] In column [No ...
0
votes
1answer
23 views

How can I add gridlines to a SharePoint modern list?

Since modern SP doesn't really have an easy way to create a table with images, I've created a list with a few columns (including one for images). Is there a way to add gridlines to a modern list, ...
0
votes
1answer
44 views

Edit/Update List Item Based User That Created that Item

I am using Dialog popup to create a new list item which uses a people picker to automatically fill in the user field. The way this form works is it gets updated on a day-by-day basis. With the New ...
1
vote
0answers
43 views

Columns imported to new list from Excel do not appear in default form

I imported an Excel spreadsheet into a Sharepoint list. Only two of the columns actually appeared in the default edit form. The "Edit Columns" option doesn't give me the ability to enable ...
1
vote
1answer
18 views

How can I get ID when I insert new items to list?

I'm currently using JSOM to insert new items to list. var clientContext = new SP.ClientContext(); var oWeb = clientContext.get_web(); var oList = oWeb.get_lists().getByTitle("request&...
0
votes
1answer
24 views

What is the difference between ListView, List, ListId, ViewId

I'm trying to find the definition of ListView, List, ListId, ViewId. I couldn't find a clear definition on the net. Is it possible to find these elements from the following image? Is there also a ...
0
votes
0answers
15 views

How to submit the data from Power Apps to two different SharePoint list on select of save button

I have use the following approach: Set( newClient, Patch( Clients, Defaults(Clients), { Title: txtClientName.Text, 'Client Email': ...
0
votes
1answer
46 views

Update item in a SharePoint list from another SharePoint list

I have two SharePoint lists: List A and List B. Both lists have a column with a special number called VHE (text column) and a column Date. The Date column in List B is still empty and I would like to ...
0
votes
1answer
93 views

Lists 365 JSON - group header based on condition

Similar to the example here: Example: Color coded group header with aggregate I am trying the group header text in the list view to show the number of tasks that are NOT 'Completed' in the 'Status' ...
0
votes
1answer
43 views

Lists (JSON): Do's & Don'ts

My question is what are best practices and/or do's and dont's when programming JSON for SharePoint lists. What are hints to keep a good performance when managing large lists with custom views?
0
votes
1answer
47 views

Can I use JSON to indicate a person's presence status?

Our company has switched from onsite to cloud SharePoint, previously in the onsite SharePoint you could have a column that would display a person's presence status with a small traffic light icon next ...
0
votes
0answers
14 views

SP 2019 - Printing lists, column headers are displaying at the bottom of the page

I'm having trouble with printing out a list. Whenever I hit CTRL+P and look at the print preview, the column headers are at the bottom of each page instead of at the top. They are also overlaying some ...
1
vote
1answer
26 views

SharePoint Online - Archival Process besides Export to Excel

We have a SharePoint online list where we have users filling in a "new request" form (power apps customized form). Then an approver edits the form to add their details and then a processor ...
0
votes
0answers
22 views

List Centralization

Is there a way to centralize commons lists (and their data) across site collections? I understand content types can be shared/published from the contenttypehub but it does not look like this is ...
2
votes
3answers
34 views

Filter View on [Today] and also include blanks

I'm trying to set up a way of filtering one of my list views and struggling a bit. The first 3 filters are working fine to show the entries with only a date of today or later but when I use the final ...
0
votes
1answer
17 views

Having two headers in the SP online form

I am facing an issue with having two headers in SP online list form. Can you please help me to merge these two? Please see the JSON codes below: This is the bar code: { "debugMode": true,...
0
votes
2answers
29 views

Adding permanent image in SP online list

So I am trying to create an ICT risk share list with SP online. The main requirement is adding the below image to the list for user information. So every time users create a new record, they can refer ...
0
votes
0answers
18 views

TypeError: Cannot read property 'style' of null & TypeError: Cannot read property '_events' of null

I have a list with 14 columns. One of it is "rowId" which is numbering the columns and one is "FaelligkeitUeberpruefung" which includes a date. Everytime I edit something in the ...
0
votes
3answers
92 views

Showing an Image on SharePoint online list (New and Edit form)

I am new to SharePoint online, and I am having an issue with displaying an image when the user try to create a new item in the SharePoint list. This image is just a table with some information about ...
0
votes
0answers
14 views

How can one fetch values via JavaScript from a SharePoint list with columns that have values stored via term store

I have a jqGrid where 2 columns have values which come from the termstore. The values in the column "Mandant" and "Vertragspartner" are stored via term store management tool and ...
1
vote
1answer
17 views

Help with If/And

Running SP19 On Prem. Have a list with a column looking at type category with three options, and a completed column. I am looking at a calculated field/column in the list to filter a view with. 1st ...
0
votes
1answer
28 views

Error List 'listName01' does not exist at site with URL https://xxxxx.sharepoint.com'. in Postman

I have been trying to use Postman to see list items using Postman and I am getting following error: List 'listName01' does not exist at site with URL https://xxxxx.sharepoint.com' When I log in ...
0
votes
1answer
64 views

Networkdays and IFERROR

Here is an excel formula to calculate number of workdays between two dates: =IFERROR( IF ( A2 = B2, 0, NETWORKDAYS( A2, B2 ) -1 ), "" ) is it possibe to write this formula in SharePoint List ...
0
votes
3answers
43 views

Lookup Field to pull in values from Choice Column

I have a Customer Table containing info such as Customer # (Number), Name(Single line of text), Bankruptcy status (Yes/No), Currency (Choice). I also have a Invoice table which has a lookup column for ...
0
votes
1answer
29 views

Programatically Deploy List Item Layout

Suppose we created a list with a custom list form layout. Now, I want to move this list to a different SharePoint tenant/site. How do I programmatically apply the custom form laout? More details I am ...
0
votes
3answers
30 views

Add column to list with mailto function that takes users from 2 columns

So I have 2 columns "Owner" and "Deputy Owner", both are User columns and both filled. Is there some way I can make a new column, where I add a mailto icon and after clicking on it,...
0
votes
1answer
59 views

SharePoint Modern Page to Show only Sum Value from List

I am using SharePoint Modern. Can I display only sum value of selected column from List on Page? I do not want to show all the List Item. Best is to show as a textbox in Page
0
votes
0answers
13 views

Attempting to load ListItemCollection with DisplayName throws ServerException "Value does not fall within the expected range."

I have a CSOM process that extracts metadata from a SharePoint Online site and generically traverses the lists. A certain Link-based list is throwing a Microsoft.SharePoint.Client.ServerExeception of '...
1
vote
1answer
27 views

How to add users to a list by REST API before they are added to a list manually

I'm using SharePoint Online and SharePoint REST API v1. I realize that after a user is added to people column of a list manually, I can get user ID and add this user to a column by the API. But I need ...
0
votes
0answers
31 views

How to Generate Auto ID SharePoint List

I need to create a custom ID for one of my SharePoint 2013 lists, and the custom ID starts with KIT000, Kit001, and so on. Would you please help me with how to achieve this? Kind Regards
1
vote
1answer
31 views

How to delete in use content type

I have received a request today to hide/delete a site content type. I thought it is an easy task but it's making me sick. Every time I try to delete the content type I am getting the below error ...
0
votes
1answer
35 views

Convert SharePoint List to Drop Down Menu

I would like to convert SharePoint List in the form of drop down, so that I can change another connected list based on item click/selected in drop down list. It is not referring to the navigation ...

1
2 3 4 5
117