Questions tagged [column-formatting]
This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.
272
questions
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....
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?
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 ...
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.
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 ...
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:/...
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&...
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 ...
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 ...
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 ...
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"]-'...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...