Questions tagged [view-formatting]
View formatting is sued to customise how views in SharePoint lists and libraries are displayed.
109
questions
3
votes
1
answer
5k
views
SharePoint Online list - format group headers to remove column name
I have a SharePoint Online list that contains employee documents for each of our staff members.
I keep it grouped by employee name which is great, but the word 'Employee:' before each name is really ...
- 33
3
votes
1
answer
3k
views
(SP List) How to wrap a text in the format view?
What I'm trying to do is achieve making my own header and hiding the original header so that the users can't change the setting.
To accomplish this, I found that I can change the "Format View&...
- 43
3
votes
1
answer
1k
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-...
- 43
3
votes
3
answers
1k
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 ...
- 31
2
votes
1
answer
2k
views
Format view using @group.fieldData on a lookup column
I'm trying to do some formatting of my document library. I'm specifically trying to format when I've grouped by a column, this column is a lookup column to another list.
This is the code I'm using.
{
...
- 21
2
votes
1
answer
2k
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 ...
- 214
2
votes
1
answer
6k
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?
- 133
2
votes
1
answer
937
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-...
- 103
2
votes
1
answer
2k
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 = '...
- 1,021
2
votes
1
answer
597
views
SharePoint Online View Formatting: Multiple If Statements Problem
I am really struggling with the following if statement inside a group header in SharePoint Online JSON View Formatter:
"txtContent": "=if(@group.fieldData.displayValue == 'A' && ...
- 21
2
votes
1
answer
9k
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 ...
- 8,877
2
votes
1
answer
169
views
Display video description with JSON formatted gallery view
I store videos inside a SharePoint document library:
Now I want to display the videos in a custom tile view using JSON formatting, but the "Description" column available in the list view is ...
- 23
2
votes
2
answers
2k
views
Modern lists - Row hover style
I'm customizing a modern list using the default styling and conditional formatting tools but now that I have set row colors the hover styles of the rows are clashing.
I want to just remove the hover ...
2
votes
1
answer
3k
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 ...
- 21
2
votes
1
answer
4k
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,
"...
- 23
2
votes
1
answer
144
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 ...
- 53
1
vote
2
answers
2k
views
Custom view rowformatter - how to make a hyperlink look like a button
I have a list with a hyperlink field. I want to format the link to look like a button. I have tried a gazillion websites, gotten all kinds of CSS, but none of it seems to work.
I've tried two ...
- 39
1
vote
1
answer
302
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 ...
- 73
1
vote
1
answer
1k
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 ...
- 103
1
vote
2
answers
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 ...
- 355
1
vote
1
answer
245
views
Help with JSON code for SharePoint online document library
I have a document library that I want users to be able to add a photo to with a title and descriptions and others be able to hover over the pic in gallery view and see the description AND be able to &...
- 25
1
vote
2
answers
614
views
Conditional formatting of board card background color
I am using a Board view to manage team tasks. One of the fields is the AssignedTo field which is a choice field with peoples' first names. I want to color the background color of the cards based on ...
- 25
1
vote
1
answer
57
views
Repeat a span element 20 times in SharePoint view
I'm heavily customizing view of a SharePoint list using JSON formatting, a gantt-like timeline, a roadmap. I would like to split the timeline with 20 vertical lines over it. Currently I have done it ...
- 23
1
vote
1
answer
23
views
Format View with AdditionalRows in Modern List
I set up column color coding based on the Due Date, but I want to extend that to the entire row.
If the due date is within 30 days, the color is red.
If the due date is within 60 days, the color is ...
- 11
1
vote
1
answer
459
views
Hide or Deactivate the setting "Format Current View" and "Edit Current View" in a list
I'd like to make sure that only the list owner (or if it is not possible otherwise the SharePoint Owner) is able to see the settings "Format Current View" and "Edit Current View" ...
- 13
1
vote
1
answer
45
views
Highlight rows where Month column is equal to today's month
I have a choice column (it can be a text column if that would work) called Month, with options for Jan to Dec.
I am trying to use column formatting to highlight rows where the chosen month is the same ...
- 27
1
vote
1
answer
381
views
Can JSON make a field appear conditionally in a view if it contains a value?
Please can you help me with a problem I have, using JSON to customize a view?
I'm creating a glossary, using Lists. The List contains all the metadata for a term – then I'm using the list web part to ...
- 13
1
vote
1
answer
911
views
SharePoint Online list - remove column name from grouped view
I'm trying to remove column names from the grouped list. I followed the instructions given here: SharePoint Online list - format group headers to remove column name but I seem to have another issue.
I ...
- 25
1
vote
1
answer
814
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:...
- 103
1
vote
2
answers
2k
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 ...
- 153
1
vote
1
answer
46
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
1
vote
1
answer
379
views
Is it possible to create buttons for hyperlink fields in a SharePoint modern customized list view?
I have created a list that contains document names, 4 choice fields to select and define what the document is, and 2 hyperlink fields to take the user to the document in either English or French.
So ...
- 23
1
vote
1
answer
89
views
How to append a column value to a group header
I have a list grouped by Name and I'd like to append their job title to the header. The Job Title column exists in the list and it is a lookup field.
So it would look like this:
John Smith - General ...
- 25
1
vote
2
answers
84
views
Is it possible in SharePoint Online to set list row colors only on the grouped header rows?
Is it possible in SharePoint Online to set list row colors only on the grouped header rows?
I'm hoping I can format the grouped list like this?
- 25
1
vote
1
answer
265
views
Used JSON to format list view: why is my tile view in web part rendering wider than in the list?
I am using JSON to format list view in SharePoint online list. Why is my tile view in web part on site pages rendering wider than in the default list page?
A related question: How can I change the ...
- 17
1
vote
1
answer
63
views
Can i know why the title and modified by not showing also the box shadow was also not working... sorry im new with this
Can I know why the title and modified by not showing? also the box shadow is not working?
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json&...
1
vote
1
answer
69
views
Don't generate Card in SharePoint Online List Gallery View (JSON)
I have got a SharePoint list that i would like to display in a SharePoint Site.
Different Users should only see the elements that are meant for them. This is determined by the columns Zielgruppen (...
- 11
1
vote
2
answers
459
views
JSON code for centering SharePoint list within List web part
I have formatted a Tile/Gallery view of a SharePoint list and would like to know if anyone knows how to actually center these tiles/list on the page within the web part?
This is my code:
{
"$...
1
vote
2
answers
523
views
Why can't I change the width in a Sharepoint list gallery view with Json?
I'm fairly new to using JSON and I'm trying to create a Gallery view to use with dynamic filtering. I have the view working the way I want, but I can't get the width and height of the 'card' to be ...
- 11
1
vote
1
answer
1k
views
SharePoint Online list - format group headers to remove column name when multiple columns are grouped
I have been searching the web to try and find an answer to this question however, all pages seem to relate to just 1 column grouping.
I have a list of people who are grouped together as gangs and then ...
1
vote
1
answer
2k
views
JSON Sharepoint Row Conditional Formatting
I have been attempting to format the colour of each row via the date in my $CONTRACTEXPIRES column.
I have the formatting set successfully to be red if the date has passed and green if it has not.
...
1
vote
1
answer
690
views
How do display image from an Image column in a custom row formatter
I have a list with an Image column and 3 descriptor fields. I want to create a custom display that has the image in section 1 and the 3 descriptors stacked in section 2. I can't figure out how to get ...
- 39
1
vote
1
answer
384
views
How to change a row colour based on cell entry in SP
I've looked at various sources, tried various solutions but nothing seems to work for me. I'm using SP, I don't know which version but it's a later one - it has the option to click back to 'Classic ...
- 13
1
vote
1
answer
1k
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. ...
- 11
1
vote
2
answers
5k
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. ...
1
vote
1
answer
718
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, ...
- 21
1
vote
2
answers
2k
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:...
- 11
1
vote
0
answers
3k
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/...
- 249
1
vote
1
answer
303
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 ...
- 355
1
vote
1
answer
608
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 ...