Questions tagged [list]

Rows of items containing columns of information.

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

List Column not showing up in my SharePoint List but it is showing up in my List Settings

I created a list and columns but not all my columns are showing up in my list. You can see the "Attendees" column on the list settings page, But this column does not show up on my list. ...
MarielaGagnon's user avatar
0 votes
0 answers
7 views

How can I use Sharepoint Lists to create a Corrective Action Database

Good morning! I'm trying to use SharePoint to track RCA's (root cause analysis) and corrective actions. Basically, I'd like to have a list that has the event, event description, facilitator etc. And ...
Aaron Williams's user avatar
0 votes
1 answer
14 views

SharePoint column show/hide condition - Multiple conditions with OR

I have a Choice column that I want to display if either of two conditions are true. It's an Approver Response column that I want to hide if "Approver Notified" checkbox = false, and Status = ...
Chris's user avatar
  • 403
0 votes
0 answers
11 views

SharePoint list gallery view preview link

I've been having some trouble with SharePoint list's gallery view for a while now. I create items from a power automate flow that gets an image link from OneDrive. Now, the image loads fine on ...
LunaRian's user avatar
0 votes
2 answers
21 views

SPO forms shows internal names instead of display names

I have created site columns with an prefix (e.g. pre_column1) and then changed the display name to "column1" which works fine for my user and for all user in lists views. But if some user ...
DocSummer's user avatar
0 votes
1 answer
16 views

SharePoint columns size limit

I hope you’re all doing well. I’m facing a BIG issue: For the past four months, I’ve been working on a flow connected to a SharePoint list. Today, when I tried to add more columns to my list, I ...
Ziko Otmani's user avatar
0 votes
1 answer
14 views

SharePoint Calculated column displays 1905 as default result

I am trying to calculate the previous year of today by using below formula. TEXT(Year(Today())-1,"yyyy") I am using Text() to avoid the extra comma(,) in the output. But the current formula ...
Kailash Sahoo's user avatar
0 votes
0 answers
18 views

JSON Code is having no Effect on Column Formatting in a SharePoint Online List

In SharePoint Online, I have permissions as "Owner" (not ADMIN). I have created a list. The column types vary (of type URL, Text, Date, etc.). For the URL column, I added the following JSON ...
Angelina Gomes's user avatar
0 votes
1 answer
15 views

SharePoint 2013 : link to DispForm corrupt

I use a list in SharePoint 2013. Clicking on the title normally opened my DispForm which I customized to my own needs. In my absense someone deleted stuff and tried to restore it without success. When ...
user14010662's user avatar
0 votes
0 answers
7 views

Users can only see/edit their own entry list: User can no longer view or edit their entry!

I have a list where users can only see and edit their own entry. 2 users cannot view their entry (let alone edit it) anymore. The page is "blank" - it has the name of the list for them, ...
Kelly's user avatar
  • 1
0 votes
1 answer
46 views

Hide "Favorite/Unfavorite" button in ribbon via list view format CommandBarProps

Need to hide majority of button in library ribbon - using "Format View" option and JSON editor work for every button.. except "Favorite" and "Unfavorite". Syntax ...
Kristaps Vilerts's user avatar
0 votes
0 answers
19 views

POST drop down custom column selected value into SharePoint list

I have build a custom drop down field using HTML, the values in dropdown choice are coming from SharePoint list using GET API. I also added button with name "AddItem" in front of dropdown so ...
Sourav's user avatar
  • 1
1 vote
1 answer
19 views

Conditionally Hide Show Fields On A SharePoint List Form

I am creating a SharePoint list in which I have list 'Invoice/Receipts'. I am doing conditional formula so that when the 'Cost Category' column value 'Travel' or 'Allowances' is selected, 'Invoice/...
Anonymous's user avatar
0 votes
1 answer
25 views

Week number within a month Calculated column

I have an Order date column, looking to add a calculated column that will show week number of that month. For example,4th April 2024 should show Week 1, 29th April 2024 should show as Week 5. Count ...
SeerBug's user avatar
1 vote
2 answers
20 views

Show a column if another column has a specific value in microsoft lists

On my list, when adding a new item, I need the visibility of one column field to be toggled based on value from another column/field (which is a multiselect type of column). For example column A value ...
Bialy778's user avatar
1 vote
1 answer
11 views

Microsoft Lists how change color if date is more than 6 months in the past

I'm trying to color a column item based on date value. I'd like to highlight date if it was > 6months in the past. Below is what I tried but doesn't work as text becomes completely hidden ...
Bialy778's user avatar
0 votes
1 answer
17 views

Filtering list on current month birthdays

