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
0answers
10 views

Resizing an image with json iist view formatting

What I'm trying to do is replicate the look of the news.aspx page for a custom view: To ensure the thumbnail maintains its aspect ratio when it's resized, I figured I'd add the same method that's ...
0
votes
1answer
39 views

How to display Persona Card on hover in list using Sharepoint Online view formatting?

When in an unformatted sharepoint list you can hover over a person's name to get more information about them, I believe this is called their persona card. How can I keep this functionality having ...
1
vote
1answer
26 views

Json in sharepoint column help

I am not a developer and need some help please. I currently have 2 columns in SharePoint that display buttons based on conditions. Both sets of JSON work just fine. Basically I want to have only 1 ...
1
vote
2answers
31 views

Setting the background in JSON Formatting column to red

I have a field in SPOnline I want set to red to show against a progress bar. I thought it would be a matter of just adding a BG colour line but it hasn't worked. Any ideas? JSON below. Thanks in ...
2
votes
1answer
52 views

Grant access to a user based on the value of fields(columns)

I have several user groups such as X1_userGroup X2_userGroup X3_userGroup and in my SharePoint list I have several columns, two of the important one are: Asset_type, Code X1 ,1 X2 ,1 ...
0
votes
1answer
26 views

SharePoint List View Formatting

I want to check the date column in my list along with a flag to format list view: I tried using AND and nested both don't seem to work: { "schema": "https://developer.microsoft.com/json-schemas/sp/...
0
votes
1answer
69 views

Column Formatting to Show a Hyperlink or just Text Based on 3rd Field [duplicate]

