Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [view-formatting]

View formatting is sued to customise how views in SharePoint lists and libraries are displayed.

Filter by
Sorted by
Tagged with
0 votes
1 answer
12 views

Formatting library row based on dates, but ignoring blanks

I'm trying to use the in-built tools to format a row in SharePoint online. It is simple, I want it to highlight the row red when the due date is in the past AND another column value has been set. I ...
user avatar
0 votes
1 answer
12 views

List: remove line delimiter

Is it possible to remove the light greyish delimiters in a SharePoint List? I already set margin to 0 but nothing happened.
user avatar
  • 129
0 votes
1 answer
34 views

SharePoint list in Gallery view does not respect item limit setting

I have one quick question for which I am not able to find a solution now. It seems to me, when any SharePoint online list or Microsoft List in Gallery view is used, cards does not respect configured ...
user avatar
  • 1,614
1 vote
1 answer
73 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 ...
user avatar
0 votes
1 answer
49 views

How to get photo of user json formatting view

I'm trying to get a photo to show on my view. Tried the below but it won't work: "attributes": { "src": "='https://aaa.sharepoint.com/sites/XXX/_layouts/15/...
user avatar
  • 4,090
2 votes
1 answer
92 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' && ...
user avatar
0 votes
1 answer
251 views

How to fill blank SharePoint List Lookup field with default value using json

The following is part of JSON formatting in a SP List that turns rows red if field LookupFieldX is empty: { "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting....
user avatar
1 vote
1 answer
214 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. ...
user avatar
1 vote
1 answer
170 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 ...
user avatar
  • 25
0 votes
2 answers
306 views

Row formatting based on a LOOKUP column value in modern SharePoint List

Modern experience SharePoint List A has a LookUpColumn that retrieves values from NumberColumn in ListB. I need conditional formatting that applies a color across an entire row based on a value in the ...
user avatar
1 vote
2 answers
177 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 ...
user avatar
1 vote
1 answer
26 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 ...
user avatar
1 vote
1 answer
50 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 ...
user avatar
  • 13
2 votes
2 answers
272 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 ...
user avatar
2 votes
1 answer
314 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. { ...
user avatar
0 votes
1 answer
382 views

Show Description on Title Hover in Gallery view

I have a custom list with Title and Description. I wish to display the list view as a gallery with only the Title in it. On hover over the title, it should display the description field covering the ...
user avatar
  • 881
2 votes
1 answer
1k 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 ...
user avatar
  • 23
0 votes
2 answers
474 views

Columns are missing in the gallery's Card Designer

I'm using the gallery view in a Microsoft 365 SharePoint list. I'd like to add a few more fields (i.e., columns defined in the SP List) to the display, but not all the fields (column names) are ...
user avatar
  • 1
0 votes
1 answer
403 views

Lists 365 JSON - group header based on condition

Similar to the example here: Example: Color coded group header with aggregate I am trying the group header text in the list view to show the number of tasks that are NOT 'Completed' in the 'Status' ...
user avatar
2 votes
1 answer
803 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 ...
user avatar
1 vote
1 answer
613 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. ...
user avatar
  • 11
0 votes
1 answer
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?
user avatar
  • 49
0 votes
1 answer
1k 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. ...
user avatar
  • 2,319
0 votes
2 answers
100 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.
user avatar
1 vote
1 answer
1k 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 ...
user avatar
  • 11
1 vote
2 answers
1k 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. ...
user avatar
2 votes
1 answer
3k 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?
user avatar
0 votes
1 answer
333 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 ...
user avatar
  • 129
0 votes
1 answer
108 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 ...
user avatar
  • 129
1 vote
1 answer
291 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, ...
user avatar
0 votes
1 answer
142 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 ...
user avatar
  • 63
2 votes
1 answer
394 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-...
user avatar
  • 103
0 votes
1 answer
139 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 ...
user avatar
1 vote
1 answer
285 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:...
user avatar
  • 103
1 vote
1 answer
341 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 ...
user avatar
  • 103
0 votes
1 answer
686 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 ...
user avatar
  • 323
0 votes
1 answer
308 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 ...
user avatar
  • 323
2 votes
1 answer
583 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-...
user avatar
0 votes
1 answer
231 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 ...
user avatar
  • 1,453
0 votes
2 answers
53 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 ...
user avatar
  • 1
1 vote
2 answers
583 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:...
user avatar
  • 11
0 votes
1 answer
1k 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/...
user avatar
  • 219
0 votes
1 answer
383 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 ...
user avatar
  • 323
3 votes
3 answers
707 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 ...
user avatar
  • 31
0 votes
1 answer
228 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 ...
user avatar
  • 31
0 votes
2 answers
703 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": "[$...
user avatar
0 votes
1 answer
505 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. &...
user avatar
1 vote
1 answer
123 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 ...
user avatar
  • 323
0 votes
1 answer
384 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 ...
user avatar
1 vote
1 answer
806 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 ...
user avatar
  • 143