Questions tagged [list]

Rows of items containing columns of information.

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

Column "does not exist. It may have been deleted by another user?

I cannot create a list on either the Page or SubSite for several Excel files. I am getting the same warning message telling me the same thing shown below (Column " does not exist. It may have ...
0
votes
0answers
21 views

How to Update column in a SharePoint List

I have a workflow that pulls a "Task List" from excel. Each task in this list has a different due date. How do I update this due date? The due dates should be calculated from the start ...
0
votes
1answer
23 views

Profile picture not showing column Person of Sharepoint List

I have put JSON-code in the column "Person of Group" to show the profile picture of the person. It did work before, but now I am getting: This is my JSON-code: { "$schema": &...
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
27 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
35 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
27 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
48 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
33 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
24 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
28 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
47 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
97 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
48 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
18 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
30 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
94 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
70 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
45 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
30 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
31 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
60 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
29 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 ...

1
2 3 4 5
118