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
79 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
304 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
572 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
65 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
98 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
41 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
111 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
102 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
546 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
533 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
161 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
149 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
246 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
57 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
104 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
44 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
56 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
167 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
56 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
49 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
213 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
106 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
82 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
155 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
418 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
22 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
441 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
422 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
194 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
32 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
103 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
469 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
53 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 ...
1
vote
2answers
261 views

Conditional formatting based on date to expire

In SharePoint O365, in the modern experience, I have a list of training certificates that have an expiration date of one year from date taken. I would like to use conditional formatting to create a ...
0
votes
1answer
290 views

Sharepoint list, conditioanlly displaying icon

hope you are doing well. I am currently trying to custom format a list using JSON. I am having trouble conditionally displaying the "Attach" or paperclip icon depending on whether the field attachment ...
1
vote
1answer
492 views

JSON datetime tracking custom formatting

I am trying to format a sharepoint list with JSON so that the From/To column highlights the current phone number when todays date falls into the timespan given. I have managed to have past on future ...
0
votes
1answer
460 views

JSON column formatting with if/else in SharePoint?

I would like to nest if conditions into SharePoint via JSON column format. I have two fields, Date and Status. The status field contains 3 strings ("Done", "Pending", "New") Example: if ([$Date] &...
2
votes
1answer
1k views

column formatting with json for lookup fields

I have problems formatting the column of a lookup field with json. Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
1
vote
1answer
113 views

SharePoint online column formatting not reading my children array in JSON object

I can get the formatting to render the background and font style for the column text but not the icons in the children element. I have messed with this for days. I must use style elements as opposed ...
1
vote
2answers
275 views

Remove all commas from single line of text field

Trying to remove all commas from a single line of text SharePoint Online field entries. Any ideas on how to achieve that, any formatting formulas, or JSON? Thank you in advance!
0
votes
1answer
838 views

How to format a SP Online List Name ( Header ) using JSON via Format View?

I have used JSON to format most of the columns on a list and then some using "Format Current View" and "Format This Column" however I've scoured the web looking for a solution to formatting the List ...
0
votes
1answer
1k views

How to change font size for all rows in a list using JSON on SP Online via Format View

I know that I can format each column view by "Format This Column" but is there a way to format the whole list in the same manner? In particular, increasing the font size or any of the font attributes ...
0
votes
1answer
220 views

Reference Metadata field with JSON Formatting

I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value? { "elmType": "a", ...
2
votes
0answers
83 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 (:) ...
0
votes
1answer
390 views

Conditional Formatting based on choice selection from another column

I'm new to SharePoint List Conditional Formatting I've got two columns one is [$Status], and the other is Due Date. If the status is resolved it will be green, if the status is open and the due ...
0
votes
0answers
64 views

List items not aligned with custom formatting

I am experimenting with json view formatting. I am working with this template, that should show the list items next to each other like on the screenshot: Instead, they are presented like this in my ...
0
votes
1answer
643 views

list view web part with custom view formatting

I customized a list view that, contains the followings: { "elmType": "div", "attributes": { "class": "ms-bgColor-themeLighterAlt ms-bgColor-themePrimary--hover ms-fontColor-white--...
0
votes
0answers
223 views

JSON column format not working for Rating Scale questions

When adding JSON column formatting to a 'Rating Scale' question it does not appear in the survey. When I use the same JSON column formatting on a list however it does work. The purpose of the JSON is ...