Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
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 ...
M_SP's user avatar
  • 1
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 ...
LMR's user avatar
  • 1
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 ...
Stefan Verweij's user avatar
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 ...
Ashish Prajapati's user avatar
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 ...
matt's user avatar
  • 11
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=...
Gothaam's user avatar
  • 11
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 ...
Sanket_SK's user avatar
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 ...
Iuliana Iurea's user avatar
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 ...
Tet's user avatar
  • 21
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 ...
Zack's user avatar
  • 1
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, ...
user15450601's user avatar
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?
James's user avatar
  • 11
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 ...
Lucky's user avatar
  • 13
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 ...
Petri's user avatar
  • 41
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 ...
knowlec's user avatar
  • 13
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 ...
kendallyn's user avatar
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 ...
Michaela's user avatar
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. ...
Guest G's user avatar
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, ...
private7's user avatar
  • 123
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 (...
Pete Whelan's user avatar
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 ...
Brtrnd's user avatar
  • 1
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" ...
colonel_claypoo's user avatar
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 ...
Nacim Idjakirene's user avatar
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 ...
Dominick's user avatar
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 '...
21200506's user avatar
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 ...
start's user avatar
  • 1
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" ...
serge's user avatar
  • 133
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 '...
Lukas's user avatar
  • 45
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 &...
Finn's user avatar
  • 103
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 ...
Glitter's user avatar
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 ...
Mile T.'s user avatar
  • 155
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, --&...
Md. Tahmidul Abedin's user avatar
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 ...
Simon 's user avatar
  • 11
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: &...
rabbitco's user avatar
  • 101
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 - ...
Travis Horne's user avatar
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 ...
user3081579's user avatar
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 &...
Bra Tabs's user avatar
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 ...
Chris's user avatar
  • 371
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 ...
estranged's user avatar
  • 103
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 ...
private7's user avatar
  • 123
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.
Ashish Prajapati's user avatar
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 ...
James's user avatar
  • 11
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 ...
ChasEpes's user avatar
  • 103
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. ...
Beruken's user avatar
  • 23
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 ...
eagleaye's user avatar
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.
Keit Eigla's user avatar
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 ...
Dan Tappin's user avatar
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 ...
user1903995's user avatar
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 ...
user1903995's user avatar
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/...
user1903995's user avatar

1
2 3 4 5
134