Questions tagged [column-formatting]

This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.

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

Does SharePoint 2019 support column formatting with customRowAction?

Testing column formatting on SharePoint 2019 and even a simple json containing customRowAction does not work. It works fine on SharePoint Online. { "$schema": "https://developer....
  • 35
2 votes
1 answer
111 views

How to create a progress bar that updates on status change

I'm looking to have a 'Status' column, that a user will change, for example: Not started Investigating Review Completed When the user drops down and selects a status, another column 'Progress' will ...
1 vote
1 answer
44 views

Using JSON to create an email, and uses other list fields in the body of the email

Currently starting with: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "children": [ ...
1 vote
1 answer
35 views

Color format calculated currency column in SharePoint List if formula

I am trying to format this calculated column to show if a number is more than or equal to format it green, or if it is less than or equal to 0 format it red?
  • 11
0 votes
1 answer
26 views

Trailing decimals in SharePoint Online list

I have a number column in SharePoint Online list and I'm limiting it to have 4 decimal places in the end. However when I export the spreadsheet I can see more decimal places. Is there a way to Limit ...
0 votes
0 answers
42 views

Sharepoint Column Format - How to handle blank dates with JSON Formatting

I am quite new to JSON Column formatting for Sharepoint. I have entered in the following code, however, I am not sure how to add in the blank condition. Basically all applications that are more than ...
0 votes
1 answer
141 views

How can I add a link to list attachments using Json formatting

Is it possible to have a link to attachments using json formatting? I want my users to be able to click a link to go the the attachment file from a view and not have to edit or click on the form to ...
  • 4,158
0 votes
1 answer
96 views

Can I use JSON column format to hide show power automate button?

Can I use JSON column format to hide show power automate button in a SharePoint list depending if the user is an admin or not. I don't want people with read only access to trigger the flow.
  • 4,158
0 votes
1 answer
17 views

Column Formatting - Background based on dates, how to stop empty fields being included?

I have a simple renewal list that has a date column this date column I would like to change color depending on these criteria. If the date is within the next 14 days - Yellow If the date matches ...
0 votes
0 answers
10 views

List: Set Link typed column href to neighbour's cell value

I have a SharePoint List with one column of type Link and one column of type single line text named "File_Link". The single line text column contains a link to a shared drive folder. eg. ...
0 votes
0 answers
45 views

SharePoint Online JSON List Formatting

So I have a column with the internal name of usersubmitter. When I use this column in my JSON it appears as [object Object]. However if I try and pull the .title value of this object nothing renders ...
1 vote
1 answer
41 views

Sharepoint Lists Date Conditional Formatting

I have a Microsoft List (SharePoint List) and have a date field. I want to have a conditional format of the color based on today, i.e. if the date is in the past, grey, if the date is between today ...
0 votes
1 answer
25 views

SharePoint Online List View JSON Formatting Not Carrying Over to New Views

As an offshoot of a comment from @theChrisKent Column Formatting Not Carrying Over, if as he stated, "Column formatting is applied regardless of what view it's used in...", is there a way (...
0 votes
1 answer
56 views

JSON formatting for SharePoint 2019 calculated columns Help

Can someone help me apply JSON formatting to this calculated column to display the icons again? ="<DIV align='center'><img src='/sites/test/images/"&IF([ProjectHealth]="...
1 vote
0 answers
16 views

Delete file extension Microsoft Sharepoint 2019

I need to process filenames and remove file extensions from them. MS Sharepoint 2019 on board. I've read docs about declarative syntax but no luck so far. My point is that I need to process each file ...
1 vote
1 answer
74 views

Sharepoint list to wrap rich text

I am looking to wrap the richtext column in sharepoint list. Customer is looking to see the column value in the same page without clicking on the popup window. Currently the following code displays in ...
  • 11
1 vote
1 answer
60 views

Adding default hover buttons on Custom Formated Column

I have applied custom formatting to the Name Column in the Documents library. I do this because I want to make sure some types of files open in preview mode. My code: "$schema": "https:/...
  • 11
0 votes
1 answer
39 views

JSON to resize picture based on another column value

I am using SharePoint Online and have a list I have two columns: Department (single line of text) Logo (URL formatted showing as a picture) I have formatted the Logo column as follows: {&...
1 vote
2 answers
134 views

Conditional Formatting Column using JSON

I'm trying to format a column to conditionally color based on expiration date of a license, similar to the question here: Conditional formatting based on date to expire I've tried to edit the JSON ...
1 vote
1 answer
210 views

Update person picker column with more than one person using JSON formatting

I want to set values ​​for person fields based on choice field selection, is this possible? I started with the code sample below: "customRowAction": { "action": "setValue&...
  • 25
0 votes
1 answer
32 views

How to prevent when a user enters his own choice in a Choice column it becames a bullet

I have a list with 3 columns that has the type Choice. When I add the choices for the column I check the checkbox Allow 'Fill-in' choices which allows the user to fill in other choices. But when a ...
1 vote
1 answer
75 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&...
0 votes
1 answer
41 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 ...
  • 235
0 votes
1 answer
20 views

Display only year from a date

I want to import in a SharePoint list a column containing the "year". So, I have in the import column just a number, like "2020". Then, I use the List to display is a custom React ...
  • 111
1 vote
1 answer
101 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
39 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 ...
1 vote
1 answer
87 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
1 answer
174 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
135 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
11 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
189 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
0 votes
2 answers
78 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
2 votes
1 answer
70 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
129 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
354 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 ...
0 votes
0 answers
9 views

Time restriction in sharepoint

I want to force user insert second when will add time otherwise show error message. I use this formula: [Time]=TEXT(Time/24,"hh:mm:ss") where Time is the name of column. But this does not ...
0 votes
0 answers
16 views

SharePoint O365 Classic Library - Color Code Cell with no CEWP/Script Editor

First, I know if I use the Modern experience in my library in SP O365 this would resolve my conditional formatting issue. However, if I can find a solution that does not require a CEWP/Script Editor, ...
  • 1
0 votes
0 answers
22 views

Sharepoint list/library links on Android

I have lists and libraries that have a column with custom column formatting to display as a link to a powerapp. This works fine in desktop browser. Clicking the link opens the app. However, on my ...
  • 73
0 votes
1 answer
197 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
3 votes
2 answers
491 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
276 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
3 votes
1 answer
545 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
1 vote
1 answer
57 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 vote
1 answer
174 views

Format hyperlink column

I have a SharePoint list with 3 hyperlink type columns like this: I want to format those columns to have something like this and open the link by clicking on the image: Does anyone know how to do ...
1 vote
2 answers
153 views

Column formatting throws 768 schema error (ootb)

I'm trying to change the column format for a column in Office 365. This is done through the view > dropdown menu > Column settings > Format this column > Advanced mode. No matter what ...
  • 5,377
0 votes
0 answers
42 views

Word wrap formatting Name column in document library

I want to word wrap the Name column. I am using the following code to wrap the column "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json"...
0 votes
1 answer
57 views

SharePoint CSOM List Allow Multiple Selections on a choice Column?

How can I set Allow multiple Selections to ON on a Choice column in SharePoint list using CSOM or Graph API? I can't seem to find a way to do it. Here's the setting that I need to turn on.
1 vote
2 answers
137 views

filter by color after adding conditional formatting

If you create conditional formatting on a column in SharePoint list that is dynamic, say for example all dates before today are red, today is green and dates after today are amber, is there a way to ...
0 votes
1 answer
242 views

Edit SharePoint List Column settings to add color style?

I am trying to create a Choice column in my SharePoint list. Using Graph API, this works great: https://docs.microsoft.com/en-us/graph/api/list-post-columns?view=graph-rest-1.0 However, it creates the ...
0 votes
1 answer
119 views

JSON Formatting - SharePoint List

I've created a SharePoint list and applied JSON formatting to the 'New List Item' form, setting the layout into sections which all looks great. I've created multiple list views but when editing the ...

1
2 3 4 5 6