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.
778 questions
0
votes
0
answers
20
views
Unable to reference lookup column additional fields for (conditional) JSON formatting
This should be simple but isn't: I am pulling info from a list into another through a lookup column. I am bringing in several additional fields. The list is populating as expected. However, when I try ...
0
votes
0
answers
17
views
SharePoint list displays time since creation instead of creation time
In the list, on the SharePoint website, the creation date information disappeared and only one remained. (printscreen)
I don't know why this happened, but it could be easily fixed by changing the ...
- 101
0
votes
0
answers
23
views
How do I remove a list heading which has JSON formatting
How do I remove the blank space where the free text heading goes at the top of my list?
I've applied JSON accordion style formatting to create an accordion style list and to remove the column headings ...
- 1
0
votes
1
answer
56
views
How do I create a working button that updates dynamically depending on the values of two columns in my SharePoint document library?
I need help with creating a JSON structure for formatting a custom "single line of text" column in my SharePoint document library. The column, called "Start Document Workflow," ...
0
votes
1
answer
88
views
JSON formatting in list Gallery view not displaying Office UI Fabric Icons
This problem is very similar to this one, except it's not displaying icons and I'm using different JSON code.
Using SharePoint Online, I have a list I use specifically to display customised buttons ...
- 264
0
votes
1
answer
46
views
Need a JSON to add 0 to before SharePoint list Number
I have a list column called "Item number" created automatically when item is created.
It is created in sequence like 1, 2,.... till 999
I need a JSON to show only three digits of this item ...
1
vote
1
answer
68
views
JSON formatting works on one list but not another
In SharePoint Online I've created a list and applied JSON formatting to a particular view. This formatting essentially displays the items as buttons. I then created multiple views and applied the same ...
- 264
0
votes
0
answers
22
views
My multiline field is not displaying with my JSON code in SharePoint
My multiline field is not displaying with my JSON code in SharePoint
My code is below: [$test] is the multiline field:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/...
0
votes
0
answers
32
views
How to remove the SharePoint lIst line and selection with JSON?
I have added a Sharepoint list to the List Webpart. you see there is a line. How can i remove it with JSON:
Also when i hover over de row it gets another color. How can make it stay the color white?
...
- 71
0
votes
1
answer
29
views
Displaying Column Names in my JSON-code
I have three columns with the following InternalNames: Before, Between, and After. The corresponding column names are 00:00 - 07:59, 08:00 - 15:59, and 16:00 - 23:59.
How can I modify the code below ...
- 71
0
votes
1
answer
37
views
When a user enters text in the column Opmerkingen than an icon must be displayed instead of text
I have a SharePoint list with 5 columns. One is called "Opmerkingen". What I would like is that when a user enters text in that column it shows an icon "comment"instead of the text....
- 71
1
vote
0
answers
34
views
SharePoint list doesn't show the current day at the top
I have a SharePoint list with a customized header, and the header is fixed when scrolling. One of the columns in my list is a date column, and the filter of my list is set to display the row with ...
- 71
0
votes
1
answer
124
views
How to make a custom header in JSON fixed?
I have a SharePoint list with a custom header made in JSON-code. I got this code from the github.
The code hides the actually header with: "hideColumnHeader is true" and makes a header of ...
- 71
1
vote
2
answers
847
views
How do I correct my conditional formatting in Microsoft List to make the row highlight and bold when the next review is in 45 days?
I am trying to create conditional formatting for a Microsoft list to highlight the row in light blue and bold. I need the date to relative to today and then have the condition be based on a 45-day lag ...
- 11
0
votes
1
answer
81
views
Help needed with JSON to customize a sharepoint list
I have a SharePoint list which has 5 columns. My problem is that my data is not aligned with the columns. What do I have to changed so that my data is aligned with their columns:
{
"$schema&...
- 71
1
vote
1
answer
127
views
SharePoint List group header aggregate different names
I have a list where I group rows and use aggregate() to count specific columns. The issue I'm facing is that the resulting column names all show as "Total Value," which makes it difficult to ...
- 13
1
vote
1
answer
178
views
How to customize the column Title with JSON?
Is it possible to change the column Title with JSON? In the column Title a message-icon is displayed when a user has added a comment. I would like to hide the 3 dots and make the icon aligned to the ...
- 71
0
votes
1
answer
68
views
Show link to document if file_x0020_type is PDF and add a link to open file in native pdf using JSON formatting
Is it possible to Show link to document in SharePoint if file_x0020_type is PDF and add a link to open file in native PDF using JSON formatting?
Happy News Year and thanks in advance.
- 4,368
0
votes
2
answers
128
views
How to centre the data in a currency column that does not remove the £ or decimal
I'm trying to centre the data in my SharePoint List's currency columns (Unit Price, Origination and Delivery Cost). I found an answer that supplied some JSON code to add, which worked but changed my ...
0
votes
0
answers
123
views
SharePoint modern view, JSON, Change the height of gallery cards dynamically
We would like to adjust the height of each card dynamically to the content of each card (see screenshot below). I already tried with "height": "auto", but the cards overlaps after ...
0
votes
1
answer
156
views
SharePoint Online grouped list JSON formatting
I have a grouped list with 2 columns "Question and "Answer". The list is formatted using the following JSON to format the view. Based on a PNP view formatting sample
{
"$schema&...
- 113
2
votes
0
answers
114
views
I cannot hide the "Automate" button in SharePoint library commandbar using JSON Formatting
I have tried using the JSON code to hide the "Automate" button from SharePoint list but it has no effect. It works on all other buttons except "Automate". Can some please help?
- 21
1
vote
0
answers
80
views
JSON Formatting In Views
My gallery views that are JSON formatted are all of a sudden not displaying correctly, although nothing has changed and the views have not been edited. I can create a new Gallery view, but the JSON is ...
- 11
2
votes
1
answer
92
views
Conditional formatting JSON not behaving as expected
I'm fairly new to SharePoint JSON. I have a simple JSON to change the value of a column based on the value of another column:
{
"$schema": "https://developer.microsoft.com/json-...
- 25
0
votes
1
answer
382
views
Highlight cell a color if there is a duplicate entry
I have a SharePoint list that tracks client names. Each client has a specific ID.
If there is a duplicate ID entry, I would like the cells to turn a certain color, is this possible?
- 27