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
2
votes
1answer
13 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
0answers
22 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
35 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
25 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 ...
1
vote
1answer
26 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
38 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
31 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
51 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
40 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
35 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 ...
0
votes
0answers
55 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
30 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
20 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
19 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
32 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 ...
0
votes
2answers
62 views

Formatting issue for View

UPDATE::: Sorry everyone I have been clearer. This is supposed to be for the "format my view" feature in the Sharepoint Online custom list. I'm trying to make the entire row change color based on ...
0
votes
2answers
127 views

Apply the friendly date format to a calculated column in a SharePoint list

I have a calculated column [Due date] with a simple formula, =[Event date]+13, and it's set to The data type returned from this formula is: Date and Time. However, it doesn't have the Display Format:...
2
votes
1answer
213 views

Yes/No field in JSON view formatting

This is about JSON formatted views (not columns) in modern SharePoint online. List A has a Yes/No field. The values show as Yes or No in the view. When I format the view and show the field value ...
0
votes
0answers
37 views

SharePoint List Formatting; Float Left, 31 Items, Displays 10

When using this sample: https://github.com/SharePoint/sp-dev-list-formatting/blob/master/view-samples/document-library-thumbnails/document-library-thumbnails.json All items should display as ...
1
vote
1answer
61 views

SharePoint List Formatting

I need to do a databar format on a choice column with text inside. Is this possible? I can get it easily enough with the given JSON formatting code but i cannot seem edit the code below enough to ...
0
votes
1answer
39 views

Update a column if Date in another column has been breached?

I am trying to update a column value IF the Date presented in another column has been breached. I will then need to format the row the has breached this date in Red. The columns are: Date ...
-1
votes
3answers
52 views

Organize multi-choice user inputs by separate line (not comma)

I would like to format a column, so that when a user selects multiple choices, each choice is displayed on a single line rather than separated by comma (,). I'm looking to leverage JSON formatting ...
2
votes
2answers
41 views

How to utilize “if” condition in a link using JSON column formatting in SharePoint?

I am trying to remove all of "AAA" links from a link column called "LinkList" using JSON column formatting. "AAA" is a link not text. I am in trouble to hide all of this kind of cells in that column. ...
0
votes
1answer
326 views

SharePoint JSON tileProps breaks formatting

I am attempting to troubleshoot a formatting issue with JSON and actually found a Microsoft example that has the same problem for me. I developed a list using the same column names as the code below: ...
2
votes
2answers
187 views

SharePoint Column JSON formatting alignment

As mentioned in the Title I have some issues with trying to align my background color formatting as shown in the screenshot below: What I hope to do is to get the BACKGROUND COLOR to align WITHOUT ...
1
vote
2answers
84 views

SharePoint Column Formatting: Referencing External Columns in Mail To Body

Hello Stack Exchange Community, I have a question regarding referencing external columns. In my code below, external columns are referenced using square brackets as specified in Microsoft's online ...
0
votes
3answers
80 views

Create List in SP OnLine Using C# or PowerShell

Not new to SharePoint but new to SharePoint OnLine. So, here's the question(s). Is there a way to dynamically create a list using REST,JSON, or C# in SharePoint Online? I've seen some sites ...
0
votes
1answer
145 views

How can JSON column formatting be used to highlight duplicate entries in a column a list?

Column formatting is used in SharePoint Online to customize how fields in lists are displayed. Microsoft provide documentation regarding the use of JSON for column formatting. As is described in the ...
2
votes
1answer
54 views

Is it possible to highlight the first 5 rows in a SharePoint view?

I have a view that sorts items based on a date field, from earliest to latest. The order will change over time, as users make edits to the item dates. I would like to apply formatting that will ...
0
votes
2answers
80 views

response.json return problem - undefinied

I have got problem with response . json() return problem. I have got two methods one is Mocking List, and another is by JSON. Mock method works superb. but return from response.json() returned me ...
0
votes
0answers
38 views

Color based on value in SharePont Online task list (added app)

Using SharePoint through my company's 365 account, had a need for a clean list with parent/child relationship, the subtasks in the Task List app fit the bill nicely, out of the box, but now I feel my ...
0
votes
1answer
49 views

Referencing 'Version' Column

