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.
668
questions
0
votes
0
answers
4
views
SP List group header aggregate display
Newbie here! i like to display the value of the aggregate total amount on the group header. I already have a format on my sp list. i followed this blog https://www.sharepointsiren.com/2021/03/...
- 1
0
votes
1
answer
18
views
How can I get a tile/document card view json format to show multiple links using column field
I would like to display images in a thumbnail/Tile view but also with multiple links to different resolution of the image.
It works ok in a list view when i click on the images.
But can't even get the ...
- 4,232
0
votes
0
answers
26
views
SharePoint Online - JSON - highlight selected page
I have followed the guidance from this site and successfully created a menu based on Pages Library. However, I would like to modify the JSON so that the selected page (i.e. the page that is currently ...
- 45
1
vote
1
answer
20
views
Issue in column formatting in SharePoint JSON with If statement
I have a simple JSON formatting code for a column in SharePoint in order to redirect to the appropriate target depending on the content of the record.
Here is the code:
{
"$schema": "...
- 13
1
vote
1
answer
23
views
JSON to Show Time Until a Specific Timestamp - SharePoint List
I have a list of participants in a conference. All participants are arriving and departing on numerous different flights. I am trying to create a Power Automate flow that will send a Teams message as ...
- 13
0
votes
0
answers
10
views
'Check In Comments' - Export to Excel
What I want to do
I want to export Document Library data including the Check In Comments. 'Check In Comments' seems to be a special field, perhaps it is not stored in the same 'database' as the ...
- 2,371
1
vote
1
answer
17
views
Changing color in calendar view to show different locations
I would like to visually show when the locations are different.
So I have 2 rooms that we use Room 1 and Room 2 (location is a free text value but we would use the same text).
I would like these in a ...
2
votes
1
answer
25
views
SharePoint List Person Column should not be blank
I have a Person Column in my SharePoint List that is set to only show in the SharePoint List Form if the value of the Person column is not equal to the email address of the SharePoint List user.
My ...
- 21
0
votes
1
answer
10
views
execution flow button in a SPO library
I have created an SP document library with an execution flow button that extracts the zip files when the users click it. The extract file locations are the same as the zip file in the document library....
- 581
1
vote
1
answer
59
views
How to get lookup column value in single line of text
I Want to display lookup column values in single line of text. ProductName lookup column with multiple selection. I tried using JSON column formatting but values are not showing. Please can anyone ...
- 13
0
votes
1
answer
27
views
Column Formatter using (File) Name field
Simple question so it seems, but I'm trying to set the Title value of a doc library base on the File Name in the column Formatter.
Is this possible?
The source below gets wiped out from the Title ...
- 23
0
votes
1
answer
17
views
Adding a semi-transparent cover on an image in a SharePoint View?
I have a custom JSON view in SPO.
It displays an image (the same one each time - don't ask! this is what someone wants!)
I would like the images in the view to show a 50% transparent shadow on hover (...
- 99
0
votes
0
answers
13
views
Format field if not all choices are chosen
For my use case, I want to have an overview of finished tasks. One part of this list should be if all the responsabilities have been informed.
I'd like to make this a choice list, as it allows the ...
- 1
1
vote
1
answer
43
views
SharePoint Online - FAQ List Colors
I am building a fairly simple FAQ for my team's website. I've got the list setup and the JSON formatting in place but I am trying to get the main column headers to display in a different color than ...
- 11
0
votes
1
answer
26
views
SharePoint List - Modifying center alignment always changes vertical alignment to top
I am trying to use JSON formatting to center align the values in a SharePoint List. Whenever I apply the JSON column formatting, it also aligns the values to the top. Even when I then specify that I ...
0
votes
1
answer
33
views
SharePoint adding 2 zeros to the percentage values in my list
In my SharePoint list, I have a 'Number' column with the 'Show as percentage' option checked.
Unfortunately, for each value in this column, SharePoint adds two zeros, so instead of '100%', it shows '...
- 45
0
votes
1
answer
18
views
SharePoint Online Modern Form Conditional Formatting (Column Rules)
I am working on a SharePoint Online Modern Form solution using the OTB conditional formatting. There are three rules that I am trying to apply, here is the example.
Two Columns:
COL1 - Choice Field - ...
- 49
2
votes
2
answers
67
views
JSON code for SharePoint List conditional formatting - check for value in a single line text cell
I don't know any JSON at all, I work at an IT help desk and am trying to do a little advanced conditional formatting for our SharePoint list, which contains a user database of sorts. We're currently ...
- 23
1
vote
1
answer
86
views
How can I show Attachment Name and preview in SharePoint List
SharePoint List view:
I want to see a preview of the Attachment file in the list and the name of the attachment.
Please share if you have any ideas about this or reference.
1
vote
1
answer
38
views
SIMPLE Column formatting in SharePoint list (SP2019)
I have a pretty basic SharePoint list on a page at work and I simply want columns to be colored yellow (Is it "#ffff00" ?).
In my "List Settings" I select the column I would like ...
- 11
0
votes
1
answer
24
views
SPO JSON - Copy Multiple People Field Emails as Text in New Text Field Commas Separated
Based on this great solution, I am looking for JSON column formatting to copy a multi-person field (people picker), displayed as email
into a text field
displayed as raw text email format
comma ...
- 103
0
votes
1
answer
62
views
JSON Formatting to show last item select from multi selection choice field
I'm trying to create a new field that displays the last item select from another Multi selection Choice field. We currently use a choice for Portfolio Years which show as a string of values selected.
...
- 23
1
vote
2
answers
39
views
SP List - JSON to change font for column list entries
I have a Power Automate flow set up to copy email to a SP list, the column is set to rtf so that the list just has the email body rather than all the (I'm guessing) HTML stuff plain text gives but I'd ...
- 13
1
vote
1
answer
25
views
Change the text color only on specific numbers in column
A little help please! I created a SharePoint list with company contacts and I want in column 'length of service' the numbers 5, 10, 15, 20 etc. years to be marked a different color, for example red.
- 11
0
votes
1
answer
46
views
Specify the choices of the choice column in the JSON-code
I have a Choice column in my SharePoint list, with these column choices set:
Niet verzonden
Aangevraagd
Goedgekeurd
Afgekeurd
What i am trying to accomplish is to create a button from that Choice ...
- 109
0
votes
1
answer
36
views
Change SPO Library Command Bar JSON when single document is selected
I am trying to edit a SPO Library Command Bar using JSON, specifically when a single document is selected via the dot at the left. When I select a doc, the command bar changes. I then try to edit the ...
- 103
0
votes
1
answer
30
views
How to turn the column choices into a button?
What I would like is to create a button from the choice column. So the user can not select a choice by himself. But triggers a power automate flow by pressing on the button. So how can I turn a choice ...
- 109
0
votes
1
answer
30
views
JSON doesn't show the names of the choices in the choices column?
I have json code set for the choice column which is also a button.
My code doesn't display the names of the choices! What do I do wrong:
{
"$schema": "https://developer.microsoft.com/...
- 109
1
vote
1
answer
24
views
Using JSON to list lookup values on separate lines
I currently have the JSON below and want to adapt it so that any multiple values are shown on a separate line, whereas at present each value is separated by ";"
{
"$schema": &...
- 11
0
votes
1
answer
33
views
How can I only show the profile picture of a user (and not his name) in a sharepoint column?
How can I only show the profile picture of a user (and not his name) in a SharePoint column?
I have set the column Person to only picture. but still get the name with it.
I have found a JSON code ...
- 109
1
vote
1
answer
43
views
How to write an IF statement in JSON Formatting on a SharePoint List to get the user's profile image based upon a chosen field value
I'm writing an IF statement in JSON formatting to get a particular image for a card view.
Basically, if the SharePoint field 'IndOrTeam' equals 'Team', then a group image stored in Site Assets is ...
- 13
0
votes
1
answer
56
views
How to retrieve or download SharePoint empty user profile picture?
I would like to know is there a way to download or retrieve SharePoint empty user profile picture?
For example: If you use a person column in SharePoint and get the picture from everybody. The persons ...
- 109
0
votes
2
answers
56
views
Resources for Learning to format SharePoint Online Lists with JSON
What resources would you recommend for someone needing to quickly learn to format SharePoint Online list items and views using JSON?
The individual is not a developer but has basic knowledge of some ...
- 3
0
votes
1
answer
36
views
SharePoint Look and feel or navigation
We are on SharePoint Online and I am wondering if there is a way to achieve our page like this site https://fmx.cpa.texas.gov/fmx/travel/textravel/meallodg/index.php with the left navigation and ...
0
votes
1
answer
74
views
SharePoint Online - Generate an icon via Column Formatting?
I have a list in SPO with a Choice column (Video, Word, PDF). I would like to display an icon in a column called FileType.
I have tried to customize the JSON of the FileType Column but it just shows ...
- 99
2
votes
2
answers
155
views
SharePoint List JSON Conditional Format of Date Column When # days passed
I've went through a bunch of questions trying to find the answer to my questions, but a lot of recommendations don't quite fit into the code that I have. I'm using the formatting that SharePoint ...
- 23
0
votes
1
answer
316
views
Making a custom SharePoint List JSON View Format that can automatically display new columns
I have created a JSON view format in a SharePoint List for a client. They anticipate that in the future they will be adding additional columns to the list, but they do not have the in-house expertise ...
- 47
1
vote
1
answer
24
views
Add 3 conditions to an actionParam from JSON
I have managed, somehow to add 2 conditions for an "actionParam" in JSON.
Now I would like to add an extra condition.
Please can anyone help me?
Thank you!
{
"$schema": "...
- 11
1
vote
2
answers
142
views
Conditional View Formatting doesn't show right away on Calendar View of my list
I have created a list on SharePoint in order to view it as a calendar. Since color coding isn't possible, I followed a web tutorial on using JSON to be able to color code different types of events.
I ...
- 11
1
vote
1
answer
59
views
SharePoint JSON email attachment
Is there anyway to add an attachment to Outlook using mailto: in JSON?
For example, I have a list that has an attachment. I have a email template that opens in one of the columns using JSON. I am ...
- 11
1
vote
1
answer
80
views
SharePoint JSON hyperlink text in email
I have a list that has a combination of numbers. In one of the columns for that list I am writing JSON code that pops up outlook with a set template.
In the body of that template, I have the following:...
- 11
0
votes
0
answers
86
views
Set width of Cards to Full Screen using JSON view formatting without changing height
How can I set the width of the Cards (or Tiles) in SPO Modern views to full screen without having to increase the height?
I'd like to set the width to 1500px but the width is somehow tied to the ...
0
votes
1
answer
95
views
How to show a base64 image using JSON formatting?
I tried the following, but SharePoint seems to dislike the :
{
"elmType": "img",
"attributes": {
"src": "='data:image/png;base64,'+[$IconAsBase64]&...
0
votes
0
answers
37
views
How can we add site URL, item id and library to SharePoint list button using JSON?
How can we add site URL, item id and library to SharePoint list button using JSON?
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",...
0
votes
1
answer
92
views
Possible to use custom formatter in tile view?
I have a library that uses Document Sets and there are columns on the document set content type.
I want to display them in a view that uses the Tile format like this:
I use the JSON column formatting ...
- 999
0
votes
1
answer
104
views
JSON - line height in SharePoint Tiles/Gallery view
I have created a SharePoint Online list and added some JSON to the Tiles/Gallery view.
One of the columns is a "multiple lines of text" type of column. The column is displaying text fine in ...
- 45
0
votes
1
answer
106
views
Use JSON to create a 2 levels group by in a gallery view
I'm trying to create a 2 level group by in a SharePoint gallery view.
The following code is only displaying one level. In my case, I want to group by Entity and them by Title.
{
"$schema":...
- 185
1
vote
1
answer
56
views
How date can be dependent on status changing
I developed a travel plan list on SharePoint. In the plan, for travel, there are 3 drop-down stages:
Planned
Completed
Cancelled
But the issue is anyone can select the "Completed" status ...
- 27
0
votes
1
answer
36
views
JSON help needed - changing the height affects width
I am using JSON to format the Gallery (Tiles) view of my SharePoint Online list. For some reason, changing the height of a tile affects width too. How do I change the height only?
This is how the ...
- 45
0
votes
1
answer
274
views
Display multiline column in the Gallery view
In my SPO List there is a multiline column (Multiple lines of text). The column is not visible in the Gallery view. Is there anything I can do about this? Some JSON maybe?
- 45