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.

1
vote
0answers
20 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
77 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
34 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
33 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
29 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
78 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
56 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
65 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
20 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
71 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
46 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
25 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
13 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
206 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
3answers
147 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
57 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
636 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
141 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 ...
2
votes
2answers
761 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
97 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
1k 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 ...