I'm trying to achieve a Birthday calendar where only this month's birthdays are shown. I've seen countless of topics about this or similar questions, but I cannot replicate any of the code because I ...
FS305's user avatar
  • 3
0 votes
0 answers
17 views

SharePoint list how to create a view to display two columns with the same resource name

I am seeking for a navigation how to create filter or view in SharePoint list that will enable you to show the same resource name under items where such a resource is displayed in either the "...
Helena's user avatar
  • 1
0 votes
0 answers
15 views

JSON progress bar always full in SharePoint

Is there any way to show a progress bar under a text formatted as Accountability in SharePoint online? The progress bar must put in relation 2 values: let's call the first Amount Financed and the ...
Christian's user avatar
0 votes
0 answers
20 views

How can I programmatically set the value of an item in the new form of a SharePoint list?

I have a new form for a SharePoint list. this form should set some value through code. I'm using SharePoint on-premises 2019 designer new form. HTML code of the new form element: <tr style="...
user23646961's user avatar
0 votes
0 answers
18 views

Creating a Custom List in SPFx

I'm new to SPFx and my goal is to create a custom list. I've looked up various documentations and guides and videos but its still not getting the result i want. Not to mention most of the reference ...
Muerta's user avatar
  • 1
1 vote
1 answer
17 views

If two columns show no date, "Status" column shows "Incomplete"

I am very new to JSON. I have a document library, and I am trying to have a "Status" column populated with "Acknowledged" if two columns show a date, or "Unacknowledged" ...
Whitney's user avatar
  • 13
0 votes
1 answer
29 views

Ways to replace semicolon with comma or remove the semicolon

I have 10 document libraries with different numbers of records, from 500 to 20000. Under the Invoice Tracking Text column, users used a semicolon to separate entries; however, for some reason, I ...
Harris's user avatar
  • 593
0 votes
0 answers
10 views

SharePoint Online List - Sort by Multi select People Column

I have a requirement to sort a SharePoint Online list by a people column called "Owner". The issue is that this is a multi-select people field. Does anyone have a suggestion for how I can ...
Chris's user avatar
  • 403
0 votes
2 answers
26 views

How to change the background color of a list to red with JSON?

How to change the background color of a list to red with JSON? This is what I have: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", ...
user1903995's user avatar
0 votes
0 answers
10 views

SharePoint Lists and Excel

I have a SharePoint List of Training Competencies that I am importing into Excel. My intention is for the List to act as the master for all the competencies and an Excel sheet for each trainee. When I ...
MrArcys's user avatar
0 votes
0 answers
8 views

Use JSON row-formatting for my list to give additional rows a different color. But the color is not correct

I use this JSON code below to give additional rows a different color. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "...
user1903995's user avatar
1 vote
0 answers
13 views

SharePoint list form - Column conditional formatting in Swedish

I'm using SP in Swedish at work and want to add conditional formatting for show/hide columns on a list form. I want pretty much exactly this but translated into Swedish syntax: =if([$Category] == '...
WestanSmoothSailing's user avatar
0 votes
0 answers
4 views

Update document library folder when SharePoint list attachment is modified/updated

I have a SharePoint list. The list contains separate rows of issues. Each issue requires attachment upload from the respective person. There is a separate document library mapped for each issue. How ...
user111701's user avatar
0 votes
1 answer
22 views

Replace semicolon with comma in SharePoint text colomn

I am having an issue replacing the semicolon with a comma. I am using the JSON replaceall function to do this, and it looks like it does the job. However, you can still see the semicolon when you ...
Harris's user avatar
  • 593
0 votes
0 answers
15 views

Need Help . I need to determine the values in the "Final Status" column in a SharePoint list based on certain conditions involving other columns

