Questions tagged [list]
Rows of items containing columns of information.
6,653
questions
0
votes
1
answer
35
views
Filter By does nor have search option in SP List
In my column header drop down in list view, when I choose "Filter By" option, there is No search option, Only check boxes.
There are different column types and in neither of them I can type ...
0
votes
0
answers
16
views
Listings are not loading in a SharePoint list
I have a list in SharePoint that is grouped by the first variable.
It is 17 groups in total. Now 3 of the groups are just spinning when I try to retrieve their listings. It is the listings in the same ...
0
votes
1
answer
19
views
URLs in list become outdated when adjusting file name in site-content
I have a list on my SharePoint site containing URLs to the contents of the site, namely URLs to files in a directory within Documents.
So something like
Documents
|- subdirectory
|- file_a.pdf
...
0
votes
0
answers
28
views
Could not load SharePoint Online List - Expected double-quoted property name in JSON at position xxx (line xxx column xxx)
Sometimes SharePoint Online throws me an error like this - Expected double-quoted property name in JSON at position xxx (line xxx column xxx), I mentioned the Image below.
It's a throw only ...
1
vote
1
answer
16
views
JSON to Show Time Until a Specific Timestamp - SharePoint List
I have a list of participants in a conference. All participants are arriving and departing on numerous different flights. I am trying to create a Power Automate flow that will send a Teams message as ...
1
vote
1
answer
14
views
I want to retrieve SharePoint report using API & JSON. For example for getting the number of Applications between a set time period from list
I need to generate or retrieve report from a SharePoint list using API endpoint. I believe we can request it in JSON by setting the Request headers to "Accept", "application/json; odata=...
0
votes
0
answers
13
views
SharePoint List Syncing Issue
I am reaching out regarding a challenge I've encountered with a SharePoint list on our team site.
I recently created a SharePoint team site and configured a list within it, which I connected to a ...
1
vote
1
answer
14
views
Changing color in calendar view to show different locations
I would like to visually show when the locations are different.
So I have 2 rooms that we use Room 1 and Room 2 (location is a free text value but we would use the same text).
I would like these in a ...
2
votes
1
answer
22
views
SharePoint List Person Column should not be blank
I have a Person Column in my SharePoint List that is set to only show in the SharePoint List Form if the value of the Person column is not equal to the email address of the SharePoint List user.
My ...
0
votes
0
answers
4
views
Recreating Dates in Sharepoint to show Workdays instead of Dates
I am creating a calendar in sharepoint based on workdays for my company. The way it works is: the first date i.e Oct 1 is Workday 1 unless it falls on a Saturday or Sunday and in that case, it would ...
0
votes
1
answer
25
views
SharePoint Groups Magically Adding Themselves to Site Collection
Please can anyone help?
We have a single SharePoint Site Collection in a massive tenant.
Under People and Groups, we keep seeing the following groups being added: All Users (Windows), Everyone, ...
1
vote
1
answer
18
views
In SharePoint list, how to add a table like excel where you can fill up information as you want?
like add a mini excel table into the list because columns are limited for entering more information
is there some coding that can make it happen?
1
vote
1
answer
51
views
How to get lookup column value in single line of text
I Want to display lookup column values in single line of text. ProductName lookup column with multiple selection. I tried using JSON column formatting but values are not showing. Please can anyone ...
2
votes
1
answer
66
views
SharePoint List Conditional Formula not working
I'm having an issue with the SharePoint List conditional formula. I'm trying to show the Resignation with Notice field only when Job Movement Details = Resignation.
Below is the formula that I used ...
1
vote
1
answer
19
views
SharePoint Lists - edit columns not hiding/showing
I have a choice column named "Catalogue". one of the choices is Digital. I have another choice column named Digital Strategy Areas that I only want to show when Digital is selected from ...
2
votes
1
answer
51
views
How to create a calculated column to pull the year of Date column 1, and if blank, pull year from Date column 2, if that's also blank then put Hold
I am trying to create a calculated column that looks at the Date1 column and pulls only the year into the new column. If the Date1 column is blank, then bring in the Date2 column. If Date2 column is ...
0
votes
1
answer
25
views
conditional formatting based on status of the field and date sharepoint
im trying to do conditional formatting in ms list based on status and date. These 2 are in different columns(names of the columns Milestone 1 Due Date and Milestone 1 Status. I have a 4 possible ...
0
votes
1
answer
39
views
Setting up an email reminder based on dates in excel sheet
I've been asked to find a way to have an excel spreadsheet (that will be updated often) send an email to the email address from a column, as well as on a specific date according from another column. ...
0
votes
0
answers
12
views
SPFx Field Customizer - issue with loading customizer, manifest not found
I implemented field customizer for list, tested it locally where it works, and then deployed to Sharepoint Online.
There I have following issue:
Fail to load customizer for column: myColumn, ...
0
votes
1
answer
17
views
Adding a semi-transparent cover on an image in a SharePoint View?
I have a custom JSON view in SPO.
It displays an image (the same one each time - don't ask! this is what someone wants!)
I would like the images in the view to show a 50% transparent shadow on hover (...
0
votes
0
answers
13
views
Format field if not all choices are chosen
For my use case, I want to have an overview of finished tasks. One part of this list should be if all the responsabilities have been informed.
I'd like to make this a choice list, as it allows the ...
0
votes
1
answer
21
views
Inheriting metadata upward?
Is it possible to have a parent folder inherit metadata from child elements, i.e. upwards?
For example:
The folder "folder" contains "file.txt"
The column is "Language"
...
0
votes
1
answer
19
views
How to add new item to a list (L2) from another list (L1) when my L2 is a column?
I have a principle list in SharePoint (L1), this list contains a bunch of columns, one of the columns is also in a lists (L2).
I would like to be able to add a new items to L2 from inside my principle ...
1
vote
1
answer
38
views
SharePoint Online - FAQ List Colors
I am building a fairly simple FAQ for my team's website. I've got the list setup and the JSON formatting in place but I am trying to get the main column headers to display in a different color than ...
1
vote
1
answer
23
views
Making required condition in SharePoint list dependent on another field
I have a SharePoint list with several choice, date, text and yes/no fields. I want to make some fields conditional on another field containing a certain word.
So for example, I have a field called '...
0
votes
1
answer
18
views
converting a semi-structured excel database into a sharepoint database
Our company has an excel customer-record cheat sheet. we're trying to integrate that cheat sheet into SharePoint. However, the sheets in the excel cheat sheet are not relational structured data. Some ...
0
votes
1
answer
43
views
Share a list between multiple SharePoint sites
In our company we have departments. Each department has is own SharePoint site. However the departments list should be unique for all the sites.
Is there a way to share the "Departments" ...
0
votes
1
answer
32
views
SharePoint adding 2 zeros to the percentage values in my list
In my SharePoint list, I have a 'Number' column with the 'Show as percentage' option checked.
Unfortunately, for each value in this column, SharePoint adds two zeros, so instead of '100%', it shows '...
0
votes
1
answer
24
views
Filter a SharePoint list by URL parameters and OR combining filters
my goal is to create a URL that filters a SharePoint list with two filters that are logical OR combined.
What I have so far is:
AllItems.aspx/?
useFiltersInViewXml=1
&FilterFields1=Data1
&...
0
votes
1
answer
16
views
Calculated Column next date
I am trying to add a calculated field to a list that takes another field (which allows multi values) and picks up the next date.
See Below - Meeting ID is a lookup from another list and is populated ...
0
votes
2
answers
22
views
Hide Visibility of PowerApps Form Container Based on Name in Field
I have an approval flow that updates a field after an outcome with the name of the approver. The field name is Approver. Its a single line text field.
What I'm trying to do is check to see if the name ...
1
vote
2
answers
38
views
SharePoint Online List view is not showing Item with Group By" filter
In my SharePoint Online List, One of the views is having a problem as given below:
Adding One Filter to get specific data --> Item shows as expected.
Try to add a "Group By" filter, --&...
1
vote
0
answers
15
views
Workaround for 19 'IF' in a Calculated Column
I'm hoping the community can help me! I'm relatively comfortable working with Sharepoint Lists, however, formulas are a fairly steep learning curve for me. I have been working on a risk register for ...
0
votes
0
answers
16
views
Conditionally show/hide field based on content of field in EXTENDED lookup column
Problem: I want to show/hide a field based on the content of a field in an EXTENDED lookup column.
I have the following two lists:
LIST 1: "*Opgaver*"
COLUMN: "*Opgave*"
COLUMN: &...
0
votes
1
answer
18
views
SharePoint Online Modern Form Conditional Formatting (Column Rules)
I am working on a SharePoint Online Modern Form solution using the OTB conditional formatting. There are three rules that I am trying to apply, here is the example.
Two Columns:
COL1 - Choice Field - ...
2
votes
2
answers
56
views
JSON code for SharePoint List conditional formatting - check for value in a single line text cell
I don't know any JSON at all, I work at an IT help desk and am trying to do a little advanced conditional formatting for our SharePoint list, which contains a user database of sorts. We're currently ...
0
votes
1
answer
29
views
Patch new record with lookup column Power Apps
How to create a new record in SharePoint list with a lookup column from a button?
SharePoint list "tbl-one" has a lookup column "Contract" and other columns "Title" and &...
0
votes
1
answer
43
views
How to format User().DisplayName to display the same as People field
I have a SharePoint form, customized in Power Apps, where I need to hide a group of fields if the current user = user identified in people field.
Basically I have a requestor field (people field) at ...
0
votes
1
answer
22
views
Is it possible to filter based on a custom column in a Calendar View?
So I have a simple SharePoint List with some custom columns of type "Single line of text", such as "Client Name". When I am in the Calendar View, I only have very limited filtering ...
0
votes
0
answers
13
views
Is there a way to create subsite based on another one, copying lists and workflows for them,..?
In Sharepoint Online, I'm trying to create a button that will trigger creating subsite and have all the lists and workflows based on one main list in root site.
E.g. there is two lists in root that ...
1
vote
1
answer
68
views
How can I show Attachment Name and preview in SharePoint List
SharePoint List view:
I want to see a preview of the Attachment file in the list and the name of the attachment.
Please share if you have any ideas about this or reference.
1
vote
1
answer
33
views
SIMPLE Column formatting in SharePoint list (SP2019)
I have a pretty basic SharePoint list on a page at work and I simply want columns to be colored yellow (Is it "#ffff00" ?).
In my "List Settings" I select the column I would like ...
0
votes
1
answer
22
views
SPO JSON - Copy Multiple People Field Emails as Text in New Text Field Commas Separated
Based on this great solution, I am looking for JSON column formatting to copy a multi-person field (people picker), displayed as email
into a text field
displayed as raw text email format
comma ...
0
votes
1
answer
56
views
JSON Formatting to show last item select from multi selection choice field
I'm trying to create a new field that displays the last item select from another Multi selection Choice field. We currently use a choice for Portfolio Years which show as a string of values selected.
...
1
vote
2
answers
38
views
SP List - JSON to change font for column list entries
I have a Power Automate flow set up to copy email to a SP list, the column is set to rtf so that the list just has the email body rather than all the (I'm guessing) HTML stuff plain text gives but I'd ...
1
vote
1
answer
25
views
Change the text color only on specific numbers in column
A little help please! I created a SharePoint list with company contacts and I want in column 'length of service' the numbers 5, 10, 15, 20 etc. years to be marked a different color, for example red.
0
votes
0
answers
5
views
Lists - Separate Views for External Users
First off - some what new to Sharepoint.
Creating lists to manage some dynamic data etc.
We share this list with external users (clients).
I understand views for the most part. Non-public views are ...
0
votes
1
answer
38
views
Specify the choices of the choice column in the JSON-code
I have a Choice column in my SharePoint list, with these column choices set:
Niet verzonden
Aangevraagd
Goedgekeurd
Afgekeurd
What i am trying to accomplish is to create a button from that Choice ...
0
votes
1
answer
30
views
How to turn the column choices into a button?
What I would like is to create a button from the choice column. So the user can not select a choice by himself. But triggers a power automate flow by pressing on the button. So how can I turn a choice ...
0
votes
1
answer
28
views
JSON doesn't show the names of the choices in the choices column?
I have json code set for the choice column which is also a button.
My code doesn't display the names of the choices! What do I do wrong:
{
"$schema": "https://developer.microsoft.com/...