PrimaryLink is to display a hyperlink based on the other 2 fields PrimaryName PrimaryURL PrimaryLink JSON for Column Formatting { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/...
1
vote
0answers
31 views

Formatting hyperlink type field with file directory path

By default, a hyperlink type field in a SharePoint Online list looks like a regular field. It's not until you hover over the text that you actually see that it's a hyperlink. I am trying to edit/...
2
votes
1answer
31 views

JSON Column formatting round to integer

I have created this script to calculate the number of days from today, but it returns like 20 decimals. How to round to a whole number? I was trying to do this using floor() but I don't understand ...
0
votes
1answer
35 views

Lookup values invisible on QuickEdit (JSON formatted)

I hope you can help. SharePoint Online: Values on a Choice column appear colour formatted on QuickEdit view.  However values in a Lookup column (values taken from a lookup list) are invisible on ...
1
vote
1answer
35 views

JSON Coding - Delve profile pictures not linking up in SharePoint List

Wondering if someone could take a look at my JSON coding on my SharePoint list to see why it isn't linking up the User's Delve account profile picture? { "$schema": "https://developer.microsoft.com/...
2
votes
2answers
55 views

SPO: Create Hyperlink from Calculated Column

I know there are several questions/answers for this, but I still can't seem to get it to work. Name - Text URL - Text Link - Calculated Column Number Link column =CONCATENATE("<a href='",URL,"'...
0
votes
1answer
71 views

JSON conditional format column based on choice from another column

I am using SharePoint online. I have a choice column and a text column, If the choice "phone" is selected from the choice column, I want the text column to change color. For some reason it wont work - ...
1
vote
1answer
58 views

Formatting list row background color

I am trying to change the background color of rows in my SharePoint (365) list based on values in a column. I am aware you can use additionalRowClass in the JSON formatting pane to alter a row based ...
0
votes
1answer
100 views

SharePoint Library Button (JSON formatting) to update current item field value

I have a formatted Single Line Text field in a SharePoint Library. It is formatted to be a button that executes a Flow. I've created this so I can attach this one flow to multiple libraries. It works ...
0
votes
0answers
27 views

Space between two entries in sharepoint list is too wide

Please help me with the below requirement. Space between two entries in sharepoint list is too wide. Below screenshot for your quick reference.
0
votes
1answer
34 views

How to make far left column sticky for horizontal row scrolling in a list with JSON column formatting?

I would like to make the far left column sticky so that it remains in view when scrolling horizontally on a list with many columns. This is also my Title column. Can this be accomplished with the JSON ...
1
vote
1answer
30 views

Sharepoint link to Delve account

In the SharePoint list, I want to make a dynamic link to a Delve profile. I have a JSON like this: "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "...
0
votes
1answer
22 views

Status calculated column colour code

I have a calculated column with this below formula: =IF(ISBLANK([Confirmed Receipt Date]),"Open","Closed") How do I make Open with red color and Closed a green color?
0
votes
1answer
30 views

Edit link is not working in Json Formatting of view

I have created view using JSON formatting like in below image. The Give feedback button is given editProps as custom row action. This button works in list view, it opens the edit panel for the ...
0
votes
0answers
25 views

How to pass wildcard value with query string using json view formatting

Does anyone know how to filter based on one value in a multiselect? I am using json column formatting in SharePoint online to create a link that will filter a view to all rows where a particular ...
1
vote
2answers
56 views

Barchart formatting in JSON/Column formatting

I am working on JSON/column formatting. I want to show column data in barchart format. (e.g. In below image Progress is the column name and 100/75/50/25 are four different items.) I know we can ...
0
votes
1answer
39 views

Insert bold in column formatting

How do I insert code so this will also become Bold? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "debugMode": true, "...
0
votes
1answer
49 views

JSON formatting to show multiple list items in same row

I am using JSON formatting to change the view of modern SP List, I have referred this article I was able to achieve both the examples but in first example they are showing each item in one row. Can ...
0
votes
1answer
30 views

List layout with json not works as expected

I tried using below json code to make list like tile. It works as expected when open it in the list however, the layout changed when use this list as web part in page. Figure 1 : Open in list ...
2
votes
1answer
28 views

SharePoint color formating

I have a Date column in the list and it represents Expiry date. I need the field to be colored red if the date has passed, orange if the expiry date is less than 30 days, green if the date is more ...
1
vote
2answers
47 views

Can we call HTTP method from JSON Column formatting in sharepoint online

I want to update/change the status column value through HTTP Request(HTTP method that will call flow). Do JSON column formatting support this HTTP method?
1
vote
1answer
22 views

JSON Specification for Column/View formatting?

I am new to column and view formatting but see the power for my users. However, despite the wealth of examples between Microsoft docs and GitHub and the schema itself, I'm looking for descriptions of ...
0
votes
1answer
95 views

JSON Conditional formatting for Column

I'm a bit of a noob about JSON and I want to use it to my benefit. What I want to do based on the attachment is the following: Latin Qual Required? column is set to Choice setting and Latin Qual Date ...
0
votes
1answer
99 views

View formatting on Document Library in Sharepoint Online

I'm looking to format the Site pages view using JSON Formatting. Is there a way to get the Published date field and also the page URL? I see there is no column formatting on Name field on a library, ...
0
votes
2answers
211 views

Formatting multiple values in people and group fields on SharePoint Online with JSON

Wondering if anyone can help me out with figuring out the formatting my multiple values person field on my list. I cannot figure out how to space out the names of each individual under the "...
0
votes
1answer
29 views

Is it possible to simply select an image to kick off a workflow

I have an picture library setup on a site collection. I’m looking to simply have a user select an image from it to trigger a email notification that would relay the image properties or title, is this ...
0
votes
1answer
41 views

Make a column no background colour if no value

I want the columns with no value in it to be blank. What should I add to my formula? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "...
0
votes
1answer
21 views

Change the color of a item if it has been edited

I have a SharePoint list created and would like the item "Did Operations Respond?" to change color depending on if another field "Ops Response" has been edited in that same row. I cant figure out how ...
2
votes
1answer
119 views

Using json listview formatting to create responsive tile view

I'm trying to use this MS documentation to create a tile view for my list items. About halfway down it shows how to use tileProps to enable the Tile view for the drop down and create tiles. It works ...
0
votes
1answer
28 views

Person and group multible selections separate names

So I got this problem where the names stands after eachother, is there anyway to move Alexanders name under Jonas? See picture:
1
vote
0answers
90 views

Writing numbers comma separated in JSON

Following a tutorial: SharePoint modern view formatting with JSON I realized that formatting a column with numeric or currency values are shown like strings. In this case I have the "Price" column ...
0
votes
0answers
46 views

SharePoint Online - JSON Column Formatting

I have a List Lookup in my form. This gives the user the ability to choose multiple unique values. The problem I am having is that the values are being translated back on to the SharePoint list with ...
0
votes
1answer
518 views

Display HTML formatted text from Rich Text multi-line column in SharePoint list column formatted with JSON

In SharePoint Online modern page I am trying to remove the styling that causes a white overlay and hides most of the text using the following JSON column formatting, so that the column height will be ...
2
votes
1answer
99 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. ...
2
votes
2answers
64 views

Set column height equal to height of record in List

I have a SP list where one of the columns is multi-line I have therefore set the style of this specific column as "height":"auto" which works perfectly for this column. I then have other formatted ...
0
votes
1answer
105 views

SharePoint Online: JSON column formatting for “Shared With” column not saving?

Using SPO, I can get JSON column formatting to work on my library. However, any formatting I apply to the "Shared With" column works in preview mode but does not save with the view. I think this is ...
0
votes
2answers
184 views

Apply background color to list using column formatting based on text

I have a SharePoint calendar/list that I am using to track employee absences across numerous accounts. What I would like is when I'm in list view to have each row that represents a different account ...
1
vote
2answers
63 views

JSON Column formatting : retrieve view ID or param in URL

I need to retrieve view ID (or Name) to format a SharePoint list column with JSON formatting. Or at least I should be able get the correct query parameter of the URL. Is there any variable available ...
0
votes
1answer
114 views

Get value of Name column from SPO list for JSON formatting

First of all, apologies if this horse has been beaten before but I can't find anything so far to help me out. I'm trying to do some conditional formatting of a column in a SP list. One of the ...
1
vote
0answers
140 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 ...
0
votes
1answer
38 views

o365 JSON AverageRating

I have styled a (list) view with JSON. Using the column names (last part of the column url), this is all working fine. For a column that uses classification (star rating), the usual JSON code doesn't ...
0
votes
0answers
25 views

Unwanted [Object object] on a Lookup column but page refresh solves

I am trying to create a help desk using a SharePoint List. I am using JSON column formatting to create a MailTo email containing relevant parts of the item, that will be sent on. My problem is that ...
0
votes
1answer
27 views

Json Formatting

I am in a position where all I want to do is change the font color of a column to #002c77 no matter what the text within the text field says. I cannot for the life of me get it to work, and there I am ...
0
votes
1answer
74 views

Trigger flow inside SharePoint

I created a flow from my SharePoint library - Flow -> Create flow. The flow takes a Word Document template and populates it with input from the user (manually trigger flow). It works, but I can only ...