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.
735
questions
0
votes
0
answers
7
views
What is the Json syntax to reference a different SharePoint online column from the current field?
I am trying to use the value in the "Product" column as the friendly URL for my "Dummy Link" column which is a long URL. Below is the "Dummy Link" column JSON formatting.
...
0
votes
0
answers
9
views
How can i keep a SharePoint list person col and a text col in sync - one with DisplayNames, the other with corresponding User names?
SharePoint 365 list, called Project Tracker
Column 1, DisplayName - Person column, No Groups, allow multiples.
Column 2, UserID - Multi lines Text.
For each DisplayName, want corresponding UserName, ...
0
votes
0
answers
20
views
SharePoint list - Change text vertical alignment to top in a column issue
I have a sharepoint online list with two columns.
The column Court/Sec is a single-choice with a few data. The column Excused is a multi-choice full of data.
I want to have the column Court/Sec with ...
0
votes
1
answer
20
views
How to make a custom button visible for only 5 people?
I have a list where I have a column I formatted in JSON to show an approval button.
The button only needs to display for 5 fixed persons.
How can I set this up?
I already tried with the mailadres == @...
0
votes
0
answers
18
views
SharePoint List Tiles Floating problem
I've created several SharePoint lists with custom views in order to include them in web parts on web pages.
Normally, these tiles are supposed to be displayed side by side but since yesterday I've ...
0
votes
1
answer
20
views
Figuring out a Json format for the background to change colour for multiple values
I am wanting to format a column so it can automatically recognize different phrases and change the background of that cell to the same color.
So for example I may have 5 rows of data in one column:
...
1
vote
1
answer
15
views
Conditioning Column Formatting based on Date and entry in another Column
I am completely new to this and am trying to create a Register in Sharepoint.
Basically what I want to do is:
If the date in Column 1 is coming up in the next 5 days, I want to change the font to ...
- 11
0
votes
0
answers
41
views
List Formatting using multiple icons as buttons to set Value of [$Status]
I have a list I use as a Visitor Register in SharePoint. I use the list to keep track of hundreds of visitors. This is managed via the 'status' column (Appointment, Check-In, Overdue, Check-Out).
I am ...
0
votes
0
answers
48
views
SharePoint Online JSON tile custom formatting - setValue updates not shown
I am creating a custom tile view for a SharePoint Online list. I have buttons on the tile view which use the setValue action to update the item. This works, but the change is not displayed immediately ...
- 1
0
votes
1
answer
32
views
SharePoint Online JSON tile custom formatting - loop through available choices
I am creating a custom tile view for a SharePoint Online list. I have a choice field called Result. How can I loop through the available choices to display a button for each of them?
I have found ...
- 1
0
votes
1
answer
26
views
Not Working : Get jobTitle and other contact details from user and enter into SharePoint list field with JSON formatting
I m trying to reference to other contact details (except from email and title) but I don't get the value.
For example : [$InternalNameofField.jobTitle]
- 11
0
votes
1
answer
24
views
SharePoint List formatting a Date column (#2)
I have a SharePoint List. Two of the columns are "Due Date" and "Status". The Due Date column is obviously, populate with dates, with times turned off. The Status field is a choice ...
0
votes
1
answer
82
views
Is Gallery view json formatting removed?
We are developing Intranet. It was developed successfully in sandbox. We have a list with gallery view formatting. We haven't customized it. We have selected that view and selected columns only. we ...
- 1,138
0
votes
2
answers
39
views
What is the JSON code for just showing profile picture (not the name) in a SharePoint list view?
I have a SharePoint list with a Person column and the list has 3 views. For the 3rd view I want only the picture shown and not the name of the person.
How can I do that?
- 139
1
vote
1
answer
135
views
SharePoint List column conditional formatting
New to this still on the learning road.
Situation. I have a SharePoint list that contains the following columns:
Name, DOB, Location, Comments.
I need to use a conditional formatting rule that in the ...
- 13
0
votes
1
answer
161
views
I cannot hide the "New" button in SharePoint list using JSON
I have tried using the following JSON code to hide the "new" button from SharePoint list but it has no effect. It works on all other buttons except new. Can some please help?
Here is the ...
0
votes
2
answers
176
views
Hyperlink column not working as button
I have SharePoint list which adds the item based on the flow, however the column hyperlink is not working as a button. But when initially created the list it was working but now it is not.
{"...
- 115
0
votes
1
answer
49
views
change colouur of background button in json formatting
I'm doing some filtering on 2 webparts.
Below is the firet webpart that filters based on the letter A,B etc..
When click is it possible to set the background colour to a colour (For exampleto the ...
- 4,308
0
votes
1
answer
115
views
SharePoint Online Make only 3 columns appear per row using configure layout
SharePoint online, is it possible to make only 3 columns appear per row using configure layout?
I'm using SharePoint online modern experience and want to display only 3 columns per row only using ...
- 1
0
votes
2
answers
128
views
SharePoint online library column JSON formatting based on other column value
I need to format a column named 'Action' with hyperlink as follows:
If column name 'Status' is having value as "Accepted" or "Rejected" then 'Action' column should have hyperlink ...
0
votes
1
answer
144
views
JSON formatting of list header part - two rows of text
I have the below json code added to the header section of a item list editing window. The code adds two links, one next to each other.
I'd like the second link to appear either in a new row (i.e. ...
- 15
0
votes
1
answer
29
views
Column formatting by elapsed time
I need to format a column in SharePoint Online with this features:
If the value in the "Ordine" column is "ASSENTE" and it has been more than 5 minutes since the record was created,...
1
vote
1
answer
36
views
Checkbox - align center
On Yes/No Checkbox - JSON sample, there is a code allowing you to show checkbox (square) for a YES/NO column regardless of the current value of the field (by default checkbox only shows if YES is ...
- 15
0
votes
0
answers
15
views
Duplicated Headings in SharePoint List Forms
Recently, while immersed in the task of formatting the form body within the Site Pages library, my objective was to introduce structured headings to categorize the various fields. Leveraging JSON, the ...
- 2,191
0
votes
2
answers
69
views
SharePoint - show Yes/No column from a lookup table
I have a list A which has columns ItemCode (text type) and Enabled (Yes/No type).
In list B I created a lookup column to list A. I am able to show in list B ItemCode from list A however I don't seem ...
- 15
0
votes
2
answers
35
views
How to add condition to the SPO column with JSON
Can a condition be added to the multiple-line text column so that if it includes a semicolon, it sends a notification, changes the color, or something similar?
- 605
0
votes
0
answers
36
views
JSON Code based on date and priority
I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends.
In my priority column I have the following options:
...
- 1
0
votes
1
answer
93
views
Show/Hide Column Display name using a Condition using JSON Not PowerApps
I want to remove the title "Please upload the personal image if needed", if the Visa Support is "Yes", and show it if the Visa Support is "No".
I want to make it using ...
- 1
0
votes
1
answer
111
views
SharePoint column show/hide condition - Multiple conditions with OR
I have a Choice column that I want to display if either of two conditions are true.
It's an Approver Response column that I want to hide if "Approver Notified" checkbox = false, and Status = ...
- 413
0
votes
1
answer
47
views
SharePoint default form json - How to set a section name to = the display name of a user from a people-picker
I am building a SharePoint default form for creating a new doc set in a SharePoint online Library. This form has 3 Approver fields (people pickers).
When they go into the submitted form to provide ...
- 413
0
votes
0
answers
77
views
JSON Code is having no Effect on Column Formatting in a SharePoint Online List
In SharePoint Online, I have permissions as "Owner" (not ADMIN). I have created a list. The column types vary (of type URL, Text, Date, etc.).
For the URL column, I added the following JSON ...
0
votes
1
answer
165
views
Hide "Favorite/Unfavorite" button in ribbon via list view format CommandBarProps
Need to hide majority of button in library ribbon - using "Format View" option and JSON editor work for every button.. except "Favorite" and "Unfavorite".
Syntax ...
- 903
1
vote
1
answer
135
views
Conditionally Hide Show Fields On A SharePoint List Form
I am creating a SharePoint list in which I have list 'Invoice/Receipts'.
I am doing conditional formula so that when the 'Cost Category' column value 'Travel' or 'Allowances' is selected, 'Invoice/...
- 11
1
vote
2
answers
83
views
Show a column if another column has a specific value in microsoft lists
On my list, when adding a new item, I need the visibility of one column field to be toggled based on value from another column/field (which is a multiselect type of column).
For example column A value ...
- 25
1
vote
1
answer
46
views
Microsoft Lists how change color if date is more than 6 months in the past
I'm trying to color a column item based on date value. I'd like to highlight date if it was > 6months in the past. Below is what I tried but doesn't work as text becomes completely hidden ...
- 25
0
votes
0
answers
47
views
JSON progress bar always full in SharePoint
Is there any way to show a progress bar under a text formatted as Accountability in SharePoint online?
The progress bar must put in relation 2 values: let's call the first Amount Financed and the ...
1
vote
1
answer
19
views
If two columns show no date, "Status" column shows "Incomplete"
I am very new to JSON. I have a document library, and I am trying to have a "Status" column populated with "Acknowledged" if two columns show a date, or "Unacknowledged" ...
- 13
0
votes
2
answers
153
views
How to change the background color of a list to red with JSON?
How to change the background color of a list to red with JSON?
This is what I have:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
...
- 139
0
votes
0
answers
28
views
Use JSON row-formatting for my list to give additional rows a different color. But the color is not correct
I use this JSON code below to give additional rows a different color.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"...
- 139
1
vote
0
answers
22
views
SharePoint list form - Column conditional formatting in Swedish
I'm using SP in Swedish at work and want to add conditional formatting for show/hide columns on a list form.
I want pretty much exactly this but translated into Swedish syntax:
=if([$Category] == '...
0
votes
1
answer
38
views
Replace semicolon with comma in SharePoint text colomn
I am having an issue replacing the semicolon with a comma. I am using the JSON replaceall function to do this, and it looks like it does the job. However, you can still see the semicolon when you ...
- 605
0
votes
0
answers
34
views
SPFX customFormatter
Is it possible to take the JSON of a customFormatter from a field info object and apply it when rendering a component?
I would like to render choice fields as they are displayed in a list view.
For ...
- 493
1
vote
1
answer
16
views
How do I make a list date column turn mint green if the date entered is within the last 12 months and turn light red if it outside of 12 months?
I have a list made that tracks several employee training dates. We are currently entering the date they last tested/trained. Trainings are due every 12 months or every 36 months.
How can I make the ...
- 11
0
votes
1
answer
112
views
JSON formatting - remove hyperlink in one view only
I have two views in a SharePoint Online document library. I want to strike-out and disable the hyperlink of column 'Name' if 'Retracted' column is true. I've carried this out using 'Format columns' ...
- 1,535
0
votes
0
answers
33
views
Clicking the SharePoint List Web Part title link opens two tabs
If you set a defaultClick action in JSON for a column in a list, two tabs of details will open in the List web part.
Only Chrome and Edge on iPad and iPhone. Safari is fine.
There is no problem with ...
0
votes
0
answers
16
views
Build custom group headers and footers not working
The json formatting code provided by Microsoft at this page: List layout customizations under "Build custom group headers and footers" doesn't seem to work.
If I remove the nested if(s) I ...
- 1
0
votes
0
answers
43
views
I need to show the results of a calculated field on the NEW ITEM Sharepoint list form...thoughts?
So, I have a calculated field that is calculated based on how other columns are populate on the NEW ITEM SharePoint list form.
I am new but I understand that calculated field will not show on the form....
1
vote
1
answer
49
views
JSON to wrap text after ";" from a lookup AND delete blank spaces
I have a column "Action Status" which is looking up multiple values in a separate Actions table.
The first screen shot shows how the data appears without applying any JSON coding (I'm a ...
- 23
0
votes
2
answers
304
views
Is it possible to use an if statement on choice type column in MS List conditional formatting?
Apologies this is my first question so I will summarize the issue as best as possible.
On the list I have created below in the progress column I created a drop down option using choice type. I have 3 ...
- 3
0
votes
1
answer
27
views
multiple conditional formatting
New to the whole JSON code within SharePoint lists, hit a brick wall and having no luck with research.
I require 2 conditional formatting writing into the cod but am not having much look.
First - if ...
- 1