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.

241 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
607 views

JSON formatting of image

I'm having difficulties getting my list to display as intended. Can anyone help please? I have a list, and one column is a calculated field which points to a JPG file. These are A4, scanned at 300dpi. ...
Phil's user avatar
  • 21
2 votes
1 answer
1k views

Add Text to Body of SharePoint List Using JSON

Is there a way to add text for instructions in the body of a list without PowerApps? I would like to change up this JSON code to make it possible. I'm aware that there is a "Description" ...
Nanu's user avatar
  • 57
2 votes
2 answers
3k views

SharePoint format groupby over full width (group props headerformatter json)

I have a SharePoint Online list with a groupby in the status field. Now I want to change the whole background of the groupby so that the status row has a different color. I have already applied JSON ...
Kris's user avatar
  • 21
2 votes
2 answers
1k views

Sharepoint column formatting carried over in all views

I have SharePoint list with multiple views (in modern experience) and when I format a column in one view, the same formatting is applied to the column on all other views. How do I break this and have ...
Francis Bruneault's user avatar
2 votes
0 answers
1k views

Document library - custom formatting - hover card

I have created a document library in Sharepoint Online. That library serves as a photo gallery. The photos have some custom attributes linked to our global term store. I created a thumbnail column ...
dfx413's user avatar
  • 31
2 votes
0 answers
3k views

SharePoint Json Formatter, Not able to change the color of border of the tiles for a List

I am currently working on JSON formatting of a SharePoint list Tile view and I have a requirement of the custom colour of the border of the tiles. Using this code, but it is not valid as per the list ...
G.Srinivas's user avatar
2 votes
2 answers
2k views

Combine Column Wrap Text, Color and Column Width - JSON Code

I have the wrap code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "style":{ "white-space":"wrap" }, "txtContent": "...
Aspen's user avatar
  • 21
2 votes
1 answer
4k 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. ...
Lisa DiCrisi's user avatar
2 votes
0 answers
755 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 ...
Cherubel's user avatar
  • 563
2 votes
1 answer
272 views

bring back context menu column formatter/field cutomizer

I noticed, as soon as I apply any sort of formatting to SharePoint existing columns it looses its context menu. I tried the column formatter JSON as well as field customizer. Is there a way we can ...
user4205's user avatar
  • 601
2 votes
1 answer
2k 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 (:) ...
Jason Lee's user avatar
  • 351
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
2 votes
3 answers
4k views

JSON - how to highlight duplicated items in a specific column?

I have a microsoft lists where the ID for each episode is a number. I want to format th ID Column so that each time a new item is added, if the ID column is duplicated from an existing ID it appears ...
Diana Portela's user avatar
1 vote
1 answer
39 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
0 answers
18 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
1 vote
1 answer
15 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
1 vote
2 answers
71 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
76 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
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
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
1 vote
1 answer
89 views

Changing color in calendar view to show different locations

I would like to visually show when the locations are different. So I have 2 rooms that we use Room 1 and Room 2 (location is a free text value but we would use the same text). I would like these in a ...
Iuliana Iurea's user avatar
1 vote
1 answer
420 views

How to get lookup column value in single line of text

I Want to display lookup column values in single line of text. ProductName lookup column with multiple selection. I tried using JSON column formatting but values are not showing. Please can anyone ...
Lucky's user avatar
  • 13
1 vote
1 answer
203 views

SharePoint Online - FAQ List Colors

I am building a fairly simple FAQ for my team's website. I've got the list setup and the JSON formatting in place but I am trying to get the main column headers to display in a different color than ...
Dominick's user avatar
1 vote
1 answer
308 views

SIMPLE Column formatting in SharePoint list (SP2019)

I have a pretty basic SharePoint list on a page at work and I simply want columns to be colored yellow (Is it "#ffff00" ?). In my "List Settings" I select the column I would like ...
James's user avatar
  • 11
1 vote
1 answer
56 views

Change the text color only on specific numbers in column

A little help please! I created a SharePoint list with company contacts and I want in column 'length of service' the numbers 5, 10, 15, 20 etc. years to be marked a different color, for example red.
Keit Eigla's user avatar
1 vote
1 answer
52 views

Add 3 conditions to an actionParam from JSON