I need to determine the values in the "Final Status" column in a SharePoint list based on certain conditions involving other columns. Here are the rules: If all columns (Billing Status, ...
Saran's user avatar
  • 1
0 votes
1 answer
20 views

Power Apps Converted Multi-select Checkboxes clear out after an item has been edited

I have a Power Apps form (customized SharePoint form), where I have a requirement to display a multi-select dropdown (Region) as checkboxes. The data submits correctly, and when a submitted item is ...
Chris's user avatar
  • 403
0 votes
0 answers
18 views

PnP PowerShell - Update list fields from CSV file

I have the following code and it has been working. Now our company merged and my computer is with the new company domain. New company don't have access to our SharePoint and it seems like it also want ...
maria's user avatar
  • 1
0 votes
0 answers
27 views

SharePoint list: Power Query only returns records Created By me

I have a SharePoint list where I am the owner with full access and I see all records in the web frontend. I have enabled item-level permission for normal users ("Read, create and edit items that ...
lorrydriver's user avatar
0 votes
1 answer
28 views

Advance search multistring in a SharePoint online list

Summary I would like to know if it is possible to input a collection of strings to search in a list. The search should be use by normal users. Scenario I have a SharePoint list called AnimalList. In ...
Alessandro Picardi's user avatar
0 votes
0 answers
10 views

Hello Techies , I want to get below output based on SharePoint list , I have emp list and the task list

I want to get below output based on SharePoint list. Everyday employees update daily task based on task list. Task list 1 - 30 min, task 2 - 20 min and so on. I want below output based on that input ...
Venkatesh's user avatar
1 vote
1 answer
13 views

How do I make a list date column turn mint green if the date entered is within the last 12 months and turn light red if it outside of 12 months?

I have a list made that tracks several employee training dates. We are currently entering the date they last tested/trained. Trainings are due every 12 months or every 36 months. How can I make the ...
George K.'s user avatar
2 votes
2 answers
30 views

Require column based on another column

I am trying to make it that my columns "Event location city" and "Event location country" are required ONLY if Event type is In person or Hybrid. Is this possible?
user111595's user avatar
0 votes
1 answer
22 views

How to create server-side pagination to get data in SharePoint list through SPFx-react?

How to create server-side pagination to get data in SharePoint list through SPFx-react? Current code I am using: import * as React from "react"; import { useEffect, useState } from "...
Ankit Sharma's user avatar
1 vote
1 answer
13 views

Make a lookup column in one list to show me the item that are on hand in another list

I have two list, the first one (tracker list) is a tracker or inventory of all the phones that I have on hands. Second list (request list) is for user request a phone by serial number. I want to ...
Alexander Soto Acevedo's user avatar
0 votes
0 answers
8 views

Issue with SharePoint List not showing all content in one column (rich text)

I am having issues with SharePoint List. It is not showing all the content on my SharePoint page. Is there a code I can use to increase the height? It is rich text and from what I have read, it is not ...
Brigitte's user avatar
0 votes
1 answer
33 views

JSON formatting - remove hyperlink in one view only

I have two views in a SharePoint Online document library. I want to strike-out and disable the hyperlink of column 'Name' if 'Retracted' column is true. I've carried this out using 'Format columns' ...
Orange Juice Jones's user avatar
1 vote
1 answer
34 views

Set list as home page

I now have a list and I want this list to be the home page. I want the list to be the very first thing a user sees as soon as he/she lands on the subsite. Searching the web I understand that in modern ...
user1375452's user avatar
1 vote
1 answer
10 views

Join multiple mails from output to send for approval

I have multiple person in approve list. My output result is: [ { "": "[email protected]" }, { "": "[email protected]" } ] I need to format it as: ...
Nikola's user avatar
  • 13
0 votes
0 answers
28 views

Clicking the SharePoint List Web Part title link opens two tabs

If you set a defaultClick action in JSON for a column in a list, two tabs of details will open in the List web part. Only Chrome and Edge on iPad and iPhone. Safari is fine. There is no problem with ...
Tetsuya Shirahama's user avatar
0 votes
0 answers
26 views

Update enhanced rich text column on SharePoint via VBA

I am using a ADOBD Connection as shown in the code snippet below to update a SharePoint list via VBA. It does not work for the "Description" column. I believe it does not work because this ...
Schrello's user avatar
0 votes
0 answers
12 views

Not sure why newly created Lookup type column [Update Date] is not auto-populating

Shouldn't the lookup operation automatically create a relationship between the common [Issue Index] columns (both type Number), then populate the [Update Date] lookup column with the matching values? ...
hic24's user avatar
  • 1
0 votes
1 answer
92 views

HTTP POST request to add Image to SharePoint List

I have the following image in a SharePoint library: I wish to insert this image into an Image Column as part of the metadata of a List called QSAR Analysis Data. TEST Flow to try and achieve this I ...
Nick's user avatar
  • 105
0 votes
0 answers
13 views

Build custom group headers and footers not working

The json formatting code provided by Microsoft at this page: List layout customizations under "Build custom group headers and footers" doesn't seem to work. If I remove the nested if(s) I ...
Jordan's user avatar
  • 1
0 votes
1 answer
13 views

How to do one GetItems call to SharePoint then filter the items inside the workflow

I have this SharePoint list named "WorkFlow Groups", which contain title and email, as follow: Now I want to do a call to get all the items, then filter the items by the Title to get the ...
microsoftdeveloperdesigner's user avatar

1
2 3 4 5
136