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.

Filter by
Sorted by
Tagged with
1 vote
1 answer
10 views

SharePoint JSON formatting empty date field with no color

I am using a conditional format for the cells but I want that the empty cells keeps the default color, but with my conditional format the cells with no information are in red color. { "$schema&...
1 vote
1 answer
7 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
0 votes
1 answer
24 views

When executing a flow from a button in a list column, how do you hide the button when more than one item is selected?

I have a flow whose trigger is the SharePoint trigger named: For a selected file The default behavior of this trigger is that when a file is selected, the flow is available under the Automate menu. By ...
0 votes
1 answer
23 views

Lists: group headers 100% width

When formatting the group headers in a SharePoint list I found no way to span them dynamically over the full width of the list. The DIV container is as long as it's content or bound to a fixed width ...
  • 149
0 votes
1 answer
16 views

How to dynamically hide/show a DIV area in a custom row formatter

I have a custom row formatter to display Q&A information in a list. I'd like for the display to show on Row 1 the Q, and Row 2 the A. But - I want the initial view to not display any of the "...
0 votes
1 answer
18 views

JSON Formatting a List Column - Two colors for two situations

I have a Modern SharePoint list with a Review Date column. I'm trying to configure JSON so that if the entry has Today's Date, it will highlight Red. If it is between today and 15 days from now, it ...
  • 197
0 votes
1 answer
22 views

JSON to format SharePoint List items under a Header

I have formatted a list to look like the one below. I would like to wrap them in a DIV so i can have a header above them named "Useful Tools" or something. I can't seem to get a header above ...
1 vote
1 answer
24 views

SharePoint list column @rowindex in descending order

I created a new SharePoint list from an excel file. in the excel file I had ID column which held a sequential number added automatically. I don't want this column to be entered manually so I used the ...
0 votes
2 answers
24 views

Formatting a date column with various factors

This should be simple and I hope it is. I'm trying to get a date column to format in the following way: If the date is GREATER than 2 weeks leading up to the date, its green Is the date is LESS than 2 ...
0 votes
1 answer
16 views

SharePoint Modern List - Change fill color of column headers

I have a Modern SP list, and the client wants the column headers to be highlighted in yellow, or have a fill color of yellow. Does anyone know of the JSON I could use to accomplish this?
  • 197
1 vote
2 answers
16 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
1 answer
11 views

Is it possible to change the background colour of the title of a column in a list with JSON?

I am trying to finalize a list and I want to change the color of my column titles. I am not an admin in my company and i cant implement CSS easily. Does someone know if its possible with JSON to ...
  • 11
0 votes
2 answers
15 views

Does a projected field value need to be visible to be used in JSON formatting?

I have a list with a lookup field that references another list called Area. The other list has a field called CssClass that I've projected into the main list in order to use it for custom JSON ...
0 votes
0 answers
23 views

Align text with JSON in the middle of a column in Sharepoint online

Hey i am trying to set text vertically in the middle of a column in Sharepoint online. I found some solutions and i tryed all so far but none of them works. I wonder if the coding or naming of JSON-...
  • 11
2 votes
1 answer
83 views

Filter lookup column value using JSON

I have a custom list where in the Title column we have 1 to 100 numbers. This Title column we are using in the Lookup column in another list. Now while using the lookup column list, all the 1 to 100 ...
1 vote
1 answer
21 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 ...
0 votes
1 answer
23 views

Dynamic URL generated by JSON column formatting breaks on ampersand character

I am using JSON column formatting to generate a dynamic URL based on the value in another column. The dynamic URL is a link to a document library which is filtered by the value in the other column. { ...
1 vote
1 answer
20 views

Separate multi-value lookup column values as hyperlinks to respective documents in SharePoint Library with JSON formatting

I am trying to create a document library with multiple values in a lookup field function as hyperlinks to the respective documents. By default the lookup column navigates to a details page, this is ...
  • 13
1 vote
1 answer
27 views

Calculated Column JSON link to document

I want to create a link to a document library that is automatically created by a flow. The flow creates a file in a SharePoint document library with the following string "[Field1]-[Field2"]-'...
  • 11
1 vote
1 answer
9 views

SharePoint Online Json formatting. Highlight 1 column if several others are filled in

I am trying to include a column to basically serve as a checklist for several other columns. The column 'Can we launch' is supposed to fill as green when all referred to columns are filled in. If one ...
1 vote
1 answer
23 views

Adding a link to a SharePoint list item in an email

I'm new to the forum and joined because despite my best efforts at searching I can't find an answer so hoping someone can help me out. I have a SharePoint list with a Person column. This column is ...
  • 11
1 vote
1 answer
11 views

Comparing 3 dates (from separate columns) and populating a 4th column with the oldest

Using SharePoint Online, I'm working in a list that has 3 dates - for my example date1, date2 and date3. In a 4th column I want the oldest date to show. Here is my column formatting, but all that is ...
  • 13
0 votes
1 answer
21 views

Formatting the image picker panel with JSON view formatting

I'm using the organizational assets option to provide users a central repo of approved images to use on their sites. For pages we offer a banner image and optimized thumbnail and on smaller screens, ...
  • 569
0 votes
2 answers
32 views

List formatting, column not loaded

Question: How can I enforce to load a column with data without it being seen as a separate column? Problem: I have two columns, title and summary. Now I would like to display only title in list view ...
  • 165
3 votes
1 answer
57 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
2 votes
1 answer
16 views

Where can one find the FULL list of allowable values for directionalHint?

All I can find in the documentation is the standard four options. "topCenter", "bottomCenter", "leftCenter", and "rightCenter". But in one example (custom-hover-...
1 vote
1 answer
35 views

SharePoint Online Json formatting with date based check

I am trying to get something to work on SharePoint Online with JSON column formatting. What i have currently been able to achieve was, if a column is filled in ==> fill green if empty fill orange. ...
1 vote
2 answers
68 views

SharePoint JSON: Formatting List View with Empty Column and Date Value

I'm totally new to JSON formatting and need your help. The SP list requires the following: List formatting to show colors (green, yellow, red) if the Request Completed Date is empty as well as if the ...
1 vote
1 answer
69 views

JSON Format HTML text from single line of text column

In SPO list we have a single line of text, where values are sent as anchor tag e.g <a href="https://SPSITE.sharepoint.com/sites/inspection/Shared Documents/Plant & Equipment/MAINTENANCE/...
  • 1,041
1 vote
2 answers
28 views

Using MS's column formatting JSON to change the color of a cell based on the first 2 characters

I'm trying to use the JSON conditional formatting based on the first 2 characters of a field value, and have not had much luck with it. Any help will be greatly appreciated, here is a variation of ...
1 vote
1 answer
14 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
0 votes
1 answer
36 views

Show hide columns based on the logged in user using JSON formaating

I have a custom SharePoint Group, there are many members in that group. And a group of certain columns in my list that only should be shown to these custom SharePoint Group members. I am thinking of a ...
0 votes
1 answer
70 views

JSON to make a SharePoint list column accept a phone number and/or an e-mail address and format each appropriately

I am new to JSON. I am trying to set up a "preferred contact info" column in a SharePoint list. I would like the field to accept a phone number, an e-mail address, or both. When an e-mail ...
0 votes
1 answer
96 views

JSON list view formatting - syntax for children elements

Trying to replicate the layout of the news.aspx page - main div for row (linked to item), a child div to contain and size up the thumbnail, child divs for thumb, title, description, author etc. The ...
  • 569
0 votes
2 answers
54 views

Using JSON to hide or show row depending on a row value

Can anyone explain this? I wrote this JSON back in June. It's to show birthdays for the current month. I have a simple list with a date field. To hide rows that are not in current month, I am ...
0 votes
1 answer
58 views

Conditionally show hide column is not working in SharePoint Online Grid view

I am conditionally showing and hiding the "Approver Name" column based on the "IsApprovalNeeded" column which is working fine in the form but while we try in grid view it always ...
0 votes
2 answers
51 views

SharePoint Online list row formatting with the LookUp column string start with condition using JSON

I have a project list with the color status as Blue-PRJ1, Blue-PRJ2, Blue-PRJ3, Green-PRJ1, Green-PRJ2, Green-PRJ3, etc. The color status column is the LookUp type column. When the user selects the ...
1 vote
0 answers
91 views

JSON View Formatting - Count total number of items in SP list

I want to modify the groups footer of a custom view that is grouped by a metadata column named Response/Actionv2. In the Totals section of the view settings I enabled Count for this column, which now ...
0 votes
1 answer
45 views

SharePoint List - sort column by a conditional format

I have a conditionally formatted (JSON) date column that changes color to green if it is completed on time. Is there a way to select/sort on just the green dates? or is this something that only Excel ...
  • 35
0 votes
0 answers
79 views

Getting email address of a user who filled columns of SharePoint list

I have a SharePoint list with 100 users and they are invited to do the following: The first column has the users's name. The users have to find their name and answer the questions on column 2,3 and 4. ...
  • 43
0 votes
1 answer
23 views

Color Code SharePoint 2013 Column based on Date Column

I followed this post on this site about color coding a SharePoint Column based on a date column. This worked really well and I got the result I wanted. I followed the answer from @chris-g. Below is my ...
  • 43
1 vote
1 answer
67 views

JSON IF Blank IF Not Blank

I am trying to update SharePoint List Form in SharePoint Online so that when a Single Line text field is blank the Header will display a specific message and color but if there is any data in the ...
  • 23
0 votes
1 answer
29 views

How to write JSON for double tier grouping?

I'm trying to format the way my grouping appears in Sharepoint Online (remove column heading in two-layer grouping). It currently displays this way: I have the following JSON: { "$schema":...
  • 31
3 votes
2 answers
193 views

Compare 2 dates and conditionally format

I am trying to compare 2 dates and conditionally format one of the columns based on the result. I have a 'Due' and 'Date Completed'. So I am trying to format the 'Date Completed' green if on or before ...
  • 35
1 vote
0 answers
55 views

Sharepoint list formatting- contact card image, name and title with hover for more text information (about the person)

I am trying to format a list view by tailoring samples from github. I am trying to create a user profile card where you hover over the card and information about the person is shown like a short bio ...
  • 11
0 votes
1 answer
30 views

SharePoint online column update

I have a SP list, one of the columns contains different numbers. I need to replace these numbers with text. For instance, if column color contains: 1 -> replace it with the text white 2 -> ...
  • 31
3 votes
1 answer
264 views

SharePoint online column formatting JSON - replace @currentfield

I'm currently using SharePoint column formatting JSON to turn a field's string entry into a text, based on it's value. For instance: whenever @currentfield is equal to number 10, it should replace ...
  • 31
2 votes
1 answer
73 views

SharePoint Online Lists - Conditional Formatting to hide columns in form - not working

Trying to use nested conditional formatting to hide columns depending on other values, which was working in the local List that I built but won't work online and running around in circles trying to ...
  • 21
0 votes
0 answers
30 views

List View Formatting(json) - Conditional Message when there are no items on the list/view

I am using List View Formatting. Is it possible to show a custom message "e.g Sorry no items on this list" when there are no item records? Instead of this default message that says something ...
  • 4,122
1 vote
1 answer
17 views

Conditional formatting with JSON with time in a date colunm

I'm trying to do a conditional format on a SP column that gets its entries from PowerApps, but formatting the regular way only gives me the option to format by date, and not by time. I'm new to JSON ...
  • 11

1
2 3 4 5
10