Skip to main content

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
0 votes
1 answer
3k views

SP Lists - JSON Conditional formatting based on other columns

I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns. Here is what I was trying to set up: IF @ColumnName1 = "status 4" THEN @...
Szymon's user avatar
  • 1
1 vote
1 answer
669 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/...
Perka's user avatar
  • 153
1 vote
2 answers
1k 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 ...
Patrick's user avatar
  • 3,193
0 votes
1 answer
10k 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 ...
wahle509's user avatar
  • 371
3 votes
3 answers
39k 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
2 votes
2 answers
4k 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....
Nick Sabbe's user avatar
0 votes
1 answer
891 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 ...
Trey Kent's user avatar
1 vote
1 answer
2k 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 ...
Alasdair Duncan's user avatar
1 vote
0 answers
247 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 ...
TWNA's user avatar
  • 11
1 vote
1 answer
829 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 ...
Alasdair Duncan's user avatar
2 votes
0 answers
442 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 ...
user81145's user avatar
2 votes
0 answers
773 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 ...
Andrew's user avatar
  • 21
0 votes
1 answer
5k 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....
Alasdair Duncan's user avatar
3 votes
5 answers
16k 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 ...
Alasdair Duncan's user avatar
1 vote
0 answers
300 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 ...
naijacoder's user avatar
  • 4,282
2 votes
1 answer
25k 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 ...
Alasdair Duncan's user avatar
0 votes
1 answer
620 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 ...
Maria Rey - SharePoint 's user avatar
9 votes
1 answer
23k 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
3 votes
1 answer
2k 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 ...
Hernán Ramírez's user avatar
1 vote
4 answers
16k 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 ...
mdevm's user avatar
  • 1,255
0 votes
2 answers
2k views

Making a yes/no column show an icon rather than text

I'd like to have a Yes/No column that rather than showing the usual text ("Yes"/"No"), shows an icon - say green or red. I know I can create another column (a calculated one) with a formula that ...
st1led's user avatar
  • 101

1
11 12 13 14
15