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

Is it possible to put JSON-code in metadata-columns?

I am using 2 metadata-columns in my SharePoint-List: "Created By" and "Change By". In these columns a name appear of the person who has created or changed the List-item. I would ...
0
votes
1answer
31 views

JSON-code doesn't show my picture in my list

I have added JSON-code to my list column "Person" which displays the persons name and profile picture. But it doesn't show my profile picture. What do i do wrong? { "$schema": &...
0
votes
1answer
30 views

SharePoint online custom list formatting - only Transform or writing-mode css ignored

Trying to style the list in the matrix mode where the column headers needs to be hidden and want to display custom headers. On the headers I am applying the style with writing-mode: vertical-rl and ...
0
votes
2answers
25 views

How to increase the font-size of quick links in Sharepoint?

I'm fairly new to SharePoint. Previously a regular user who is now responsible for updating links and files. My boss wants the link text to be larger which is actually a great idea as I hate ...
2
votes
1answer
67 views

Using Json to format a row in a sharepoint list

So I am new to using JSON and need a little help. So I have these two Json codes "additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now - 86400000, 'ms-...
0
votes
1answer
15 views

How to change the color of odd and even rows of a list

When creating a list you get the option to make the odd rows blank and the even rows grey. It generates a JSON-code (I think). How can I change the color from the even rows from grey to blue. This is ...
0
votes
1answer
22 views

How to set the column width of a sharepoint list

Can anyone tell my how to set the width of the columns of a SharePoint list? I want to prevent the user from resizing the columns.
1
vote
1answer
23 views

Changing the Color of a Row in a SharePoint List (using JSON) based on a columns value

