Questions tagged [column-formatting]
This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.
67
questions
1
vote
1answer
17 views
Column formatting with JSON add dynamic hyperlink
I want to format a column using JSON to add a Workflow Start LINK but can not change the element ID dynamically. Can someone please help?
{
"elmType": "a",
"txtContent": "",
"attributes": ...
0
votes
1answer
19 views
SharePoint column cell background color based on cell value?
i have one sharepoint list. i have one column called action, which is a calculative column drived value from other
i want if it's yes then it should be green or if no then red.
is it possible via ...
1
vote
1answer
27 views
Json in sharepoint column help
I am not a developer and need some help please. I currently have 2 columns in SharePoint that display buttons based on conditions. Both sets of JSON work just fine.
Basically I want to have only 1 ...
1
vote
2answers
34 views
Setting the background in JSON Formatting column to red
I have a field in SPOnline I want set to red to show against a progress bar. I thought it would be a matter of just adding a BG colour line but it hasn't worked. Any ideas? JSON below. Thanks in ...
2
votes
1answer
36 views
Format columns with numbers right aligned and with fixed decimals
I successfully added conditional coloring of cells in a column of a custom list using JSON.
So I have browsed several resources at M$ for formatting options.
E.g. column-formatting
I wasn't able ...
0
votes
1answer
77 views
Column Formatting to Show a Hyperlink or just Text Based on 3rd Field [duplicate]
PrimaryLink is to display a hyperlink based on the other 2 fields
PrimaryName
PrimaryURL
PrimaryLink
JSON for Column Formatting
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/...
1
vote
0answers
33 views
Formatting hyperlink type field with file directory path
By default, a hyperlink type field in a SharePoint Online list looks like a regular field. It's not until you hover over the text that you actually see that it's a hyperlink.
I am trying to edit/...
2
votes
1answer
14 views
Use a rich text column in mailto column formatting? [closed]
I'm trying to include a rich text column in this code. How do I reference the rich text column?
"elmType": "a",
"attributes": {
"iconName": "Mail",
"class": "sp-field-quickActions",
"...
2
votes
1answer
37 views
JSON Column formatting round to integer
I have created this script to calculate the number of days from today, but it returns like 20 decimals. How to round to a whole number?
I was trying to do this using floor() but I don't understand ...
0
votes
1answer
50 views
Lookup values invisible on QuickEdit (JSON formatted)
I hope you can help.
SharePoint Online:
Values on a Choice column appear colour formatted on QuickEdit view. However values in a Lookup column (values taken from a lookup list) are invisible on ...
1
vote
1answer
36 views
JSON Coding - Delve profile pictures not linking up in SharePoint List
Wondering if someone could take a look at my JSON coding on my SharePoint list to see why it isn't linking up the User's Delve account profile picture?
{
"$schema": "https://developer.microsoft.com/...
2
votes
2answers
56 views
SPO: Create Hyperlink from Calculated Column
I know there are several questions/answers for this, but I still can't seem to get it to work.
Name - Text
URL - Text
Link - Calculated Column Number
Link column
=CONCATENATE("<a href='",URL,"'...
0
votes
1answer
124 views
SharePoint Library Button (JSON formatting) to update current item field value
I have a formatted Single Line Text field in a SharePoint Library. It is formatted to be a button that executes a Flow. I've created this so I can attach this one flow to multiple libraries. It works ...
1
vote
1answer
30 views
Sharepoint link to Delve account
In the SharePoint list, I want to make a dynamic link to a Delve profile. I have a JSON like this:
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"...
0
votes
1answer
25 views
Status calculated column colour code
I have a calculated column with this below formula:
=IF(ISBLANK([Confirmed Receipt Date]),"Open","Closed")
How do I make Open with red color and Closed a green color?
1
vote
2answers
57 views
Barchart formatting in JSON/Column formatting
I am working on JSON/column formatting. I want to show column data in barchart format.
(e.g. In below image Progress is the column name and 100/75/50/25 are four different items.)
I know we can ...
0
votes
1answer
42 views
Insert bold in column formatting
How do I insert code so this will also become Bold?
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"debugMode": true,
"...
2
votes
1answer
28 views
SharePoint color formating
I have a Date column in the list and it represents Expiry date.
I need the field to be colored red if the date has passed, orange if the expiry date is less than 30 days, green if the date is more ...
1
vote
2answers
49 views
Can we call HTTP method from JSON Column formatting in sharepoint online
I want to update/change the status column value through HTTP Request(HTTP method that will call flow).
Do JSON column formatting support this HTTP method?
1
vote
1answer
22 views
JSON Specification for Column/View formatting?
I am new to column and view formatting but see the power for my users. However, despite the wealth of examples between Microsoft docs and GitHub and the schema itself, I'm looking for descriptions of ...
0
votes
1answer
108 views
JSON Conditional formatting for Column
I'm a bit of a noob about JSON and I want to use it to my benefit. What I want to do based on the attachment is the following:
Latin Qual Required? column is set to Choice setting and Latin Qual Date ...
0
votes
2answers
243 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
44 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
21 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
28 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
98 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
46 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
594 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
107 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
68 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
116 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
213 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
68 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
134 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 ...
1
vote
0answers
145 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
27 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
80 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
79 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
343 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
53 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
126 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
114 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
596 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
167 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
266 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
106 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
44 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
177 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
55 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
223 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 ...
