Questions tagged [json-formatting]

You can use JSON formatting to customize how fields in SharePoint lists and libraries are displayed. To do this, you construct a JSON object that describes the elements that are displayed when a field is included in a list view, and the styles to be applied to those elements.

Filter by
Sorted by
Tagged with
7
votes
1answer
3k 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-...
3
votes
1answer
575 views

Is there any way to embed just the view of a list on a modern page?

This is my list with my custom json formatting: And the embed on my modern page look like: Is there any way to embed just the cards without command bar (and header - title - footer ...) ?? ONLY ...
2
votes
3answers
361 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 ?
2
votes
1answer
5k views

In a Sharepoint List: Display an Image (field type “Hyperlink or Picture”)

I have a Sharepoint list that has a column filled with URLs (which point to images stored elsewhere on the Sharepoint site). The column settings and JSON are shown in the below image: When I fill in ...
2
votes
2answers
45 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 ...
2
votes
1answer
27 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 ...
2
votes
1answer
48 views

Using json listview formatting to create responsive tile view

I'm trying to use this MS documentation to create a tile view for my list items. About halfway down it shows how to use tileProps to enable the Tile view for the drop down and create tiles. It works ...
2
votes
1answer
369 views

Yes/No field in JSON view formatting

This is about JSON formatted views (not columns) in modern SharePoint online. List A has a Yes/No field. The values show as Yes or No in the view. When I format the view and show the field value ...
2
votes
2answers
70 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
351 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 ...
2
votes
1answer
161 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; ...
2
votes
1answer
28 views

Formatted column button doesn't start the flow

I am having an issue, that none of the members of my organization can call a flow from a formatted column button in a Sharepoint list. Below is the script used to create this button: https://docs....
2
votes
1answer
1k views

column formatting with json for lookup fields

I have problems formatting the column of a lookup field with json. Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
2
votes
1answer
44 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
1answer
56 views

Is it possible to highlight the first 5 rows in a SharePoint view?

I have a view that sorts items based on a date field, from earliest to latest. The order will change over time, as users make edits to the item dates. I would like to apply formatting that will ...
2
votes
0answers
75 views

What does the colon operator do in SharePoint column formatting JSON?

If you use the Fill background color template for formatting a date column on a modern SharePoint list/library, and you switch to Advanced mode to view the JSON, it makes extensive use of a colon (:) ...
2
votes
0answers
457 views

I want to create a separate hyperlink for each work in a SharePoint column

I have a "Single line of text" column, which is used to write ticket numbers from another system, such as 123456. Sometimes more than one number applies to an item. I have the column formatted with ...
1
vote
3answers
5k views

How to color code a SharePoint list date field based on comparison with todays date?

I have a SharePoint list with a date column called 'Expiration Date' containing a date value. Using some JS code, I would like to first check if the date value equals to today and if so I would like ...
1
vote
2answers
47 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 ...
1
vote
2answers
197 views

Conditional formatting based on date to expire

In SharePoint O365, in the modern experience, I have a list of training certificates that have an expiration date of one year from date taken. I would like to use conditional formatting to create a ...
1
vote
2answers
406 views

SharePoint Online Version Column Formatting via JSON

I am trying to archive the following within a document library modern experience on SharePoint Online: All minor version (everything .1-9) the background should have the color red or similar All ...
1
vote
4answers
2k views

Using ampersand's (&) in JSON column formatting

I am trying to use JSON to format a "Person" column in a Sharepoint list with an email action button. I would like the email to contain a link to the Sharepoint list item in question, but the link ...
1
vote
1answer
79 views

SharePoint List Formatting

I need to do a databar format on a choice column with text inside. Is this possible? I can get it easily enough with the given JSON formatting code but i cannot seem edit the code below enough to ...
1
vote
2answers
127 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 ...
1
vote
1answer
283 views

Still Unresolved - Display only Thumbnail of Picture (via hyperlink) in List

I have a Sharepoint List that contains a large number of items. Each item has various metadata fields (text, numbers, users). They also contain 15 fields for images (each field contains a hyperlink in ...
1
vote
2answers
307 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] == '', '', '•')", ...
1
vote
1answer
92 views

SharePoint online column formatting not reading my children array in JSON object

I can get the formatting to render the background and font style for the column text but not the icons in the children element. I have messed with this for days. I must use style elements as opposed ...
1
vote
2answers
246 views

Remove all commas from single line of text field

Trying to remove all commas from a single line of text SharePoint Online field entries. Any ideas on how to achieve that, any formatting formulas, or JSON? Thank you in advance!
1
vote
1answer
1k views

Column formatting - AND OR conditions

I'm trying to work out the code required for multiple-condition formatting of a column based on two others. I can write multiple 'if' conditions in Excel style, but cannot get && statements ...
1
vote
3answers
2k 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 ...
1
vote
1answer
1k views

Custom column formatting with JSON: style ignored?

According to The official detailed syntax reference, I can use (CSS-like) style attributes like "display" and "width". I tried something like this: { "$schema": "https://developer.microsoft....
1
vote
1answer
23 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", "...
1
vote
2answers
26 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
21 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 ...
1
vote
0answers
48 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 ...
1
vote
0answers
99 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 ...
1
vote
0answers
194 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 ...
1
vote
1answer
40 views

Hide/remove shring option on a library

We have a special library where only a select few have access to. Then we learned that those select few can just share a file with anyone. Not good. I tried creating a custom permission level, but ...
1
vote
1answer
72 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 ...
1
vote
2answers
80 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
1
vote
1answer
371 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
408 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 ...
1
vote
1answer
511 views

In a Sharepoint list, display the Thumbnail of a picture only to enable fast loading speeds

(I am using Sharepoint Online rather than On-Premises) I own a Sharepoint List that contains a large number of items. Each item has various metadata fields (text, numbers, users). They also contain ...
1
vote
0answers
89 views

Column formatting for multi-choice field in SP Modern

Context: I'm working as a regular user consuming my company's modern Sharepoint deployment, so my capabilities are pretty limited other than what's available from the GUI. I'm trying to format a ...
1
vote
0answers
171 views

JSON formatting not saved

I add JSON to format my column and when I click "Preview" it looks fine. Then I hit "Save" and close the format window but then the newly formatted column reverts back to the default and the JSON ...
1
vote
0answers
92 views

How to retrieve a column field to use in actionParams when using a format action in JSON - MS FLOW

I'm working on have to trigger ms flow from a link in sharepoint via the modern UI list. I can trigger the link and it fires the flow but instead of hardcoding the flow GUID i want to store them in a ...
0
votes
2answers
82 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 ...
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 ...
0
votes
1answer
18 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?
0
votes
1answer
30 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, "...