Questions tagged [list]

Rows of items containing columns of information.

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

ShareGate won't allow edit access to old SharePoint lists after the migration to new Site

Is it possible after transferring SharePoint lists (80 distinct SharePoint lists) from old SharePoint site to new SharePoint site that the old SharePoint lists still can be editable. The migration ...
0
votes
1answer
14 views

SharePoint list column IF statement

I have run out of IF multiple statement within SharePoint list calculated column, I still have more sites to add. I'm looking into a different way to build IF statement to fit all my sites (30 in ...
0
votes
0answers
20 views

List filtering on a list display/Edit form

First of all, I don't use SharePoint online. SharePoint 2016 updated to 2019 here. I have a list of items with a ton of columns. When I click on an item it takes me to that list items display form. ...
0
votes
1answer
15 views

How to set Custom List permissions in SharePoint Online?

I have created a new Intranet for our IT department, with an issue reporting list. Every employee can submit an issue with their hardware/software there with some additional info and we can then mark ...
0
votes
1answer
21 views

Inside our Details List View; can we show 3 tabs to show a Parent list item, Child-1 list item and Child-2 list item

We have a SharePoint online communication site, and it contains these 3 custom lists: Master List Child-1 List which contain a lookup column to the Master list Child-2 List which contain a lookup ...
0
votes
1answer
23 views

Change the Button colors, Font Color & Font Family for our SharePoint online modern UI

We have the following modern UI: Where we are trying to get the below UI, which have the following changes: Button color is different, Font Family is different & Font size/color is different , as ...
0
votes
0answers
15 views

Vertical Align SharePoint Online List

I have a list that holds 18 columns of KPI data for each month of the year and the 19th column is a multiple lines of text option. A majority of the data is calculated formulas for each row. Since ...
0
votes
1answer
18 views

Which lists are eligable for Quick charts

I have a SharePoint communication site, which contain 16 custom lists and 6 document libraries, but when I tried to create a chart using the modern Charts web part, I only get 3 lists inside the List ...
1
vote
1answer
16 views

Three-Color Coding based on Date Ranges in SharePoint Online

Follow-up to 594140 ORIGINAL CODE: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "...
1
vote
2answers
27 views

How to prevent Power Automate from being suspended after inactivity?

I have a Power Automate that is triggered on SharePoint list item update. But that SharePoint list is updated rarely once in a year. In this case, my Power Automate is automatically suspended by ...
1
vote
2answers
18 views

Avoid SharePoint Collection Admin from Accessing Certain Lists

I have created certain lists on SharePoint with only users can be able to see their entry. However, it turns out that the SharePoint Collection Admin can be able to view user's list entries. Is there ...
1
vote
2answers
36 views

Conditional Formatting a Date Column

I am completely all new to this. I have a simple SharePoint list recording training. What coding would I need to write in, to achieve the following: blank fields - color red anything else with a date ...
0
votes
1answer
12 views

How can I get a column to return value of another column?? help

i am creating an employee contact list for my company. One of the columns is "Departments" (a choice column n=5). In each Department, there are several teams. Because Employees will need to ...
1
vote
0answers
16 views

I am trying to return all lists from SharePoint site using CSOM, but my query only returns back 1 item

I'm new to the share point API. I am attempting to retrieve all the lists in a SharePoint subsite so that later I can choose one of the document libraries and upload a file. When the query finishes it ...
0
votes
1answer
11 views

SP list calculated field

Trying to make SP List calculated field for three sites. Each site has two conditions. Using statement: IF(AND([Site_induction]= "Chester TCC" , [Speed_limit]= "5mph"), "1&...
1
vote
1answer
8 views

List validation if then syntax

I am trying to use list validation to enforce that the value in the Category choice column is compatible with a value in the Activity choice column (1:1) If [Activity] = "Walking"; [Category]...
0
votes
1answer
17 views

SVG not displayed

I'm trying to create a SVG shape in my SharePoint List using the below (simplified) code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema....
0
votes
0answers
15 views

How to count a series of columns in share point list if containing text

Question, how to count a series of columns in SharePoint list if containing text, i.e. 12 columns contain text and I want to calculate them. If 12 out of the 12 columns contain text then it would give ...
2
votes
1answer
51 views

How to use the created by column from SharePoint built-in fields?

How can I use the created by column from sharepoint built-in fields? (Sharepoint Online). I'm designing a SharePoint document library and I want to use some of the built-in fields. [$FileLeafRef] and [...
0
votes
1answer
47 views

SPFx - Increment Like in sharepoint list item rating

I have a SharePoint list with reviews enabled, I am trying to patch an increment to the like count within SPFx. What's the best way to achieve this? Can't find much info online, can anyone point me in ...
1
vote
1answer
29 views

JSON to display SharePoint list choice column fields as visual checkbox, centered

I tried to use the out-of-box SharePoint "checkbox" field in a SharePoint list, however, it does not visually display as a checkbox either in classic or modern view. It was also cumbersome ...
0
votes
1answer
24 views

LookUp Column Not Returning Values from Referenced List

I have two lists, A1 and B1. A1 has and "Entity" column and the rest of the columns are user details. A1 Example: Entity column = Starbucks.. Rest of columns = Name, Request Date, Email, ...
0
votes
1answer
17 views

List formatting: combine motion class variable

According to MS it's possible to configurate the motion for elements in SharePoint Lists. Is written here Fluent UI - Motion when I add ms-motion-slideUpIn to the class attribute, the corresponding ...
1
vote
1answer
20 views

Lists: Circle progress bar as column view

Build in the SharePoint list classes is the option to display percent values as a progress bar. My idea is to show it as a round progress circle instead (like the image below). Can this be achieved ...
0
votes
1answer
39 views

Show Description on Title Hover in Gallery view

I have a custom list with Title and Description. I wish to display the list view as a gallery with only the Title in it. On hover over the title, it should display the description field covering the ...
1
vote
1answer
37 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 ...
0
votes
1answer
13 views

Change value of PesonOrGroup 'Show field' value with powershell

Using SharePoint 2013 enterprise on-premises. Last week a user recommended changing the 'show field' value from the default to 'Account' on our task lists. This is hundreds of changes as we have 220+ ...
0
votes
2answers
16 views

List header: show only some filters

I have a JSON customized list view with about 15 columns. For the end user only about 5 of them are useful or should be available for sorting/filtering. If I hide a column from the view, the ...
1
vote
1answer
27 views

Which info can be used from Person/Group column/field like $person.email or $person.title?

I'm formatting a list for an org. chart-ish view and formatting the list JSON. I use the person field to extract some information directly from the "User". E.g. the users email address to ...
0
votes
0answers
15 views

Creating an agenda from a Sharepoint list

I have a site with a list of discussion items and a group calendar with meeting dates. One of the list columns is "Discussed" which defaults to "No". Once they are discussed at the ...
0
votes
1answer
15 views

Cannot Filter List View with Yes/No Values

I am trying to create two different views for work anniversary and birthdays to only show if the current month is the same as hire date and birth date. I have the following calculated column, which ...
2
votes
1answer
74 views

How to add image in SharePoint online list?

In SP on-premise, we could add a content editor web part and add an image in the new form. I need to do the same thing with SharePoint online, and I am unsure how to do it. So basically, what I need ...
0
votes
1answer
222 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
31 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
2answers
30 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
15 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
38 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
22 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
18 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
14 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
49 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
31 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
29 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
64 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
40 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
27 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
41 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 ...

1
2 3 4 5
118