So I have a SharePoint list with a column called modified. I used the following code to change the rows colors based on when it was last modified which works fine: { "$schema": "https:...
0
votes
1answer
24 views

Linking the Document Library to the Menu - Site team Theme

I'm trying to add a theme for a team site. New theme i want add by Json and power shell. I have limitations to test my solution I need to ask someone to upload. The new theme should change the ...
0
votes
1answer
34 views

Using Json to check if a column contains certain text

So I have this sharepoint list with a (for example) "Date" column, and I want to check if any of the rows contain certain text. For example, in the rows it will either say "The due date ...
1
vote
1answer
26 views

Using JSON to change the color of a row based on the date it was Modified

I want to insert some JSON into my SharePoint list. Basically I have a Modified column that shows me when a value in a row has last been modified. I would like to have a row turn red if it has been ...
0
votes
1answer
19 views

SharePoint list form conditional formatting - mandatory fields

I'm trying to customize a list form using JSON. The thing is I need to hide some fields depending on a value in a choice field (this I managed and it works) but I need those fields to be mandatory ...
0
votes
1answer
51 views

json column formatting, button that starts flow - can I prevent multiple clicks?

I have a button that starts Approval flow, with 'visibility' attribute that hides it if 'Status' column has value. But users make double-click and open Flow panel twice or more times, so my flow runs ...
1
vote
1answer
76 views

Extract description rather than URL in calculated column to use it with another url

Let's say the first column is UID having number 12345. You will be directed to the URL after you click on 12345. The second column I am trying to create is like a URL to some website followed by 12345....
0
votes
0answers
47 views

SharePoint multiline view-column formatting to create chat

I'm building a SharePoint project using SPFx and PnPJS. In my SharePoint list I created a multiline field. And in the column formatting section I added this snippet here: https://raw.githubusercontent....
1
vote
2answers
38 views

Manually Highlight a SharPoint List Cell

I'm wondering if there is a way to manually highlight a SharePoint list cell, without needing to use conditional formatting. The reason for this is that there isn't a strict rule in order to highlight ...
1
vote
1answer
34 views

Display units in a Number Column while retaining Thousands Seperator

I'm trying to adjust the way that a SharePoint Number Column displays its value so that it can include a specific unit of measurement. I want people to enter into the field only a Number, but for the ...
0
votes
1answer
21 views

SharePoint 2019 on premise - Open lookup column item without modal

Does anyone know any JSON formatting which will open a lookup field item directly without opening in a modal first?
2
votes
1answer
43 views

List - Conditional formatting of a “cell” based on another cell in the same row

I have two columns: "LFR sign" and "Filing". I would like to: If the "LFR sign" is not empty -> "Filing " becomes red if it's empty I am sure this is quite ...
0
votes
1answer
104 views

Dynamic filtering with Gallery list view in SharePoint Online

I have found a way to implement a substitute for a tab control in SharePoint Online. In SharePoint On Premise I used Hillbilly Tabs, but I am not allowed to use SPFx at our tenant so I had to look for ...
0
votes
1answer
35 views

Reading and updating complex JSON Object in power automate

We have a requirement to update the content in the JSON Stored as multiline text column in one of the list, when one of the item in the another list is updated we need to update the JSON data stored ...
1
vote
2answers
120 views

SharePoint Online JSON formatting - Conditional Popup

I've created a custom view that includes a popup description of each file in my SharePoint library. This works well when I'm within a sub-folder that has a list of files, but when I navigate to the ...
1
vote
2answers
32 views

Triggering Flow I'm not prompted for require variables

I'm triggering a Flow from a SharePoint library following this post, basically json column formatting with a customRowAction. That part works fine and I've used it many different times. I'm using the ...
0
votes
1answer
48 views

Sharepoint Lists - Traffic Light Calculated Formula & Format for Dates

I am trying to create a Traffic Light system within SharePoint Online (Office 365) using JSON. The dates should run in accordance to said, Traffic light signal. What I'm trying to do: If "Todays ...
0
votes
1answer
27 views

Modern library, document defaulted to be read only when opened, edit with user choice by column formatting

I have tried in two ways as below. Both are working for Office documents. But When clicked on PDF or video files, are not opening, its redirecting to document library itself. Other than office ...
0
votes
1answer
81 views

json view formatting, wrap all items

I want to basically wrap all my items in one div for a view. So the json I am using: "rowFormatter": { "elmType": "div", "style": { "display": &...
1
vote
4answers
57 views

SharePoint Column - Conditional Formatting

I basically have a calculated column that shows the date 1/29/1900 if there are some empty values in the other columns. Is there a way to use JSON formatting to format it so that if the column ...
1
vote
2answers
72 views

How to convert text to URL in multi line text

I've used the multi line text column in SharePoint, where I want the fields to be clickable. and I used the following JSON: { "$schema": "https://developer.microsoft.com/json-...
1
vote
3answers
63 views

Conditional Formatting ( Color Coding) a date field

I am using the JSON Script below to create a list where records with Expiration date 10 days from @now will highlight RED; 20 Days from @ now will Highlight Yellow, and 60 Days From @ now will ...
0
votes
1answer
40 views

List view formatting with JSON - limit the container height

When I apply view formatting to a doc library view, a height gets applied to the container which leaves a huge white space. This is the html where it gets applied: <div class="e_b_ea5ab61a&...
1
vote
2answers
54 views

Conditional Formatting with JSON - Write to Actual Value?

I'm pretty new to JSON. I have a SharePoint list with employee schedules (shifts) as seen below: My OnClock column uses the following to determine if (now) time is within the stipulated shift start ...
1
vote
1answer
65 views

JSON SharePoint list view - background-image doest not work

I found in documentation that "background-image" is supported attribute but I am not able to use it. Maybe I am doing something wrong. Could you help please, how to use "background-...
0
votes
1answer
203 views

Word wrap in Row formatting SharePoint online

Is there any way we can add a word wrap for the text which goes beyond the tile size? Please see the code used in Formatting the Rows: { "height": 135, "width": 400, ...
0
votes
1answer
70 views

Formatting list row based on score column Office365

I have created formatted the list as a gallery. using two columns such as created by and score. I was wondering if there are any way to do change the background color based on the score achieved. For ...
1
vote
1answer
54 views

Clickable href with the attachments

I have a list with the following columns: Job Description (Single Line of Text) Attachments And also I got a Column named "internLink" which contains the exact name of the document which ...
0
votes
2answers
26 views

SP view formatting row display

Is there any solution to hide specific row in the list using JSON for view formatting. I want to display only rows that match the terms of the current user and hide others. In Column formatting I can ...
1
vote
2answers
39 views

SharePoint modern view formatting with JSON: URL returns void

I'm trying to format a List in SharePoint modern view. When clicking on the the URL "Bekijk recept" I get a javascript:void(0); instead of opening the URL. Here you can see some of the code:...
1
vote
3answers
196 views

Add multiple line breaks to look up column in which multiple values are allowed

I have a specific question regarding line breaks in SharePoint online lookup columns in which multiple values are allowed. I would like to separate each of the values from lookup via a line break. I ...
1
vote
1answer
25 views

Sharepoint column formatting with IF in href attribute

I got this problem: I got a column named "TrackingNumber". In this column I want to be able to click on the displayed Number. The extra feature is, that in another column, there is the ...
0
votes
2answers
280 views

tooltip column on hover a column in SharePoint List Using JSON- Modern List View

I need to show the description of column as a tooltip when a user hover a mouse on a column, I am doing this based on Adding custom hover text using json to a SharePoint list column But I need to ...
1
vote
1answer
26 views

SharePoint people picker columns not showing as hyperlinks in modern view

I've got a SharePoint list which has a People Picker column allowing groups. In SharePoint 2013 and in classic experience, I am able to click the group name to be taken to the group members list (and ...
0
votes
1answer
100 views

SharePoint conditional formatting rule only available for date, how to include time in the rule?

I'm new to SharePoint. I have a SP list for my schedule. I have overdue column that I would like to change background color based on Datetime column and status. The two column are Deadline and Status. ...
0
votes
2answers
96 views

Decrease Font Size in Web Part Using JSON Formatting

I would like to use a web part on a communication site to display three columns of information. Ideally, I'd be able to put this into a 1/3 width zone, however, when I do this currently, the font size ...
0
votes
2answers
95 views

JSON column formatting - Format date column to remove minutes using in an IF statement?

I am trying to format a column that reacts to a value from another column, one of the columns "Projected End Date" is a date format. This has the column formatting applied and when an ...
0
votes
1answer
138 views

Change column name in view using json view formatting

I have a view in SharePoint online where I need to override column name with a custom value. Is it possible to do this using JSON View Formatting? Ref: https://docs.microsoft.com/en-us/sharepoint/dev/...
1
vote
1answer
105 views

color formatting a date column

I'm very new at list formatting. I've created a new list and are trying to get the columns to turn red/green/yellow depending on the date that you put in to the date-column. I want the column to turn: ...
0
votes
1answer
72 views

Json not displying FAQ list properly

I just found out I cannot use "Newsletter style" for my FAQ lists in a modern site. If I use that the entire site will switch between classic and modern style. So I am trying some list ...
0
votes
0answers
26 views

JSON code to change Default view into Newsletter view

I have created a very basic FAQ using a custom list. I want to use the ‘newsletter’ style but when doing this the search box disappears and it appears only in default view. As a workaround I found out ...
0
votes
1answer
296 views

Conditional formatting based on number of days to due date

In SharePoint 0365, in the modern experience, I have a list of contracts that have an expiration date. I would like to use conditional formatting to create a status column that shows me the contract ...
0
votes
1answer
50 views

Can you separate multiple values in a single string in @currentfield delimited in some way to make each value a hyperlink

I'm currently using MS's column formatting JSON to turn a field's string entry into a URL using the following to automatically make the ticket number entry a clickable hyperlink to our zendesk for the ...

1
2 3 4 5