Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
2 answers
30 views

SharePoint online library column JSON formatting based on other column value

I need to format a column named 'Action' with hyperlink as follows: If column name 'Status' is having value as "Accepted" or "Rejected" then 'Action' column should have hyperlink ...
Sanjay Adsure's user avatar
0 votes
1 answer
14 views

JSON formatting of list header part - two rows of text

I have the below json code added to the header section of a item list editing window. The code adds two links, one next to each other. I'd like the second link to appear either in a new row (i.e. ...
Paksos's user avatar
  • 15
0 votes
1 answer
21 views

Column formatting by elapsed time

I need to format a column in SharePoint Online with this features: If the value in the "Ordine" column is "ASSENTE" and it has been more than 5 minutes since the record was created,...
Andrea Gail's user avatar
1 vote
1 answer
15 views

Checkbox - align center

On Yes/No Checkbox - JSON sample, there is a code allowing you to show checkbox (square) for a YES/NO column regardless of the current value of the field (by default checkbox only shows if YES is ...
Paksos's user avatar
  • 15
0 votes
0 answers
13 views

Duplicated Headings in SharePoint List Forms

Recently, while immersed in the task of formatting the form body within the Site Pages library, my objective was to introduce structured headings to categorize the various fields. Leveraging JSON, the ...
Anita Boerboom's user avatar
0 votes
2 answers
21 views

SharePoint - show Yes/No column from a lookup table

I have a list A which has columns ItemCode (text type) and Enabled (Yes/No type). In list B I created a lookup column to list A. I am able to show in list B ItemCode from list A however I don't seem ...
Paksos's user avatar
  • 15
0 votes
2 answers
26 views

How to add condition to the SPO column with JSON

Can a condition be added to the multiple-line text column so that if it includes a semicolon, it sends a notification, changes the color, or something similar?
Harris's user avatar
  • 595
0 votes
0 answers
26 views

JSON Code based on date and priority

I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends. In my priority column I have the following options: ...
Jackie's user avatar
  • 1
0 votes
1 answer
29 views

Show/Hide Column Display name using a Condition using JSON Not PowerApps

I want to remove the title "Please upload the personal image if needed", if the Visa Support is "Yes", and show it if the Visa Support is "No". I want to make it using ...
AfifK's user avatar
  • 1
0 votes
1 answer
32 views

SharePoint column show/hide condition - Multiple conditions with OR

I have a Choice column that I want to display if either of two conditions are true. It's an Approver Response column that I want to hide if "Approver Notified" checkbox = false, and Status = ...
Chris's user avatar
  • 409
0 votes
1 answer
24 views

SharePoint default form json - How to set a section name to = the display name of a user from a people-picker

I am building a SharePoint default form for creating a new doc set in a SharePoint online Library. This form has 3 Approver fields (people pickers). When they go into the submitted form to provide ...
Chris's user avatar
  • 409
0 votes
0 answers
21 views

JSON Code is having no Effect on Column Formatting in a SharePoint Online List

In SharePoint Online, I have permissions as "Owner" (not ADMIN). I have created a list. The column types vary (of type URL, Text, Date, etc.). For the URL column, I added the following JSON ...
Angelina Gomes's user avatar
0 votes
1 answer
61 views

Hide "Favorite/Unfavorite" button in ribbon via list view format CommandBarProps

Need to hide majority of button in library ribbon - using "Format View" option and JSON editor work for every button.. except "Favorite" and "Unfavorite". Syntax ...
Kristaps Vilerts's user avatar
1 vote
1 answer
29 views

Conditionally Hide Show Fields On A SharePoint List Form

I am creating a SharePoint list in which I have list 'Invoice/Receipts'. I am doing conditional formula so that when the 'Cost Category' column value 'Travel' or 'Allowances' is selected, 'Invoice/...
Anonymous's user avatar
1 vote
2 answers
27 views

Show a column if another column has a specific value in microsoft lists

On my list, when adding a new item, I need the visibility of one column field to be toggled based on value from another column/field (which is a multiselect type of column). For example column A value ...
Bialy778's user avatar
1 vote
1 answer
11 views

Microsoft Lists how change color if date is more than 6 months in the past

I'm trying to color a column item based on date value. I'd like to highlight date if it was > 6months in the past. Below is what I tried but doesn't work as text becomes completely hidden ...
Bialy778's user avatar
0 votes
0 answers
17 views

JSON progress bar always full in SharePoint

Is there any way to show a progress bar under a text formatted as Accountability in SharePoint online? The progress bar must put in relation 2 values: let's call the first Amount Financed and the ...
Christian's user avatar
1 vote
1 answer
18 views

If two columns show no date, "Status" column shows "Incomplete"

I am very new to JSON. I have a document library, and I am trying to have a "Status" column populated with "Acknowledged" if two columns show a date, or "Unacknowledged" ...
Whitney's user avatar
  • 13
0 votes
2 answers
36 views

How to change the background color of a list to red with JSON?

How to change the background color of a list to red with JSON? This is what I have: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", ...
user1903995's user avatar
0 votes
0 answers
10 views

Use JSON row-formatting for my list to give additional rows a different color. But the color is not correct

I use this JSON code below to give additional rows a different color. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "...
user1903995's user avatar
1 vote
0 answers
15 views

SharePoint list form - Column conditional formatting in Swedish

I'm using SP in Swedish at work and want to add conditional formatting for show/hide columns on a list form. I want pretty much exactly this but translated into Swedish syntax: =if([$Category] == '...
WestanSmoothSailing's user avatar
0 votes
1 answer
25 views

Replace semicolon with comma in SharePoint text colomn

I am having an issue replacing the semicolon with a comma. I am using the JSON replaceall function to do this, and it looks like it does the job. However, you can still see the semicolon when you ...
Harris's user avatar
  • 595
0 votes
0 answers
19 views

SPFX customFormatter

Is it possible to take the JSON of a customFormatter from a field info object and apply it when rendering a component? I would like to render choice fields as they are displayed in a list view. For ...
JJD's user avatar
  • 493
1 vote
1 answer
14 views

How do I make a list date column turn mint green if the date entered is within the last 12 months and turn light red if it outside of 12 months?

I have a list made that tracks several employee training dates. We are currently entering the date they last tested/trained. Trainings are due every 12 months or every 36 months. How can I make the ...
George K.'s user avatar
0 votes
1 answer
54 views

JSON formatting - remove hyperlink in one view only

I have two views in a SharePoint Online document library. I want to strike-out and disable the hyperlink of column 'Name' if 'Retracted' column is true. I've carried this out using 'Format columns' ...
Orange Juice Jones's user avatar
0 votes
0 answers
28 views

Clicking the SharePoint List Web Part title link opens two tabs

If you set a defaultClick action in JSON for a column in a list, two tabs of details will open in the List web part. Only Chrome and Edge on iPad and iPhone. Safari is fine. There is no problem with ...
Tetsuya Shirahama's user avatar
0 votes
0 answers
14 views

Build custom group headers and footers not working

The json formatting code provided by Microsoft at this page: List layout customizations under "Build custom group headers and footers" doesn't seem to work. If I remove the nested if(s) I ...
Jordan's user avatar
  • 1
0 votes
0 answers
21 views

I need to show the results of a calculated field on the NEW ITEM Sharepoint list form...thoughts?

So, I have a calculated field that is calculated based on how other columns are populate on the NEW ITEM SharePoint list form. I am new but I understand that calculated field will not show on the form....
Jason L. Shaw's user avatar
1 vote
1 answer
33 views

JSON to wrap text after ";" from a lookup AND delete blank spaces

I have a column "Action Status" which is looking up multiple values in a separate Actions table. The first screen shot shows how the data appears without applying any JSON coding (I'm a ...
user111397's user avatar
0 votes
2 answers
121 views

Is it possible to use an if statement on choice type column in MS List conditional formatting?

Apologies this is my first question so I will summarize the issue as best as possible. On the list I have created below in the progress column I created a drop down option using choice type. I have 3 ...
Stevan's user avatar
  • 3
0 votes
1 answer
18 views

multiple conditional formatting

New to the whole JSON code within SharePoint lists, hit a brick wall and having no luck with research. I require 2 conditional formatting writing into the cod but am not having much look. First - if ...
JB94's user avatar
  • 1
0 votes
1 answer
38 views

Facing issue with the SharePoint document library view formatting using JSON

I am trying to use below JSON formatting to create a title view of the document library in my modern SharePoint document library. { "$schema": "https://developer.microsoft.com/json-...
Kailash Sahoo's user avatar
0 votes
1 answer
39 views

Is there a way to backup/archive JSON formatting

This question is from a site-developer perspective not from a sysadmin perspective. Site Developers don't have access to the SP server itself, they are users with "full control" permissions ...
Carlos N's user avatar
  • 127
0 votes
0 answers
42 views

SharePoint Online Default Form - Display Choice column as multi-select checkboxes

I have a SharePoint Online list with a Default SP Form I'm customizing with json (not using PowerApps). Is there a way I can display a multi-select Choice column as checkboxes, rather than a dropdown ...
Chris's user avatar
  • 409
0 votes
1 answer
19 views

Can we use configure layout to customize form with document libraries?

I'm able to use configure layout to customize a form for a list. But no idea how to use the same for a document library? Is it possible? Since there is no new form link for document libraries is there ...
naijacoder's user avatar
  • 4,282
1 vote
1 answer
90 views

SharePoint List Formatting - Choice Field Overflow

I have a choice field in my SharePoint list. The choice field is basically a tag list. Now I wish to display the tags on a single line. Everything what doesn't fit in the box should just be hidden. ...
WG-'s user avatar
  • 177
1 vote
2 answers
58 views

SharePoint list Form footer formatting - Multiple text lines

Does anybody knows how can I add two lines in a footer in SharePoint form? I found tutorials teaching how to add two links to the footer, but I need to be able to place two notices, one under the ...
ygbarelli's user avatar
1 vote
1 answer
137 views

SharePoint 2019 JSON AST column formatting

I would like to realize the following: If the date in a column is more than 40 days old, the background should turn orange. If the date is more than 80 days in the past, the background should turn red....
Bollo's user avatar
  • 13
0 votes
1 answer
119 views

Align tiles horizontally in sharepoint list in a view formatting

the tiles of this json display vertically, one under the other, i can't figure how to display them horizontally, one on the right of the other. Is it related to "flex-direction" ? Thxs` { &...
Hervé 's user avatar
1 vote
1 answer
116 views

JSON formatting for downloading documents but only viewing folders

I'm working on a SharePoint Library that has both documents and folders. I've added JSON formatting to show a "Download" button for all items. I need to change that to only download for ...
M Kanetomi's user avatar
1 vote
1 answer
77 views

Icon Progress Bar JSON formatting not displaying in my view

I've tried inserting this nice JSON Icon Progress Bar in my list view (thanks to this so useful page) but it does not display. As I am in a view formatting, I have changed the fields @currentField by $...
Hervé 's user avatar
0 votes
1 answer
96 views

Problem on JSON formating with a connected field of a lookup Column

In my List A I have a lookup column "CODE PROJET" and one connected lookup column "FIN RECONDCT" both coming from an other SharePoint list B. On a field of the A List I try to do ...
Patgat's user avatar
  • 1
1 vote
1 answer
18 views

SharePoint List lookup value not adding additional fields values

I have a main list 'Actions Types', where to each type of 'Action Type ID' is assigned a Person (using Person of Group field). Using a JSON code, I created a single text column (named 'Owner Email ...
Giuseppe Di Lernia's user avatar
1 vote
1 answer
66 views

Display image with choice column when multiple selections allowed

I have a list where we track an employees performance by awarding badges. I have a (multiple selection allowed) dropdown choice column containing the 4 Achievements. With each selection, I have badge ...
user110812's user avatar
0 votes
1 answer
45 views

MIcrosoft List Conditional Formatting - JSON

I'll start by saying that I do not know JSON! I have a Microsoft List that tracks contracts. I am trying to shade the cells in this column based on date criteria and how far away from the current ...
Cliff's user avatar
  • 1
1 vote
1 answer
47 views

JSON to display image based on 100% completion

I have a list where we track an employees performance by awarding badges. When 4 badges are earned, the employee achieves a Pennant. I have a calculated column for Progress that adjusts by 25% with ...
user110812's user avatar
0 votes
1 answer
204 views

SharePoint Online Library - Modify Choice column value without Edit in Grid View

I have a SharePoint Online Document Library where I need the users to be able to select a Choice field value (Approved, Rejected, etc.) without having to Edit in Grid View. I know it's possible with ...
Chris's user avatar
  • 409
0 votes
1 answer
111 views

Padding needed to top of SharePoint Online field

I' m currently using a SharePoint online modern list. I have managed to create a lookup column and also a value lookup column Problem is regarding the JSON formatting. How can I insert a padding value ...
Sparky's user avatar
  • 13
1 vote
1 answer
33 views

Formula outcome doesn't appear in the file details

I was in need of column showing me extension of the files, I've made one with this code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json&...
rocendroll's user avatar
0 votes
1 answer
106 views

SharePoint Online: display extra information on the Right Display pane of the list calendar view

I have a SharePoint Online list with a calendar view and when you click the day cell, all information is shown on the right as shown on the image. Currently it is displaying the Title (see right pane),...
Burre Ifort's user avatar
  • 1,339

1
2 3 4 5
15