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
1answer
24 views

How to export or backup column formatting JSON values?

Is there a way to export or backup the column formatting JSON that has been applied to SharePoint list columns? Obviously, column formatting is so useful that it is often applied to lots of lists, and ...
0
votes
3answers
15 views

Add column to list with mailto function that takes users from 2 columns

So I have 2 columns "Owner" and "Deputy Owner", both are User columns and both filled. Is there some way I can make a new column, where I add a mailto icon and after clicking on it,...
1
vote
1answer
17 views

Using SPO and trying to create a conditional column based on a blank value in another [closed]

First of all, I have no experience with JSON so there is that learning curve but I am trying to create a conditional format in one column based off a blank value in another. The other column also ...
0
votes
0answers
23 views

Customize Gallery View formatting of a Document Library

I'm looking for any assistance on how to change the formatting of the gallery view of a document library (not the tile view of a list, which is what all the search results end up being for). The ...
2
votes
1answer
75 views

How to add an image to a column based on the value of another column (and have it show correctly in Gallery view)?

Desired Behavior: Display an image in the column My Image based on the value in the column Model. My Image is type Picture (I also tried making it type Image but got the same outcome). Model is type ...
0
votes
0answers
13 views

SharePoint Task Timeline Color based on task group

I understand changing colors manually but what would the JSON be for such a formatting requirement and where would I also place it? HELP!
1
vote
1answer
26 views

How do I format Tile View JSON so that it doesn't break apart a word in the middle of the word for multi line column

I have created a tile view that has a few columns from a SharePoint list. I have everything formatted perfectly, except it randomly breaks apart lines in the middle of a word. Say teacher it would be. ...
0
votes
1answer
22 views

Customize Title column with JSON

Currently my Title column has a link in it, but I need to make it bigger and change the font while keeping the href function (after clicking on the title it opens editing). When I use "elmType&...
0
votes
1answer
20 views

How to add custom links based on a field to action bar?

Assume we have the action bar in SharePoint for document libraries. Assuming I want to create a simple link like https://foobar.com/some-great-action?id=$ListItemID, how I can do that the easiest way? ...
1
vote
2answers
23 views

How to correctly pass argument to final 'if' conditional when column formatting using JSON?