Hi there, I am relatively new to using SharePoint as well as JSON and as mentioned in the subject, I am having issues in trying to reference the Version column (set by the approval status). What I ...
0
votes
1answer
89 views

sharepoint column formatting json examples with paging

I was thinking if I had a list in Modern UI and then use JSON column formatting. Does it support paging or sorting through the items? Thanks in advance.
0
votes
1answer
47 views

JSON Formatting Nested Conditions

I have a field that I want linked to either the NewForm or the EditForm If it is null, the link generated will point to NewForm.aspx, if it has a value, I want it to point to EditForm.aspx with the ...
0
votes
2answers
38 views

If current field (target closure date <= today AND Status = “Open”(This is drop down option)), then text should display in red color

If current field (target closure date) is <= today AND Status = "Open"(This is drop down option), then text should display in red color. I have tried with below JSON but no luck: { "$schema": ...
1
vote
0answers
145 views

SharePoint Column Conditional Formatting - Applying CSS classes to a date field using a nested IF statement

Apologies, I am relatively new to SharePoint/JSON, So forgive me if I am not seeing the obvious. I would be INCREDIBLY grateful if someone would help. I would like to apply conditional formatting to ...
0
votes
1answer
60 views

Sharepoint JSON not saving

I am just adding some JSON code to my columns to change the text color. All columns work as expected, but one ("Doc. #", a completely vanilla single line text column) keeps removing the code ...
1
vote
1answer
40 views

Hide/remove shring option on a library

We have a special library where only a select few have access to. Then we learned that those select few can just share a file with anyone. Not good. I tried creating a custom permission level, but ...
1
vote
1answer
63 views

Addition of 2 column values and displaying 3rd Column in SharePoint Online modern site

I am using SharePoint office 365 modern site, I have to perform some business calculation and display the results in different column and get the sum total for this. Scenario 1: ColumnA with value ...
0
votes
1answer
86 views

SharePoint modern view formatting with JSON

My style is accepted but it overrides the ATTRIBUTES: Class. How would you suggest I take advantage of incorporating the if(indexOf(@currentField inside the STYLE - which will allow me to do a ...
0
votes
1answer
290 views

Help with JSON to format column to show picture instead of URL

I have a contact list created in SharePoint Online. My list has a column called "Picture URL". The "Picture URL" column is formatted as "Single line of Text". I have formatted the "Picture URL" ...
0
votes
0answers
20 views

SharePoint Images Of Staff Members Not Showing (Just Black Square with White Cross)

I have recently tried to create a staff contact List in a SharePoint Online Environment/Site. The List has been created fine and all works apart from the Staff Picture field. The URL addresses for ...
0
votes
1answer
20 views

No Column formating template

I am trying to add a column format template , basically marking the column “red” when the column is set to “No” and “blue” for when it is “Yes”. My custom columns, they don’t have the option to ...
2
votes
3answers
271 views

what can you do with Format View

I’m playing with modern experience and inside the document library. I found this option format view . What can you do with this ? what are the possibilities ?
1
vote
2answers
195 views

Help to amend existing JSON to add a vertical align element

I currently have the JSON formatting applied to a column: { "$schema": "developer.microsoft.com/json-schemas/sp/…", "elmType": "div", "txtContent": "=if([$Review_x0020_Status] == '', '', '•')", ...
2
votes
1answer
129 views

Help with Traffic Light SharePoint Calculated Formula

I am wanting to create a column called "Traffic Light" on an existing SharePoint Library. Column Name = Traffic Light Data Type = Single line of text Formula: ="<DIV style='font-weight:bold; ...
2
votes
1answer
24 views

Formatted column button doesn't start the flow

I am having an issue, that none of the members of my organization can call a flow from a formatted column button in a Sharepoint list. Below is the script used to create this button: https://docs....
1
vote
2answers
51 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
1
vote
1answer
252 views

I am looking for a JSON query to format Currency column in SharePoint Online

I am looking for a JSON query to format Currency column in SharePoint Online. Below query works but removes currency icon from the value. { "$schema": "http://columnformatting.sharepointpnp.com/...
0
votes
0answers
29 views

Way to get List webpart to work with List properties webpart on mdoern page with custom View format

I am trying to get my list webpart to work with the list properties webpart in the modern pages, while having some custom JSON View formatting, but finding that "hideSelection": "true", seems to ...