Questions tagged [column-formatting]
This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.
127
questions
2
votes
1answer
33 views
List - Conditional formatting of a “cell” based on another cell in the same row
I have two columns: "LFR sign" and "Filing".
I would like to:
If the "LFR sign" is not empty -> "Filing " becomes red if it's empty
I am sure this is quite ...
1
vote
2answers
64 views
SharePoint Online JSON formatting - Conditional Popup
I've created a custom view that includes a popup description of each file in my SharePoint library.
This works well when I'm within a sub-folder that has a list of files, but when I navigate to the ...
1
vote
2answers
34 views
Hiding single column header
I would like to hide a single column header in a sharepoint document library list, does anyone know if there is JSON code that can do this?
I know I can custom format the overall view using:
{"...
0
votes
1answer
36 views
Sharepoint Lists - Traffic Light Calculated Formula & Format for Dates
I am trying to create a Traffic Light system within SharePoint Online (Office 365) using JSON.
The dates should run in accordance to said, Traffic light signal.
What I'm trying to do:
If "Todays ...
0
votes
1answer
26 views
Modern library, document defaulted to be read only when opened, edit with user choice by column formatting
I have tried in two ways as below. Both are working for Office documents. But When clicked on PDF or video files, are not opening, its redirecting to document library itself. Other than office ...
0
votes
1answer
38 views
json view formatting, wrap all items
I want to basically wrap all my items in one div for a view. So the json I am using:
"rowFormatter": {
"elmType": "div",
"style": {
"display": &...
1
vote
4answers
38 views
SharePoint Column - Conditional Formatting
I basically have a calculated column that shows the date 1/29/1900 if there are some empty values in the other columns.
Is there a way to use JSON formatting to format it so that if the column ...
1
vote
2answers
62 views
How to convert text to URL in multi line text
I've used the multi line text column in SharePoint, where I want the fields to be clickable.
and I used the following JSON:
{
"$schema": "https://developer.microsoft.com/json-...
1
vote
3answers
53 views
Conditional Formatting ( Color Coding) a date field
I am using the JSON Script below to create a list where records with Expiration date 10 days from @now will highlight RED; 20 Days from @ now will Highlight Yellow, and 60 Days From @ now will ...
1
vote
2answers
44 views
Conditional Formatting with JSON - Write to Actual Value?
I'm pretty new to JSON.
I have a SharePoint list with employee schedules (shifts) as seen below:
My OnClock column uses the following to determine if (now) time is within the stipulated shift start ...
1
vote
1answer
31 views
JSON SharePoint list view - background-image doest not work
I found in documentation that "background-image" is supported attribute but I am not able to use it. Maybe I am doing something wrong. Could you help please, how to use "background-...
1
vote
1answer
37 views
Clickable href with the attachments
I have a list with the following columns:
Job Description (Single Line of Text)
Attachments
And also I got a Column named "internLink" which contains the exact name of the document which ...
1
vote
3answers
80 views
Add multiple line breaks to look up column in which multiple values are allowed
I have a specific question regarding line breaks in SharePoint online lookup columns in which multiple values are allowed. I would like to separate each of the values from lookup via a line break.
I ...
1
vote
1answer
23 views
Sharepoint column formatting with IF in href attribute
I got this problem:
I got a column named "TrackingNumber". In this column I want to be able to click on the displayed Number.
The extra feature is, that in another column, there is the ...
0
votes
2answers
104 views
tooltip column on hover a column in SharePoint List Using JSON- Modern List View
I need to show the description of column as a tooltip when a user hover a mouse on a column, I am doing this based on Adding custom hover text using json to a SharePoint list column
But I need to ...
1
vote
1answer
19 views
SharePoint people picker columns not showing as hyperlinks in modern view
I've got a SharePoint list which has a People Picker column allowing groups.
In SharePoint 2013 and in classic experience, I am able to click the group name to be taken to the group members list (and ...
0
votes
1answer
76 views
SharePoint conditional formatting rule only available for date, how to include time in the rule?
I'm new to SharePoint. I have a SP list for my schedule. I have overdue column that I would like to change background color based on Datetime column and status. The two column are Deadline and Status. ...
0
votes
2answers
48 views
JSON column formatting - Format date column to remove minutes using in an IF statement?
I am trying to format a column that reacts to a value from another column, one of the columns "Projected End Date" is a date format. This has the column formatting applied and when an ...
1
vote
1answer
62 views
color formatting a date column
I'm very new at list formatting. I've created a new list and are trying to get the columns to turn red/green/yellow depending on the date that you put in to the date-column.
I want the column to turn:
...
0
votes
1answer
52 views
I am working on a microsoft flow which updates a column on the basis of another column
Here is the screenshot of the source and destination:
1. I am working on a flow which updates a column SME Comment CK on the basis of another column SME Comment. These columns are multiline text. but ...
0
votes
1answer
137 views
Conditional formatting based on number of days to due date
In SharePoint 0365, in the modern experience, I have a list of
contracts that have an expiration date.
I would like to use conditional formatting to create a status
column that shows me the contract ...
1
vote
1answer
238 views
Adding custom hover text using json to a SharePoint list column
I have a SharePoint list which has a Title column and a Description. The Description column is a multi-line text field.
I would like to not display the Description column and instead show the relevant ...
2
votes
2answers
34 views
Sharepoint column formatting carried over in all views
I have SharePoint list with multiple views (in modern experience) and when I format a column in one view, the same formatting is applied to the column on all other views.
How do I break this and have ...
0
votes
1answer
31 views
SharePoint Online - Display RTF in column
I'm trying to display RTF in a column in SharePoint Online. Regardless of what changes I make to the column the RTF formatting is displayed as Plain Text. I have enabled RTF on the column:
But it ...
0
votes
1answer
40 views
SharePoint Online Conditional JSON formatting
New to this, real Noob.
I have a SP list column named rating, based on the value I need to change the cell color.
Value 1 to 3 - Green.
Value 4 to 6 - Yellow.
Value 8 to 12 - Orange.
Value 15 to 25 -...
0
votes
1answer
36 views
Complicated If statement column format
I've been struggling with this for a few days now and wondered if anyone could help!
I have a SharePoint list (attendance tracking) with 4 date columns:
Arrival Time (this is filled-in using [Today] ...
2
votes
1answer
49 views
Display different flow buttons in sharepoint list with time condition
I have a list where an item can have different statuses (Draft, Planned, Updated and finished)
I wanted 3 different flows to be able to run, so the buttons are:
When Draft: [Send item]
When Updated: [...
1
vote
1answer
27 views
Email signature not appearing in body when mailto used
Is it possible to have the person who clicks on the link to display their signature?
Currently when I click on the link it opens Outlook but doesn't display the signature. In Outlook signature options ...
1
vote
2answers
156 views
JSON - Conditional Formatting - SharePoint - Not Null
New to JSON. Trying to write JSON when ever a free form text field is filled out, have this but don't know how to get it to highlight when anything is entered. I do not want highlights on blank items:
...
1
vote
3answers
1k views
Date format in JSON view formatting
I'm formatting the view of a large list in SharePoint. One of the many columns is a date column.
I'm using the following code:
{
"elmType": "span",
"txtContent": "[$...
0
votes
2answers
58 views
Why I can't switch to design mode when formatting a column in a list?
I am using Sharepoint 2019 and I would like to do something like this as mentioned in MSDN:
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
And I have a ...
2
votes
2answers
556 views
JSON column formatting hover styling
I'm creating a custom formatting for the Title column of a document library so that users will always download the documents instead of opening them directly.
It's turning out well, but I can't figure ...
0
votes
1answer
37 views
change image in column and row
In the image I have two logos the same within one column but I would like to be able to change the image in the highlighted area so no two images are the same within the document library.
I would also ...
0
votes
1answer
140 views
Access information in hidden columns with JSON formatting
I am trying to format a document library in our SharePoint Online platform.
The goal is to have a row with a video thumbnail, title and short description. The title is not the same as the video file ...
0
votes
1answer
35 views
Masking a text field with JSON
I have searched for examples of JSON scripts to format a column output in a view and can't find anything for text field manipulation.
In Excel I would use this formula:
=concatenate("XXXXXXXXXX&...
0
votes
1answer
130 views
Column Formatting - HideSelection disable JSON Formatting
After one week waiting for a Solution from Microsoft, I need to ask.
In About 5 SharePoint Online Tenants the JSON Formatting in Sharepoint lists stopped working.
I Debugged the Scenario and find, ...
0
votes
0answers
20 views
Re-formatting SP Column Date values to required outputs for use with MS Word Quick Parts
firstly I would like to apologise for the lengthy first post, hopefully I can make it as concise as required.
Background - working on a company project involving Salesforce (Front end) and Sharepoint (...
1
vote
3answers
217 views
SharePoint column formatting with json for date fields
I am trying to set custom formatting for date field and followed the guide here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-conditional-...
1
vote
1answer
37 views
Icons will not appear on SharePoint Site
As you can see below in the Status column I have the desired colors in the correct manner however for some reason I cannot get the icons to work next to them, the originally worked and now they wont ...
2
votes
2answers
695 views
Sharepoint JSON formatting - show button A or B
I want to show button A or button B in a column depending on value in another column.
one button should start a flow, another button should launch a hyperlink also I need to add other buttons.
I have ...
0
votes
1answer
21 views
Editing Format of an attribute in SharePoint list is different from its viewwing format
I am working on a list and the format of a column is currency and currency format is $NZ and it shows the values as it's supposed to (e.g. $123,000), but when a user wants to enter a new row or edit ...
0
votes
2answers
24 views
Simple If-Then-Else formating SharePoint list (json)
The code below I want use to change color of the column Date according to the current date.
But instead it gives me a error. Can somebody give me a hint?
{
"$schema": "https://...
0
votes
2answers
90 views
Need help with Conditional Column Formatting on SPO
I have a Choice column (Yes,No) and the default value is blank. I can get the Yes/No values easily and change the colors (Green/Red) but I need the 'Blank' value to be white. I need help with this ...
0
votes
2answers
48 views
Custom column formatting: Display an array of elements conditionally
In SharePoint Online, I have a list with a column that uses custom column formatting.
I want to display one of two sets of flow buttons, based on the content type.
I'm trying to use the {"...
0
votes
1answer
25 views
Sharepoint JSON conditional syntax help
I am trying to make the text say Expired or Current compared to a date column OR stay blank if the date column is blank. So far, I have:
"txtContent": "=if([$ExpiryDate]) == '', '' , ...
1
vote
1answer
219 views
Disable SP List column using JSON
Hope someone will be able to help me on this.
I'm looking for a way to disable (having it read only) a List column using some JSON formatting.
I know I can do it using additional calculated columns ...
0
votes
1answer
59 views
Displaying Column Description on Hover without SharePoint Desinger
Is there a way to show the description of a column of a SharePoint online list when the mouse is hovered on in the modern experience without SharePoint Desinger?
Maybe similar to this one (https://...
1
vote
1answer
87 views
Add a Flow button in a SharePoint library
I have recently added a Flow button in a SharePoint Library. I found the code on internet (I have no experience in JSON).
I would like the button to be visible if:
Document status (choice column) is ...
0
votes
1answer
64 views
Open local app from button on SharePoint Online list
On a SharePoint Online list I would like to add a custom button.
This button should open a local application (like Word).
When I try in my browser
ms-word://
I get the notification that my browser ...
1
vote
1answer
48 views
Definitive list of object properties available through column formatting
I have been referring to:
Use column formatting to customize SharePoint
And also reading multiple blog posts around the subject.
I have not yet found a definitive list of object properties ...