Based on the example here, I am using the following JSON to add icons next to column values, depending on their value: { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
1
vote
1answer
25 views

How to separate 'Person or Group' column values by a comma and display on one line?

When you select multiple Persons from a Person or Group column in a SharePoint List, each value will be displayed on its own line, eg: Person_01 Person_02 However, a Choice column that allows ...
1
vote
1answer
33 views

Change choice column after reaching certain date via JSON in SharePoint list

I have a maintenance scheduler list with two inputs: MaintenanceStart (dateTime column) and Status (Choice column) The predefined value in status column is 'Scheduled maintenance' and I would like to ...
1
vote
1answer
24 views

Convert People Picker to New Text Column

I have a SharePoint online list where I have a People Picker field ("PeoplePickerColumn"). I want to create a new text column ("PeopleTextColumn") in the list that populates based ...
1
vote
1answer
29 views

Customise person column with JSON

Now the settings are made to be small: Is there some way to make the person card bigger on height and font size? I use Person or Group column.
1
vote
1answer
26 views

Bigger font size in hyperlink column in a list via JSON

I would like to make an alternative text in a hyperlink column bigger. In a title column, it works fine with this code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
1
vote
1answer
48 views

Trigger flow with icon instead of button?

I have a SharePoint list with a button that has conditional logic to trigger a flow. It works (conditions display or hide it as needed as well as adjusting color and label as needed), but it doesn't ...
0
votes
1answer
24 views

How to color new list record like outlook do? [closed]

Is there any possibility to color new record on SharePoint list like outlook new emails?
0
votes
1answer
65 views

Format List View: JSON background colours 'ms-bgColor2' property - very few colours available

I'm attempting to change the colour of the bg-Color property. By standard on my list the colour is set to white. I'd like to change it to a different colour, but there are very few available to me. ...
0
votes
1answer
41 views

Applying JSON column formatting hides column list values

I'm just getting into column formatting. I'm trying to create the "Create clickable actions" example that was on Microsoft's site explaining Column Formatting in Modern SharePoint Sites ...
0
votes
1answer
45 views

How can I add conditional column formatting for Boolean expression in JSON?

I have a SharePoint Online list with a number of reference columns: they need to be included in the view so that I can reference them in the JSON conditions in other columns, but the users don't ...
0
votes
1answer
128 views

Add background-color or any css to “Section” in List Form in SharePoint Online using JSON formatting

We have provision to create Sections in Form body by putting in JSON code. I also need to change background-color CSS property of the section. { "sections": [ { &...
1
vote
1answer
24 views

SP List JSON Body Configure Layout - how to add Modified (date/time)

I am configuring the display of the body using JSON of a SP List with a number of single line of text fields. Now I want to make visible the Modified (read-only Date Time) field which I added as a ...
0
votes
1answer
36 views

How to separate Managed Metadata column values by a comma and display on one line?

By default, it seems when you select multiple Terms from a Managed Metadata column in a Document Library, SharePoint Online will display each Term on its own line, eg: Some_Tag_01 Some_Tag_02 ...
0
votes
1answer
54 views

JSON formatting to show field value that's hidden by default?

I have a number of "utility" columns in my SharePoint online list that are used by the JSON in other columns (for example, I need to check that the "Email1" column is populated ...
0
votes
1answer
40 views

SharePoint Doc Library - JSON changes color of text in hyperlink column

I have a hyperlink column which displays a light blue color, until I add some conditional formatting to indent child documents. My script is: { "$schema": "https://developer.microsoft....
0
votes
2answers
66 views

JSON formatting to add hover + button (for action to trigger Flow)?

I have a column that I've successfully set up to conditionally display a button with the ExecuteFlow action. It's working to do everything I need... be visible or hidden, display the correct label, ...
1
vote
1answer
34 views

Change Field Text

I would like to change the text in a field based on the choice of the same field: When text Green choice selected, it will be displayed as a big Green dot, so goes to amber and red. Can it be done ...
1
vote
1answer
41 views

JSON column formatting “number” without decimal place and 1000 separator as “.”

I have a SharePoint list where a column contains numbers but those numbers are shown as: Example: "1,181,180" instead of "1181180" (this is what I need). I created the list ...
0
votes
2answers
18 views

How to create a tooltip for Column Title on hover in MS Lists?

I created MS List where I need to add a tooltip for "Prioritization" Column name when mouse over the Column Name. Tooltip text to be displayed: "Ranking: C- Critical, H - High, M - ...
0
votes
2answers
40 views

Any way to have document read time in SP library Tile View JSON Format

Is there any way to estimate the document read time in SP Document library Tile view using JSON formatting. Any help would be appreciated.
0
votes
2answers
54 views

SharePoint Modern Column Header cuts off

I have a Modern SharePoint document library that includes a column header that is slightly too long, and cuts off: This "Date Last Declared" column is a Date and Time column. I'm able to ...
1
vote
1answer
23 views

Create a hyperlink based on a field entry

I am trying to format a column and create a custom hyperlink in a column field based on a specific criteria. I have three options for this field and I only want to create a link if the field is one ...
1
vote
1answer
161 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 ...
0
votes
1answer
53 views

SharePoint Modern List - Increase column width with JSON Issue

I am trying to increase the width of a column in a modern SP list. Here is an image prior to adding JSON: As you can see, the width of the "Description" column needs to increase in order ...
1
vote
2answers
69 views

JSON Row Formatting Display Icon based on column value

I am working on some custom JSON using the "rowFormatter" view formatting schema. I want to display an Icon depending on the value in another Column. My conditional statement is not working. ...
1
vote
1answer
13 views

Combine the PnP date-range-rag and custom-header-format on Modern Page

Link to the samples: https://github.com/pnp/List-Formatting/tree/master/column-samples/date-range-rag https://github.com/pnp/List-Formatting/tree/master/view-samples/custom-header-format When I try ...
0
votes
1answer
97 views

SharePoint 2019 On Prem - Modern experience - Conditional Formatting not working

Environment: SharePoint 2019 On Premise Requirement: If a Number column value is equal to 0 then set sp-field-severity--good else set sp-field-severity--warning Trial: Based on the article at Use ...
0
votes
1answer
23 views

Can we preserve the colour code when exporting a list into excel sheet

I have a custom list where I applied a color coding for some fields as follow inside modern UI: But if I export the list as excel, the color code for the fields will be lost. As follow: So is there ...
2
votes
1answer
34 views

Conditional visibility of the button in the List

I have configured button in my list, that triggers particular flow. However I would like the button to be visible only if there is value filled in particular column (e.g. column "Name"). ...
2
votes
1answer
389 views

Change the width of a card in Gallery view of a List

I've been been thinking of migrating our existing FAQ from a wiki to a List in SharePoint Online. Changing the view to a Gallery looks promising: But is there a simple way to make the cards wider?
0
votes
1answer
66 views

SharePoint Online - formatting column headers

I have created a modern list in SPO with JSON conditional formatting on the row and view levels. One conditional formatting snippet I've added hides the cell text (row level) based on the current user....
0
votes
1answer
55 views

Doc lib view formatting: accessing filetype icons

I am trying to get the file icons displayed in the standard view in the document libraries: I want them to be displayed on a custom "file card" alongside the filename and a preview. The SE ...
3
votes
2answers
247 views

Conditional formatting of a field on a sharepoint list by month of a date

As you can see in the picture, I have a date type field and I would like this field only to be displayed in orange when the month of the date is equal to the month of the current date but I don't not ...
1
vote
1answer
192 views

How to format Sharepoint Lookup Column Additional Fields

I have two Sharepoint lists. In List 1, I have a lookup column with additional fields linked to List 2. I am able to format the lookup column itself but I dont know how to do it for additional fields. ...
1
vote
2answers
106 views

Wrap text on title and hyperlink columns

I'm trying to import a list from Sharepoint On-Premise to Sharepoint Online. In the old list, the text was wrapped for both the title and the hyperlink column which gave the list an organized and ...
2
votes
2answers
135 views

How to display past list items related to a column value?

I have the following SharePoint list in which the "Participant" columns are text values (names of people) and each item in this list is a training event. "Evenement" is the type of ...
1
vote
1answer
39 views

How do I apply more than one conditional formatting rule using JSON to a SP Online List column?

I have two calculated columns Variance and Variance %, they both have conditional formatting (via the SP Design Space) to turn the background green when they are less then $10K and 10% respectively. I ...
1
vote
1answer
46 views

Lists: Show image overlay on mouse over

I'm customizing a gallery view in a SharePoint list containing employee photos. Now I want to overlay a magnifier icon (via the Fluent Icon library) when visitors hover over the image with the mouse. ...
1
vote
2answers
227 views

SPO: Using JSON to Show/Hide Modern Form Field Based on Value Selected in Lookup Column

I am trying to modify the new-entry form of a modern list in SharePoint Online by hiding or showing a field based on the value selected in a preceding field on the same form. Microsoft offers ...
2
votes
2answers
363 views

Change Column Header Font Color on a Modern SharePoint List

I've been trying to hide a column header in a groupedby list on my Modern page. Since I haven't been successful (can't add a web part), I thought I might be able to format the column and add Json to ...

1
2 3 4 5
7