Questions tagged [view-formatting]
View formatting is sued to customise how views in SharePoint lists and libraries are displayed.
53
questions
2
votes
1answer
90 views
How to add an image to a column based on the value of another column (and have it show correctly in Gallery view)?
Desired Behavior:
Display an image in the column My Image based on the value in the column Model.
My Image is type Picture (I also tried making it type Image but got the same outcome).
Model is type ...
1
vote
1answer
34 views
How do I format Tile View JSON so that it doesn't break apart a word in the middle of the word for multi line column
I have created a tile view that has a few columns from a SharePoint list. I have everything formatted perfectly, except it randomly breaks apart lines in the middle of a word.
Say teacher it would be. ...
0
votes
1answer
24 views
How to color new list record like outlook do? [closed]
Is there any possibility to color new record on SharePoint list like outlook new emails?
0
votes
1answer
82 views
Format List View: JSON background colours 'ms-bgColor2' property - very few colours available
I'm attempting to change the colour of the bg-Color property. By standard on my list the colour is set to white. I'd like to change it to a different colour, but there are very few available to me. ...
0
votes
2answers
41 views
Any way to have document read time in SP library Tile View JSON Format
Is there any way to estimate the document read time in SP Document library Tile view using JSON formatting.
Any help would be appreciated.
1
vote
1answer
200 views
SharePoint format groupby over full width (group props headerformatter json)
I have a SharePoint Online list with a groupby in the status field. Now I want to change the whole background of the groupby so that the status row has a different color.
I have already applied JSON ...
1
vote
2answers
84 views
JSON Row Formatting Display Icon based on column value
I am working on some custom JSON using the "rowFormatter" view formatting schema. I want to display an Icon depending on the value in another Column.
My conditional statement is not working. ...
2
votes
1answer
483 views
Change the width of a card in Gallery view of a List
I've been been thinking of migrating our existing FAQ from a wiki to a List in SharePoint Online. Changing the view to a Gallery looks promising:
But is there a simple way to make the cards wider?
0
votes
1answer
57 views
Doc lib view formatting: accessing filetype icons
I am trying to get the file icons displayed in the standard view in the document libraries:
I want them to be displayed on a custom "file card" alongside the filename and a preview.
The SE ...
0
votes
1answer
22 views
IF-condition on a Yes/No column value
I have a SharePoint list where I'm creating a custom galley view. The list contains a yes/no column (named isOwner) which defines if a listed team member is owner or not.
In the JSON for the galley ...
1
vote
1answer
69 views
JSON formatted list view does not display a calculated column value
I am using JSON view formatting to display list items in tiles. I use a calculated column to display a date in the "23 March 2021" format and output it as a single line of text.
However, ...
0
votes
1answer
76 views
SharePoint online custom list formatting - only Transform or writing-mode css ignored
Trying to style the list in the matrix mode where the column headers needs to be hidden and want to display custom headers. On the headers I am applying the style with writing-mode: vertical-rl and ...
2
votes
1answer
134 views
Using Json to format a row in a sharepoint list
So I am new to using JSON and need a little help. So I have these two Json codes
"additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now - 86400000, 'ms-...
0
votes
1answer
34 views
How to change the color of odd and even rows of a list
When creating a list you get the option to make the odd rows blank and the even rows grey.
It generates a JSON-code (I think). How can I change the color from the even rows from grey to blue.
This is ...
1
vote
1answer
79 views
Changing the Color of a Row in a SharePoint List (using JSON) based on a columns value
So I have a SharePoint list with a column called modified. I used the following code to change the rows colors based on when it was last modified which works fine:
{
"$schema": "https:...
1
vote
1answer
85 views
Using JSON to change the color of a row based on the date it was Modified
I want to insert some JSON into my SharePoint list.
Basically I have a Modified column that shows me when a value in a row has last been modified. I would like to have a row turn red if it has been ...
0
votes
1answer
315 views
Dynamic filtering with Gallery list view in SharePoint Online
I have found a way to implement a substitute for a tab control in SharePoint Online. In SharePoint On Premise I used Hillbilly Tabs, but I am not allowed to use SPFx at our tenant so I had to look for ...
0
votes
1answer
97 views
Customize search results returned by Highlighted content webpart
I am showing a "feed" from a number of lists with a particular content type with a highlighted content web part on a modern page. The latest items from the lists are shown. To show the items ...
2
votes
1answer
252 views
JSON SharePoint list view - background-image doest not work
I found in documentation that "background-image" is supported attribute but I am not able to use it. Maybe I am doing something wrong. Could you help please, how to use "background-...
0
votes
1answer
147 views
Formatting list row based on score column Office365
I have created formatted the list as a gallery. using two columns such as created by and score.
I was wondering if there are any way to do change the background color based on the score achieved. For ...
0
votes
2answers
28 views
SP view formatting row display
Is there any solution to hide specific row in the list using JSON for view formatting.
I want to display only rows that match the terms of the current user and hide others.
In Column formatting I can ...
1
vote
2answers
161 views
SharePoint modern view formatting with JSON: URL returns void
I'm trying to format a List in SharePoint modern view.
When clicking on the the URL "Bekijk recept" I get a javascript:void(0); instead of opening the URL.
Here you can see some of the code:...
0
votes
1answer
463 views
Change column name in view using json view formatting
I have a view in SharePoint online where I need to override column name with a custom value.
Is it possible to do this using JSON View Formatting?
Ref:
https://docs.microsoft.com/en-us/sharepoint/dev/...
0
votes
1answer
204 views
Json not displying FAQ list properly
I just found out I cannot use "Newsletter style" for my FAQ lists in a modern site. If I use that the entire site will switch between classic and modern style. So I am trying some list ...
0
votes
0answers
33 views
JSON code to change Default view into Newsletter view
I have created a very basic FAQ using a custom list. I want to use the ‘newsletter’ style but when doing this the search box disappears and it appears only in default view.
As a workaround I found out ...
0
votes
0answers
53 views
Broken images when using json view formatter
https://github.com/pnp/sp-dev-list-formatting/blob/master/view-samples/contact-card-format/contact-card-format.json
I am using a code from above link, I have changed all $Picture to make list value, ...
3
votes
3answers
391 views
Is it possible to add JSON code to hide and show other rows based on column value?
I am using view formatting with JSON and wondering if its possible to add
button that can sort, hide and show other rows based on their column value, like only show items in toys department store and ...
0
votes
1answer
98 views
anyone else got this problem while using JSON view format? List items not showing after the 30th row?
I tried it several times with chrome whenever am at the 30th the row in the list it stops showing the rest of the rows.
When I inspect element browser it loads the rest of the rows or when I move the ...
0
votes
2answers
290 views
JSON view formatting [$Editor] en [$Modified] not visible
I'm formatting the view of an entire list using JSON.
Using the following code, the date modified and editor are not visible.
{"elmType": "span","txtContent": "[$...
0
votes
1answer
226 views
JSON view formatting edit item panel
I want to format a view using JSON but stil keep the possibility to click on the title and get the information panel to edit the item. Using the following code, I cannot longer click on the title.
&...
1
vote
1answer
74 views
Lookup image conditionally in SharePoint list formatting
I have a column named LinkType that will tell if the item is a Bug, Requirement, Feature, etc and based on the value I would like to display different pictures. Previously I was using a similar setup ...
0
votes
1answer
145 views
Hyperlinks in JSON not always working
I'm trying to format a SharePoint Online list using JSON. I have Title, ReportURL and Report Short Description columns. I want click on the title to go to the URL in the ReportURL column.
Using the ...
1
vote
1answer
469 views
Access information in hidden columns with JSON formatting
I am trying to format a document library in our SharePoint Online platform.
The goal is to have a row with a video thumbnail, title and short description. The title is not the same as the video file ...
1
vote
1answer
142 views
Problem with JSON formatting when using a location column
I want to create a view using JSON formatting. In this view I want to use a location column called "Adres" (I checked the URL and the field name really is called "Adres").
The ...
1
vote
1answer
306 views
Promoted Links list using View Formatting JSON stopped working today
Using a Promoted Links list with View Formatting to display as tiles has stopped working today in one of our client's Microsoft 365 tenants. I've been able to reproduce the issue in my developer ...
1
vote
1answer
306 views
Need Help with “Format View” feature in Modern List based on Condition
I am trying to color code a Row based on a condition in a Modern List (SPO). It goes something like this:
In English:
If ApprovalStatus = 'Pending' AND 'RequestDate' < [Today]-5
Then Row Color = '...
0
votes
2answers
626 views
Sharepoint online list view formatting DefaultHoverView using forEach
I am using Sharepoint list JSON view-formatting and want a list of names to each show their live persona card on hover. I can get this to work for just one name, but when I use forEach I cannot get ...
1
vote
1answer
1k views
How to make Tile clickable using JSON
I have the following JSON on my SharePoint (added via Format View for Tiles):
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"hideSelection": true,
"...
1
vote
2answers
435 views
Formatting JSON view in SharePoint how to group?
Can I check, I have two columns: category and questions.
I want to group all the questions that are related to the category as a group. Can I know how?
Category A Questions 1, 2 3
Category B ...
1
vote
0answers
156 views
How to control arrangement of view formatted list items?
I have a sharepoint list that uses view formatting. The height of each item depends on the content within it, they are arranged with 4 in each row when the browser is maximised. The columns display ...
1
vote
2answers
2k views
List/view formatting on grouped view on modern SharePoint page
I am working on migrating a page from classic page to a modern page. Today I am displaying several summary links web parts as tabs (Hillbilly tabs) on a classic page. In each summary link tab I am ...
1
vote
1answer
364 views
Modern list view formatting: build a url to display a user's profile picture
In a list I used column formatting to display a user's profile picture by building a url to the image like this:
"elmType": "img",
"attributes": {
"src": "='/_layouts/15/userphoto.aspx?...
0
votes
1answer
39 views
SharePoint List View Formatting
I want to check the date column in my list along with a flag to format list view:
I tried using AND and nested both don't seem to work:
{
"schema": "https://developer.microsoft.com/json-schemas/sp/...
0
votes
1answer
496 views
Edit link is not working in Json Formatting of view
I have created view using JSON formatting like in below image. The Give feedback button is given editProps as custom row action. This button works in list view, it opens the edit panel for the ...
0
votes
1answer
168 views
List layout with json not works as expected
I tried using below json code to make list like tile.
It works as expected when open it in the list however, the layout changed when use this list as web part in page.
Figure 1 : Open in list
...
1
vote
1answer
52 views
JSON Specification for Column/View formatting?
I am new to column and view formatting but see the power for my users. However, despite the wealth of examples between Microsoft docs and GitHub and the schema itself, I'm looking for descriptions of ...
0
votes
1answer
1k views
View formatting on Document Library in Sharepoint Online
I'm looking to format the Site pages view using JSON Formatting. Is there a way to get the Published date field and also the page URL?
I see there is no column formatting on Name field on a library, ...
0
votes
1answer
149 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
2answers
239 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 ...
2
votes
1answer
3k 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 ...