I have managed, somehow to add 2 conditions for an "actionParam" in JSON. Now I would like to add an extra condition. Please can anyone help me? Thank you! { "$schema": "...
Claudia's user avatar
  • 11
1 vote
2 answers
511 views

Conditional View Formatting doesn't show right away on Calendar View of my list

I have created a list on SharePoint in order to view it as a calendar. Since color coding isn't possible, I followed a web tutorial on using JSON to be able to color code different types of events. I ...
Ombeline's user avatar
1 vote
1 answer
148 views

SharePoint JSON email attachment

Is there anyway to add an attachment to Outlook using mailto: in JSON? For example, I have a list that has an attachment. I have a email template that opens in one of the columns using JSON. I am ...
SN778's user avatar
  • 11
1 vote
1 answer
187 views

SharePoint JSON hyperlink text in email

I have a list that has a combination of numbers. In one of the columns for that list I am writing JSON code that pops up outlook with a set template. In the body of that template, I have the following:...
NS22's user avatar
  • 11
1 vote
1 answer
982 views

Multiple conditions in conditional formula in Lists

I'm a complete newbie to this. I'm trying to have a column show up based on two other selections in the form. So this is what I have based on one choice (after a LOT of googling): =if([$Travel_x003f_] ...
user109213's user avatar
1 vote
1 answer
46 views

SharePoint formatting date column

I am having an issue when trying to format my date column on a list. I want the background color to turn red if the date is less than or equal to Today – 10 days, else its green. I cant see how to ...
João Santos's user avatar
1 vote
1 answer
603 views

SharePoint calculated column replace all spaces

This is my requirement: Here, I have taken a single line of text column with 2 spaces in the column field. I have used that column as a reference in a calculated column. By using a formula I can able ...
Chandrika Kambala's user avatar
1 vote
1 answer
112 views

Editing column format when JSON is not valid

New to SharePoint so I hope I'm not doing anything silly, but I tried to edit a column format using JSON. It was working, and then I added an addition IF statement. I messed it up and now it only ...
user108981's user avatar
1 vote
1 answer
144 views

How do I hide list options when a question selection is yes?

I have a SP online list that contain required fields. One option asks if an event was cancelled-it is a yes/no option. I want to be able to disable the remaining options in the form if the selection ...
Flp's user avatar
  • 11
1 vote
1 answer
19 views

Creating conditional tasks based on certain tags

I'm wondering if it is possible to create a conditional task based on the selection of a previous tag. For instance, if the Tag "team meeting" is chosen, on a task, I would want another ...
Philipp Brandes's user avatar
1 vote
1 answer
207 views

Item view add hover card

I've built a ticket tracker in SharePoint, but I'd like to add a hover card (ideally over a circle with an i in it) to the status field listed. So it would say something like: 1 means I got it 2 means ...
macinjosh1's user avatar
1 vote
3 answers
336 views

SharePoint Column JSON If then nested Statement

The code below looks at my Client Number Field and if its greater then 5000, it concatenates and creates a hyperlink to a Jira item. This is working correctly. I need to add a "Then" ...
Melissa C's user avatar
1 vote
1 answer
818 views

Is it possible to create buttons for hyperlink fields in a SharePoint modern customized list view?

I have created a list that contains document names, 4 choice fields to select and define what the document is, and 2 hyperlink fields to take the user to the document in either English or French. So ...
Tammy Lang's user avatar
1 vote
1 answer
1k views

Can I use JSON to format column height and width in a list with hyperlinks?

I am using JSON to format the height and width of my columns in a SharePoint list. Some of these columns are set to be hyperlinks or advanced rich text. When I apply the JSON formatting, it takes the ...
Kaitlyn's user avatar
  • 11
1 vote
1 answer
826 views

Trying to format based on a due date that is between today and 5 days from now

I'm trying to set up conditional formatting on a List for Due Dates (SharePoint online). I can't seem to get the correct code for Due Date is between today and 5 days from now. If I use an arbitrary ...
Ambrosia's user avatar
1 vote
1 answer
397 views

Creating a calculated field to show 'Red' 'Amber' or 'Green' based on a due date column

I am trying to create a calculated column to return "Red" "Amber" or "Green" based on a due date. I have a date column called "Due Date" and I am trying to add ...
aoife's user avatar
  • 11
1 vote
1 answer
342 views

How can I format a column using JSON to prepend the office URI scheme to the document link?

I have a custom column formatted with JSON for SharePoint. I need all of my customization to stay, however, I do need to add the following formatting to the column: Using boolean logic, format the ...
ExcelHelpNecessary's user avatar
1 vote
1 answer
249 views

Link from SharePoint Library to list item

We create a SharePoint list record and a flow that populates the list and also creates a folder in a SharePoint library, this folder has subfolders. The list has a title called (enq_no), this title is ...
Sandra P's user avatar
1 vote
1 answer
436 views

How to make a button visible only to user in a multiple selection people field

I'm doing a SharePoint List automation and i need to make a button that only people from a specific field to be able to see it. I have a column Actions for my button. And a column "Pessoas de ...
Matheus Ha's user avatar
1 vote
1 answer
885 views

How to get value of Calculated field in Header using JSON?

I have a calculated field based on other multiple columns. How can I print the value of it in Header?
Thangho's user avatar
  • 11
1 vote
1 answer
528 views

Need help adding Hover-function to Gallery Card in SharePoint Online

I need help with adding a Hover-function that lets you display all of the text inside $Description when hovering the mouse over the gallery card in SharePoint Online. Would anyone have knowledge of ...
Hovermeplease's user avatar
1 vote
1 answer
81 views

Can i know why the title and modified by not showing also the box shadow was also not working... sorry im new with this

Can I know why the title and modified by not showing? also the box shadow is not working? { "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json&...
mindspace3387's user avatar
1 vote
1 answer
428 views

Add Picture file and href link to SP List in Header

How can I merge the two sets of code below so they show together in the Header? Picture File for Header: { "elmType": "img", "style": { "width": "...
DL-HIA's user avatar
  • 11
1 vote
1 answer
568 views

Using JSON to create an email, and uses other list fields in the body of the email

Currently starting with: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "children": [ ...
Troy Overholt's user avatar

1
2 3 4 5