Questions tagged [column-formatting]
This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.
44
questions
0
votes
2answers
23 views
Formatting multiple values in people and group fields on SharePoint Online with JSON
Wondering if anyone can help me out with figuring out the formatting my multiple values person field on my list. I cannot figure out how to space out the names of each individual under the "...
0
votes
1answer
22 views
Make a column no background colour if no value
I want the columns with no value in it to be blank. What should I add to my formula?
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"...
0
votes
1answer
18 views
Change the color of a item if it has been edited
I have a SharePoint list created and would like the item "Did Operations Respond?" to change color depending on if another field "Ops Response" has been edited in that same row.
I cant figure out how ...
0
votes
1answer
24 views
Person and group multible selections separate names
So I got this problem where the names stands after eachother, is there anyway to move Alexanders name under Jonas?
See picture:
1
vote
0answers
26 views
Writing numbers comma separated in JSON
Following a tutorial: SharePoint modern view formatting with JSON
I realized that formatting a column with numeric or currency values are shown like strings. In this case I have the "Price" column ...
0
votes
0answers
41 views
SharePoint Online - JSON Column Formatting
I have a List Lookup in my form. This gives the user the ability to choose multiple unique values.
The problem I am having is that the values are being translated back on to the SharePoint list with ...
0
votes
1answer
31 views
Display HTML formatted text from Rich Text multi-line column in SharePoint list column formatted with JSON
In SharePoint Online modern page I am trying to remove the styling that causes a white overlay and hides most of the text using the following JSON column formatting, so that the column height will be ...
2
votes
1answer
29 views
Vertical Alignment in List column
I have an InfoPath form that a user fills out and in one field they type an email address. The information is collected in a list. All of the columns but Email automatically aligns the standard way. ...
2
votes
2answers
39 views
Set column height equal to height of record in List
I have a SP list where one of the columns is multi-line I have therefore set the style of this specific column as "height":"auto" which works perfectly for this column.
I then have other formatted ...
0
votes
1answer
36 views
SharePoint Online: JSON column formatting for “Shared With” column not saving?
Using SPO, I can get JSON column formatting to work on my library. However, any formatting I apply to the "Shared With" column works in preview mode but does not save with the view.
I think this is ...
0
votes
2answers
57 views
Apply background color to list using column formatting based on text
I have a SharePoint calendar/list that I am using to track employee absences across numerous accounts. What I would like is when I'm in list view to have each row that represents a different account ...
1
vote
2answers
40 views
JSON Column formatting : retrieve view ID or param in URL
I need to retrieve view ID (or Name) to format a SharePoint list column with JSON formatting.
Or at least I should be able get the correct query parameter of the URL.
Is there any variable available ...
0
votes
1answer
38 views
Get value of Name column from SPO list for JSON formatting
First of all, apologies if this horse has been beaten before but I can't find anything so far to help me out.
I'm trying to do some conditional formatting of a column in a SP list.
One of the ...
0
votes
0answers
61 views
SharePoint Online multiline with append - JSON formatting
In SharePoint Online I have a multiple lines of text column that has append checked.
Instead of showing "View Entries" in multiple-line text column with append-only checked, will show all entries or ...
0
votes
1answer
21 views
Json Formatting
I am in a position where all I want to do is change the font color of a column to #002c77 no matter what the text within the text field says. I cannot for the life of me get it to work, and there I am ...
0
votes
1answer
35 views
Trigger flow inside SharePoint
I created a flow from my SharePoint library - Flow -> Create flow.
The flow takes a Word Document template and populates it with input from the user (manually trigger flow). It works, but I can only ...
0
votes
2answers
29 views
Column formatting dates (including blank values)
I'd like to create a column formatting where values should be:
Green if expiration date > now()+60 days
Yellow if expiration date < now()+60 days and > now()
Red if expiration date <= now()
No ...
0
votes
2answers
135 views
Apply the friendly date format to a calculated column in a SharePoint list
I have a calculated column [Due date] with a simple formula, =[Event date]+13, and it's set to The data type returned from this formula is: Date and Time.
However, it doesn't have the Display Format:...
0
votes
0answers
30 views
How to make field as Read-Only inside Quick Edit list view when using modern UI
I have created a site column of type Single link of text, and i hide it from the New & Edit forms using this PnP script:-
$customfield.SetShowInEditForm($false)
$Context.ExecuteQuery()
$...
-1
votes
3answers
53 views
Organize multi-choice user inputs by separate line (not comma)
I would like to format a column, so that when a user selects multiple choices, each choice is displayed on a single line rather than separated by comma (,).
I'm looking to leverage JSON formatting ...
2
votes
2answers
44 views
How to utilize “if” condition in a link using JSON column formatting in SharePoint?
I am trying to remove all of "AAA" links from a link column called "LinkList" using JSON column formatting.
"AAA" is a link not text. I am in trouble to hide all of this kind of cells in that column.
...
2
votes
2answers
213 views
SharePoint Column JSON formatting alignment
As mentioned in the Title I have some issues with trying to align my background color formatting as shown in the screenshot below:
What I hope to do is to get the BACKGROUND COLOR to align WITHOUT ...
1
vote
2answers
90 views
SharePoint Column Formatting: Referencing External Columns in Mail To Body
Hello Stack Exchange Community,
I have a question regarding referencing external columns. In my code below, external columns are referenced using square brackets as specified in Microsoft's online ...
0
votes
1answer
157 views
How can JSON column formatting be used to highlight duplicate entries in a column a list?
Column formatting is used in SharePoint Online to customize how fields in lists are displayed. Microsoft provide documentation regarding the use of JSON for column formatting.
As is described in the ...
1
vote
2answers
68 views
JSLink Column Format is not taking action
I have a list of type Classic Experience that contain column "Status" assume the following values: Approved, Pending, and Rejected. Each of these values contain a color format based on Javascript code....
0
votes
0answers
38 views
Color based on value in SharePont Online task list (added app)
Using SharePoint through my company's 365 account, had a need for a clean list with parent/child relationship, the subtasks in the Task List app fit the bill nicely, out of the box, but now I feel my ...
0
votes
1answer
97 views
sharepoint column formatting json examples with paging
I was thinking if I had a list in Modern UI and then use JSON column formatting.
Does it support paging or sorting through the items?
Thanks in advance.
0
votes
2answers
38 views
If current field (target closure date <= today AND Status = “Open”(This is drop down option)), then text should display in red color
If current field (target closure date) is <= today AND Status = "Open"(This is drop down option), then text should display in red color.
I have tried with below JSON but no luck:
{
"$schema": ...
1
vote
0answers
150 views
SharePoint Column Conditional Formatting - Applying CSS classes to a date field using a nested IF statement
Apologies, I am relatively new to SharePoint/JSON, So forgive me if I am not seeing the obvious. I would be INCREDIBLY grateful if someone would help.
I would like to apply conditional formatting to ...
0
votes
1answer
63 views
Sharepoint JSON not saving
I am just adding some JSON code to my columns to change the text color. All columns work as expected, but one ("Doc. #", a completely vanilla single line text column) keeps removing the code ...
1
vote
1answer
63 views
Addition of 2 column values and displaying 3rd Column in SharePoint Online modern site
I am using SharePoint office 365 modern site, I have to perform some business calculation and display the results in different column and get the sum total for this.
Scenario 1:
ColumnA with value ...
0
votes
1answer
90 views
SharePoint modern view formatting with JSON
My style is accepted but it overrides the ATTRIBUTES: Class.
How would you suggest I take advantage of incorporating the if(indexOf(@currentField inside the STYLE - which will allow me to do a ...
0
votes
1answer
296 views
Help with JSON to format column to show picture instead of URL
I have a contact list created in SharePoint Online.
My list has a column called "Picture URL".
The "Picture URL" column is formatted as "Single line of Text".
I have formatted the "Picture URL" ...
0
votes
1answer
20 views
No Column formating template
I am trying to add a column format template , basically marking the column “red” when the column is set to “No” and “blue” for when it is “Yes”.
My custom columns, they don’t have the option to ...
2
votes
3answers
284 views
what can you do with Format View
I’m playing with modern experience and inside the document library. I found this option format view .
What can you do with this ? what are the possibilities ?
1
vote
2answers
205 views
Help to amend existing JSON to add a vertical align element
I currently have the JSON formatting applied to a column:
{
"$schema": "developer.microsoft.com/json-schemas/sp/…",
"elmType": "div",
"txtContent": "=if([$Review_x0020_Status] == '', '', '•')",
...
2
votes
1answer
132 views
Help with Traffic Light SharePoint Calculated Formula
I am wanting to create a column called "Traffic Light" on an existing SharePoint Library.
Column Name = Traffic Light
Data Type = Single line of text
Formula:
="<DIV style='font-weight:bold; ...
1
vote
2answers
123 views
How to change the format of the column Person in a contact list
When I use a contact list with a column "Person" it displays the person's name and last name in a certain format.
Ex: Melone (Jack)
But I just want the first name and then the last name.
Ex: Jack ...
1
vote
1answer
268 views
I am looking for a JSON query to format Currency column in SharePoint Online
I am looking for a JSON query to format Currency column in SharePoint Online. Below query works but removes currency icon from the value.
{
"$schema": "http://columnformatting.sharepointpnp.com/...
1
vote
1answer
319 views
JSON datetime tracking custom formatting
I am trying to format a sharepoint list with JSON so that the From/To column highlights the current phone number when todays date falls into the timespan given.
I have managed to have past on future ...
0
votes
1answer
148 views
Reference Metadata field with JSON Formatting
I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value?
{
"elmType": "a",
...
0
votes
1answer
206 views
Column Formatting Option not available
I can't see an option for format column where I can enter JSON codes.
0
votes
0answers
730 views
SP Lists - JSON Conditional formatting based on other columns
I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns.
Here is what I was trying to set up:
(1) IF @ColumnName1 = "status 4" THEN @...
0
votes
1answer
2k views
How to utilize if/else condition for JSON column formatting in SharePoint?
I am trying to format the color of a column based on the selection of another column in the same View. But, I am having trouble writing the JSON to check for multiple values in the other column. Here ...
