Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
13 views

Sharepoint list, conditioanlly displaying icon

hope you are doing well. I am currently trying to custom format a list using JSON. I am having trouble conditionally displaying the "Attach" or paperclip icon depending on whether the field attachment ...
0
votes
1answer
17 views

JSON column formatting with if/else in SharePoint?

I would like to nest if conditions into SharePoint via JSON column format. I have two fields, Date and Status. The status field contains 3 strings ("Done", "Pending", "New") Example: if ([$Date] &...
1
vote
1answer
17 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
28 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
41 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!
0
votes
1answer
25 views

How to format a SP Online List Name ( Header ) using JSON via Format View?

I have used JSON to format most of the columns on a list and then some using "Format Current View" and "Format This Column" however I've scoured the web looking for a solution to formatting the List ...
0
votes
1answer
25 views

How to change font size for all rows in a list using JSON on SP Online via Format View

I know that I can format each column view by "Format This Column" but is there a way to format the whole list in the same manner? In particular, increasing the font size or any of the font attributes ...
2
votes
0answers
29 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 (:) ...
0
votes
1answer
26 views

Conditional Formatting based on choice selection from another column

I'm new to SharePoint List Conditional Formatting I've got two columns one is [$Status], and the other is Due Date. If the status is resolved it will be green, if the status is open and the due ...
0
votes
0answers
27 views

List items not aligned with custom formatting

I am experimenting with json view formatting. I am working with this template, that should show the list items next to each other like on the screenshot: Instead, they are presented like this in my ...
0
votes
1answer
54 views

list view web part with custom view formatting

I customized a list view that, contains the followings: { "elmType": "div", "attributes": { "class": "ms-bgColor-themeLighterAlt ms-bgColor-themePrimary--hover ms-fontColor-white--...
0
votes
1answer
24 views

Image column not behaving in SharePoint Online List with Custom Format

I am trying to allow users to include a thumbnail in a list. Since most users will not have general upload permissions anywhere on the site, this will be done through two fields: Attachments, and a ...
0
votes
0answers
20 views

JSON Formating of Date column modern pages

I am trying to get a JSON script that will colour/highlight the entries in a date column that are within the next 2 months(or already passed). What I have at the moment is : { "$schema": "https://...
1
vote
1answer
84 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 ...
0
votes
1answer
112 views

Column Formatting using JSON: Get value of the column “_ModerationStatus”

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval. I have the following JSON: { "$schema": "https://developer.microsoft.com/...
1
vote
1answer
68 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 ...
0
votes
1answer
198 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
69 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
170 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....
0
votes
0answers
82 views

List View Row Formatting Using Ratings Column

I have a SharePoint Online list that contains the standard like style ratings feature. I am trying to format a row view for this list, I can get everything to work except for the ratings column (I ...
1
vote
0answers
167 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
27 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
1answer
119 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
0answers
51 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 ...
2
votes
0answers
84 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 ...
0
votes
0answers
15 views

Sharepoint List - How to use various field types in JSON (column formatting) [duplicate]

Some data from other fields can't seem be referenced when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
0
votes
0answers
413 views

Use Sharepoint list fields in JSON column formatting

Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
1
vote
4answers
274 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
0answers
66 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 ...
2
votes
1answer
1k 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 ...
0
votes
1answer
235 views

Problem formatting list view with Json

I am trying to format a list with Json. I want elements in the list to turn red if the value in one column is "No". I found an example on the internet, added my own values and deleted som conditions ...
5
votes
3answers
1k 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
198 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 ...
1
vote
3answers
2k 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 ...