Questions tagged [column-formatting]

This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.

Filter by
Sorted by
Tagged with
8 votes
1 answer
21k views

JSON Column formatting - Joining values

Is there a different way to join/concatenate values from 2 single line columns into a 3rd column other than the way below? { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-...
Murilo Santana's user avatar
4 votes
1 answer
484 views

Can we render element based on the current field value in Column Formatting?

I am working with Column Formatting in Modern SharePoint Online List where I need to render different images based on the choice selected but by default need to show the text of default choice. I have ...
Dhruvil Prajapati's user avatar
3 votes
3 answers
37k views

How to add a link to list item in a JSON view format?

Basically I need to find out the item URL to populate the href attribute of an "a" element in a JSON view format (aka rowFormatter) in SharePoint online. Is there is predefined shortcut for the item ...
elsni's user avatar
  • 471
3 votes
2 answers
2k views

Conditional formatting of a field on a sharepoint list by month of a date

As you can see in the picture, I have a date type field and I would like this field only to be displayed in orange when the month of the date is equal to the month of the current date but I don't not ...
Alexandre Picque's user avatar
3 votes
2 answers
2k views

Compare 2 dates and conditionally format

I am trying to compare 2 dates and conditionally format one of the columns based on the result. I have a 'Due' and 'Date Completed'. So I am trying to format the 'Date Completed' green if on or before ...
Helen's user avatar
  • 35
3 votes
1 answer
1k views

Data Bar Color Change

I would like to format the "Data Bar" in SharePoint to change color based on the percentage. So anything under 25% should be green, 26-50 should be yellow and 51-100 should be light red. I ...
Nanu's user avatar
  • 57
3 votes
1 answer
205 views

How to hide column if no choices are selected

From SharePoint Online, I have a multi-choice column. If the user does not pick any of the choices, how can I set a conditional formula to hide the column. I tried the following, but it does not work ...
klewis's user avatar
  • 1,353
3 votes
3 answers
11k 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 ...
JJD's user avatar
  • 493
3 votes
2 answers
2k views

Formatting two field values into a single column with markup - can't get markup to work

I have a list with two column values needed. One is a description - the other a URL. I want to format my description field, such that the URL displays beneath the description. i.e.: Description ...
JerzeyJenko's user avatar
3 votes
1 answer
1k views

SharePoint online column formatting JSON - replace @currentfield

I'm currently using SharePoint column formatting JSON to turn a field's string entry into a text, based on it's value. For instance: whenever @currentfield is equal to number 10, it should replace ...
Sarmad's user avatar
  • 31
3 votes
1 answer
1k 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-...
Mirek Novák's user avatar
2 votes
3 answers
931 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 ?
Ed1995's user avatar
  • 459
2 votes
1 answer
3k views

How can I add a link to list attachments using Json formatting

Is it possible to have a link to attachments using json formatting? I want my users to be able to click a link to go the the attachment file from a view and not have to edit or click on the form to ...
naijacoder's user avatar
  • 4,272
2 votes
2 answers
332 views

How to display past list items related to a column value?

I have the following SharePoint list in which the "Participant" columns are text values (names of people) and each item in this list is a training event. "Evenement" is the type of ...
Umar Shehzad's user avatar
2 votes
2 answers
421 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,"'...
cluckinchicken's user avatar
2 votes
1 answer
1k views

How to create a progress bar that updates on status change

I'm looking to have a 'Status' column, that a user will change, for example: Not started Investigating Review Completed When the user drops down and selects a status, another column 'Progress' will ...
Samsungs's user avatar
2 votes
1 answer
688 views

Using json to modify lots of different columns in a SharePoint list

So I have this SharePoint list, and currently I have 3 columns, each using JSON to change the color depending on the data entered. for example, say that "Yes" is entered into the column1, it ...
mmmmm's user avatar
  • 103
2 votes
1 answer
1k views

If statement JSON column formatting - SharePoint Online List

I'm very much new to using JSON and I try avoid it where I can. My problem is definitely lack of knowledge. I'm trying to change the color of column values based on their lookup fields. Originally ...
Kyle's user avatar
  • 23
2 votes
1 answer
134 views

'Create Clickable actions' JSON formatting not working

I am using SharePoint 2019. I want to create a clickable action column like referenced in https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#create-clickable-...
phil's user avatar
  • 23
2 votes
1 answer
343 views

How to retain hover functionality on Person column value when using column formatting and txtContent?

A Person column, with no column formatting, has the desired functionality. I.e. when you hover over a person's name, you can see their Person card etc. So the starting state of the column formatting ...
user1063287's user avatar
2 votes
1 answer
1k views

Conditional visibility of the button in the List

I have configured button in my list, that triggers particular flow. However I would like the button to be visible only if there is value filled in particular column (e.g. column "Name"). ...
Vardenf's user avatar
  • 23
2 votes
1 answer
3k 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 ...
Anto's user avatar
  • 21
2 votes
1 answer
21k 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/...
cluckinchicken's user avatar
2 votes
1 answer
114 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", "...
Frank Asphaug's user avatar
2 votes
2 answers
2k 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 ...
GFinlay's user avatar
  • 23
2 votes
2 answers
264 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
2 votes
2 answers
519 views

SharePoint List JSON Conditional Format of Date Column When # days passed

I've went through a bunch of questions trying to find the answer to my questions, but a lot of recommendations don't quite fit into the code that I have. I'm using the formatting that SharePoint ...
RobMS's user avatar
  • 23
2 votes
1 answer
137 views

Color coding Modified Date

I'm looking to color code the Modified column in Microsoft Lists. I know I need to use JSON but unsure of the code. I would like it to be green if less than or equal to 30 days, orange/Amber if ...
Stephen's user avatar
  • 23
2 votes
1 answer
329 views

Where can one find the FULL list of allowable values for directionalHint?

All I can find in the documentation is the standard four options. "topCenter", "bottomCenter", "leftCenter", and "rightCenter". But in one example (custom-hover-...
Scott Wiley's user avatar
2 votes
1 answer
147 views

format multiselect column as url

Is it possible to format each value in a choice column as URL with JSON formatting? I have the following values, mostly 2-3. RoadmapIds: 84027 BlogLink: https://oneurl ExternalLink: https://...
vilmarci's user avatar
  • 906
2 votes
1 answer
773 views

Creating a space in SharePoint list column - by creating a syntax for the Dynamic Content combined within Flow

I have created a Microsoft Form that has two separate questions 1. First Name and 2. Last Name. Then I created SharePoint list where it mirrored the answers on the form, after I created a Flow and ...
Ana's user avatar
  • 23
2 votes
1 answer
837 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: [...
Kris Bloemen's user avatar
2 votes
2 answers
4k 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 ...
Michael Christensen's user avatar
2 votes
1 answer
2k 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 ...
Ariser's user avatar
  • 171
2 votes
1 answer
2k 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 ...
JJD's user avatar
  • 493
2 votes
1 answer
300 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 ...
Djela's user avatar
  • 23
2 votes
2 answers
2k 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. ...
Dianne's user avatar
  • 21
2 votes
2 answers
10k 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 ...
cyw_bat's user avatar
  • 25
2 votes
1 answer
921 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; ...
DARREN SPARK's user avatar
2 votes
1 answer
325 views

JSON formatting of image

I'm having difficulties getting my list to display as intended. Can anyone help please? I have a list, and one column is a calculated field which points to a JPG file. These are A4, scanned at 300dpi. ...
Phil's user avatar
  • 21
2 votes
2 answers
841 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 ...
Francis Bruneault's user avatar
2 votes
2 answers
2k views

Combine Column Wrap Text, Color and Column Width - JSON Code

I have the wrap code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "style":{ "white-space":"wrap" }, "txtContent": "...
Aspen's user avatar
  • 21
2 votes
1 answer
4k 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. ...
Lisa DiCrisi's user avatar
2 votes
0 answers
726 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 ...
Cherubel's user avatar
  • 563
2 votes
1 answer
237 views

bring back context menu column formatter/field cutomizer

I noticed, as soon as I apply any sort of formatting to SharePoint existing columns it looses its context menu. I tried the column formatter JSON as well as field customizer. Is there a way we can ...
user4205's user avatar
  • 601
1 vote
3 answers
2k 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 ...
ShareDeveloper's user avatar
1 vote
1 answer
3k views

Lists: Circle progress bar as column view

Build in the SharePoint list classes is the option to display percent values as a progress bar. My idea is to show it as a round progress circle instead (like the image below). Can this be achieved ...
Der_Fab's user avatar
  • 177
1 vote
1 answer
1k views

Trigger flow with icon instead of button?

I have a SharePoint list with a button that has conditional logic to trigger a flow. It works (conditions display or hide it as needed as well as adjusting color and label as needed), but it doesn't ...
Darryl's user avatar
  • 136
1 vote
3 answers
363 views

Formatting Column in Content Type Hub Not Available Anymore?

I feel like I am going crazy, but 6 months ago (ish), I created a site column in my Content Type Hub. Right there while I was creating the column, I formatted it. Because at that point you could ...
Sylvie's user avatar
  • 175
1 vote
1 answer
20k 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 ...
gemini6609's user avatar

1
2 3 4 5
7