Skip to main content

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
21 views

SharePoint Column Formatting with Hyperlink

I have a hyperlink column called "LinkUrl" and a text column called "CategoryTitle". I want to apply column formatting where I can Show the CategoryTitle as button and onClick, it ...
404's user avatar
  • 2,215
0 votes
1 answer
23 views

SharePoint Online JSON tile custom formatting - loop through available choices

I am creating a custom tile view for a SharePoint Online list. I have a choice field called Result. How can I loop through the available choices to display a button for each of them? I have found ...
Austin's user avatar
  • 1
1 vote
1 answer
36 views

SharePoint List column conditional formatting

New to this still on the learning road. Situation. I have a SharePoint list that contains the following columns: Name, DOB, Location, Comments. I need to use a conditional formatting rule that in the ...
Ciprian's user avatar
  • 13
0 votes
2 answers
72 views

Hyperlink column not working as button

I have SharePoint list which adds the item based on the flow, however the column hyperlink is not working as a button. But when initially created the list it was working but now it is not. {"...
striker92's user avatar
  • 115
0 votes
2 answers
74 views

SharePoint online library column JSON formatting based on other column value

I need to format a column named 'Action' with hyperlink as follows: If column name 'Status' is having value as "Accepted" or "Rejected" then 'Action' column should have hyperlink ...
Sanjay Adsure's user avatar
1 vote
1 answer
26 views

Checkbox - align center

On Yes/No Checkbox - JSON sample, there is a code allowing you to show checkbox (square) for a YES/NO column regardless of the current value of the field (by default checkbox only shows if YES is ...
Paksos's user avatar
  • 15
0 votes
2 answers
31 views

How to add condition to the SPO column with JSON

Can a condition be added to the multiple-line text column so that if it includes a semicolon, it sends a notification, changes the color, or something similar?
Harris's user avatar
  • 595
0 votes
0 answers
20 views

Sharepoint Lists - Column Formatting - List View v Calendar View

I am creating a list for my team. There are five members. I have created a Responsibility column - person type Working in the List View: For the Title Column, I have created a column formatting rule ...
tkc57's user avatar
  • 1
0 votes
0 answers
30 views

JSON Code is having no Effect on Column Formatting in a SharePoint Online List

In SharePoint Online, I have permissions as "Owner" (not ADMIN). I have created a list. The column types vary (of type URL, Text, Date, etc.). For the URL column, I added the following JSON ...
Angelina Gomes's user avatar
1 vote
1 answer
21 views

Microsoft Lists how change color if date is more than 6 months in the past

I'm trying to color a column item based on date value. I'd like to highlight date if it was > 6months in the past. Below is what I tried but doesn't work as text becomes completely hidden ...
Bialy778's user avatar
0 votes
0 answers
29 views

JSON progress bar always full in SharePoint

Is there any way to show a progress bar under a text formatted as Accountability in SharePoint online? The progress bar must put in relation 2 values: let's call the first Amount Financed and the ...
Christian's user avatar
1 vote
1 answer
18 views

If two columns show no date, "Status" column shows "Incomplete"

I am very new to JSON. I have a document library, and I am trying to have a "Status" column populated with "Acknowledged" if two columns show a date, or "Unacknowledged" ...
Whitney's user avatar
  • 13
0 votes
1 answer
31 views

Replace semicolon with comma in SharePoint text colomn

I am having an issue replacing the semicolon with a comma. I am using the JSON replaceall function to do this, and it looks like it does the job. However, you can still see the semicolon when you ...
Harris's user avatar
  • 595
1 vote
1 answer
15 views

How do I make a list date column turn mint green if the date entered is within the last 12 months and turn light red if it outside of 12 months?

I have a list made that tracks several employee training dates. We are currently entering the date they last tested/trained. Trainings are due every 12 months or every 36 months. How can I make the ...
George K.'s user avatar
0 votes
1 answer
87 views

JSON formatting - remove hyperlink in one view only

I have two views in a SharePoint Online document library. I want to strike-out and disable the hyperlink of column 'Name' if 'Retracted' column is true. I've carried this out using 'Format columns' ...
Orange Juice Jones's user avatar
1 vote
1 answer
40 views

JSON to wrap text after ";" from a lookup AND delete blank spaces

I have a column "Action Status" which is looking up multiple values in a separate Actions table. The first screen shot shows how the data appears without applying any JSON coding (I'm a ...
user111397's user avatar
0 votes
2 answers
209 views

Is it possible to use an if statement on choice type column in MS List conditional formatting?

Apologies this is my first question so I will summarize the issue as best as possible. On the list I have created below in the progress column I created a drop down option using choice type. I have 3 ...
Stevan's user avatar
  • 3
1 vote
1 answer
143 views

SharePoint List Formatting - Choice Field Overflow

I have a choice field in my SharePoint list. The choice field is basically a tag list. Now I wish to display the tags on a single line. Everything what doesn't fit in the box should just be hidden. ...
WG-'s user avatar
  • 177
1 vote
1 answer
202 views

SharePoint 2019 JSON AST column formatting

I would like to realize the following: If the date in a column is more than 40 days old, the background should turn orange. If the date is more than 80 days in the past, the background should turn red....
Bollo's user avatar
  • 13
1 vote
1 answer
166 views

JSON formatting for downloading documents but only viewing folders

I'm working on a SharePoint Library that has both documents and folders. I've added JSON formatting to show a "Download" button for all items. I need to change that to only download for ...
M Kanetomi's user avatar
1 vote
1 answer
21 views

SharePoint List lookup value not adding additional fields values

I have a main list 'Actions Types', where to each type of 'Action Type ID' is assigned a Person (using Person of Group field). Using a JSON code, I created a single text column (named 'Owner Email ...
Giuseppe Di Lernia's user avatar
1 vote
1 answer
91 views

Display image with choice column when multiple selections allowed

I have a list where we track an employees performance by awarding badges. I have a (multiple selection allowed) dropdown choice column containing the 4 Achievements. With each selection, I have badge ...
user110812's user avatar
0 votes
1 answer
308 views

SharePoint Online Library - Modify Choice column value without Edit in Grid View

I have a SharePoint Online Document Library where I need the users to be able to select a Choice field value (Approved, Rejected, etc.) without having to Edit in Grid View. I know it's possible with ...
Chris's user avatar
  • 409
0 votes
1 answer
165 views

Padding needed to top of SharePoint Online field

I' m currently using a SharePoint online modern list. I have managed to create a lookup column and also a value lookup column Problem is regarding the JSON formatting. How can I insert a padding value ...
Sparky's user avatar
  • 13
1 vote
1 answer
168 views

Issue in column formatting in SharePoint JSON with If statement

I have a simple JSON formatting code for a column in SharePoint in order to redirect to the appropriate target depending on the content of the record. Here is the code: { "$schema": "...
Brucks's user avatar
  • 13
0 votes
1 answer
15 views

execution flow button in a SPO library

I have created an SP document library with an execution flow button that extracts the zip files when the users click it. The extract file locations are the same as the zip file in the document library....
Harris's user avatar
  • 595
1 vote
1 answer
470 views

How to get lookup column value in single line of text

I Want to display lookup column values in single line of text. ProductName lookup column with multiple selection. I tried using JSON column formatting but values are not showing. Please can anyone ...
Lucky's user avatar
  • 13
0 votes
1 answer
479 views

Column Formatter using (File) Name field

Simple question so it seems, but I'm trying to set the Title value of a doc library base on the File Name in the column Formatter. Is this possible? The source below gets wiped out from the Title ...
Beruken's user avatar
  • 23
0 votes
0 answers
17 views

How to remove or re-wording prefilled text in the SharePoint column

Can someone please help me to see if I can remove or re-word the prefilled column text?
Harris's user avatar
  • 595
0 votes
1 answer
861 views

SharePoint List - Modifying center alignment always changes vertical alignment to top

I am trying to use JSON formatting to center align the values in a SharePoint List. Whenever I apply the JSON column formatting, it also aligns the values to the top. Even when I then specify that I ...
cNiCfR87fKn.'s user avatar
2 votes
2 answers
995 views

JSON code for SharePoint List conditional formatting - check for value in a single line text cell

I don't know any JSON at all, I work at an IT help desk and am trying to do a little advanced conditional formatting for our SharePoint list, which contains a user database of sorts. We're currently ...
user3081579's user avatar
1 vote
1 answer
345 views

SIMPLE Column formatting in SharePoint list (SP2019)

I have a pretty basic SharePoint list on a page at work and I simply want columns to be colored yellow (Is it "#ffff00" ?). In my "List Settings" I select the column I would like ...
James's user avatar
  • 11
0 votes
1 answer
209 views

SPO JSON - Copy Multiple People Field Emails as Text in New Text Field Commas Separated

Based on this great solution, I am looking for JSON column formatting to copy a multi-person field (people picker), displayed as email into a text field displayed as raw text email format comma ...
ChasEpes's user avatar
  • 113
0 votes
1 answer
351 views

JSON Formatting to show last item select from multi selection choice field

I'm trying to create a new field that displays the last item select from another Multi selection Choice field. We currently use a choice for Portfolio Years which show as a string of values selected. ...
Beruken's user avatar
  • 23
0 votes
1 answer
347 views

Specify the choices of the choice column in the JSON-code

I have a Choice column in my SharePoint list, with these column choices set: Niet verzonden Aangevraagd Goedgekeurd Afgekeurd What i am trying to accomplish is to create a button from that Choice ...
user1903995's user avatar
0 votes
1 answer
156 views

How to turn the column choices into a button?

What I would like is to create a button from the choice column. So the user can not select a choice by himself. But triggers a power automate flow by pressing on the button. So how can I turn a choice ...
user1903995's user avatar
0 votes
1 answer
70 views

JSON doesn't show the names of the choices in the choices column?

I have json code set for the choice column which is also a button. My code doesn't display the names of the choices! What do I do wrong: { "$schema": "https://developer.microsoft.com/...
user1903995's user avatar
1 vote
1 answer
237 views

Using JSON to list lookup values on separate lines

I currently have the JSON below and want to adapt it so that any multiple values are shown on a separate line, whereas at present each value is separated by ";" { "$schema": &...
Sparky's user avatar
  • 13
0 votes
1 answer
251 views

How can I only show the profile picture of a user (and not his name) in a sharepoint column?

How can I only show the profile picture of a user (and not his name) in a SharePoint column? I have set the column Person to only picture. but still get the name with it. I have found a JSON code ...
user1903995's user avatar
0 votes
1 answer
423 views

SharePoint Online - Generate an icon via Column Formatting?

I have a list in SPO with a Choice column (Video, Word, PDF). I would like to display an icon in a column called FileType. I have tried to customize the JSON of the FileType Column but it just shows ...
Pete Whelan's user avatar
2 votes
2 answers
2k views

SharePoint List JSON Conditional Format of Date Column When # days passed

I've went through a bunch of questions trying to find the answer to my questions, but a lot of recommendations don't quite fit into the code that I have. I'm using the formatting that SharePoint ...
RobMS's user avatar
  • 23
1 vote
1 answer
164 views

SharePoint JSON email attachment

Is there anyway to add an attachment to Outlook using mailto: in JSON? For example, I have a list that has an attachment. I have a email template that opens in one of the columns using JSON. I am ...
SN778's user avatar
  • 11
1 vote
1 answer
208 views

SharePoint JSON hyperlink text in email

I have a list that has a combination of numbers. In one of the columns for that list I am writing JSON code that pops up outlook with a set template. In the body of that template, I have the following:...
NS22's user avatar
  • 11
0 votes
1 answer
267 views

How to show a base64 image using JSON formatting?

I tried the following, but SharePoint seems to dislike the : { "elmType": "img", "attributes": { "src": "='data:image/png;base64,'+[$IconAsBase64]&...
Anderson Pimentel's user avatar
0 votes
0 answers
91 views

How can we add site URL, item id and library to SharePoint list button using JSON?

How can we add site URL, item id and library to SharePoint list button using JSON? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",...
user109428's user avatar
0 votes
1 answer
243 views

Possible to use custom formatter in tile view?

I have a library that uses Document Sets and there are columns on the document set content type. I want to display them in a view that uses the Tile format like this: I use the JSON column formatting ...
mannaggia's user avatar
  • 999
1 vote
1 answer
1k views

SharePoint List JSON formatting (make a text look like a Choice Pill)

Is it possible to make a number column appear like a Choice pill? Instead of the value being in a rectangle box, it would display with rounded corners. Instead of this: Get the numbers into ...
Damian's user avatar
  • 23
1 vote
1 answer
53 views

SharePoint formatting date column

I am having an issue when trying to format my date column on a list. I want the background color to turn red if the date is less than or equal to Today – 10 days, else its green. I cant see how to ...
João Santos's user avatar
0 votes
1 answer
353 views

Create multiple hyperlinks in text column of library

I am trying to create a column in a document library that contains multiple hyperlinks. Unfortunately it's not possible to have a rich text column in a Document library (unless I'm missing something?)....
Sylvie's user avatar
  • 185
2 votes
1 answer
676 views

JSON formatting of image

I'm having difficulties getting my list to display as intended. Can anyone help please? I have a list, and one column is a calculated field which points to a JPG file. These are A4, scanned at 300dpi. ...
Phil's user avatar
  • 21

1
2 3 4 5
7