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
1
vote
1answer
4 views

Convert People Picker to New Text Column

I have a SharePoint online list where I have a People Picker field ("PeoplePickerColumn"). I want to create a new text column ("PeopleTextColumn") in the list that populates based ...
1
vote
1answer
10 views

Customise person column with JSON

Now the settings are made to be small: Is there some way to make the person card bigger on height and font size? I use Person or Group column.
1
vote
1answer
12 views

Bigger font size in hyperlink column in a list via JSON

I would like to make an alternative text in a hyperlink column bigger. In a title column, it works fine with this code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
1
vote
1answer
34 views

Trigger flow with icon instead of button?

I have a SharePoint list with a button that has conditional logic to trigger a flow. It works (conditions display or hide it as needed as well as adjusting color and label as needed), but it doesn't ...
0
votes
1answer
29 views

Applying JSON column formatting hides column list values

I'm just getting into column formatting. I'm trying to create the "Create clickable actions" example that was on Microsoft's site explaining Column Formatting in Modern SharePoint Sites ...
0
votes
1answer
19 views

How can I add conditional column formatting for Boolean expression in JSON?

I have a SharePoint Online list with a number of reference columns: they need to be included in the view so that I can reference them in the JSON conditions in other columns, but the users don't ...
0
votes
1answer
16 views

How to change the delimiter used when displaying multilevel terms in a Managed Metadata column?

The Managed Metadata column settings > Display format section looks like this: In the Document Library, multilevel terms are displayed like this (i.e. with a : delimiter): level_01_term:...
0
votes
1answer
25 views

How to separate Managed Metadata column values by a comma and display on one line?

By default, it seems when you select multiple Terms from a Managed Metadata column in a Document Library, SharePoint Online will display each Term on its own line, eg: Some_Tag_01 Some_Tag_02 ...
0
votes
1answer
44 views

JSON formatting to show field value that's hidden by default?

I have a number of "utility" columns in my SharePoint online list that are used by the JSON in other columns (for example, I need to check that the "Email1" column is populated ...
0
votes
1answer
25 views

SharePoint Doc Library - JSON changes color of text in hyperlink column

I have a hyperlink column which displays a light blue color, until I add some conditional formatting to indent child documents. My script is: { "$schema": "https://developer.microsoft....
1
vote
1answer
27 views

Change Field Text

I would like to change the text in a field based on the choice of the same field: When text Green choice selected, it will be displayed as a big Green dot, so goes to amber and red. Can it be done ...
1
vote
1answer
29 views

JSON column formatting “number” without decimal place and 1000 separator as “.”

I have a SharePoint list where a column contains numbers but those numbers are shown as: Example: "1,181,180" instead of "1181180" (this is what I need). I created the list ...
0
votes
2answers
16 views

How to create a tooltip for Column Title on hover in MS Lists?

I created MS List where I need to add a tooltip for "Prioritization" Column name when mouse over the Column Name. Tooltip text to be displayed: "Ranking: C- Critical, H - High, M - ...
0
votes
2answers
58 views

SharePoint Modern Library - Conditionally Indenting Rows

I have a very tough situation here. Let's start with a screen shot: So as you can see, some of the entries have several dashes (which the client had done manually) to give the appearance of indented ...
0
votes
2answers
23 views

Leading Zeros to organise project folders within columns

Hi I am a complete newbie and I want to organise the Projects by JobPac numbers which start with leading Zeros - 0001, 0002 is there some way I can do this? Or would it be best to ask the JobPac team ...
0
votes
2answers
36 views

SharePoint Modern Column Header cuts off

I have a Modern SharePoint document library that includes a column header that is slightly too long, and cuts off: This "Date Last Declared" column is a Date and Time column. I'm able to ...
1
vote
1answer
22 views

Create a hyperlink based on a field entry

I am trying to format a column and create a custom hyperlink in a column field based on a specific criteria. I have three options for this field and I only want to create a link if the field is one ...
0
votes
1answer
24 views

Power Automate - Set Column value to equal value of another Column in same list

I have a modern list with about 5,000 entries. My client has added two columns since creating all this data, and I need to set one column to equal the value of the other (doing this manually will ...
0
votes
1answer
33 views

SharePoint Modern List - Increase column width with JSON Issue

I am trying to increase the width of a column in a modern SP list. Here is an image prior to adding JSON: As you can see, the width of the "Description" column needs to increase in order ...
0
votes
1answer
53 views

SharePoint 2019 On Prem - Modern experience - Conditional Formatting not working

Environment: SharePoint 2019 On Premise Requirement: If a Number column value is equal to 0 then set sp-field-severity--good else set sp-field-severity--warning Trial: Based on the article at Use ...
0
votes
1answer
20 views

Can we preserve the colour code when exporting a list into excel sheet

I have a custom list where I applied a color coding for some fields as follow inside modern UI: But if I export the list as excel, the color code for the fields will be lost. As follow: So is there ...
2
votes
1answer
27 views

Conditional visibility of the button in the List

I have configured button in my list, that triggers particular flow. However I would like the button to be visible only if there is value filled in particular column (e.g. column "Name"). ...
0
votes
1answer
38 views

SharePoint Online - formatting column headers

I have created a modern list in SPO with JSON conditional formatting on the row and view levels. One conditional formatting snippet I've added hides the cell text (row level) based on the current user....
1
vote
1answer
38 views

How to create a calendar form with multiple column formatting?

I am a beginner of SharePoint. I want to create a calendar form to use it as a team members out of office info, a meeting request to a manager, etc. The form includes; Name, Title, Start/End Time and ...
0
votes
2answers
62 views

SharePoint 2016 Classic Experience Column Formatting

I have a custom list which displays numerical variance as a percentage. I would like to color code the numerical value based on it's value. i.e. 10% displays in red. I am using SharePoint 2016 on-...
3
votes
2answers
121 views

Conditional formatting of a field on a sharepoint list by month of a date

As you can see in the picture, I have a date type field and I would like this field only to be displayed in orange when the month of the date is equal to the month of the current date but I don't not ...
2
votes
2answers
127 views

How to display past list items related to a column value?

I have the following SharePoint list in which the "Participant" columns are text values (names of people) and each item in this list is a training event. "Evenement" is the type of ...
1
vote
1answer
24 views

How do I apply more than one conditional formatting rule using JSON to a SP Online List column?

I have two calculated columns Variance and Variance %, they both have conditional formatting (via the SP Design Space) to turn the background green when they are less then $10K and 10% respectively. I ...
0
votes
1answer
23 views

How to display thumbnails from multiple attachment(s) using JSON conditions, in a list

With SharePoint Online, I may have a list item that may have up to 4 attachments. Is there anyway I can setup a conditional expressional in my list (perhaps with JSON conditional logic), that checks ...
1
vote
1answer
49 views

CONDITIONAL FORMATTING - Unable to format column

I have a SharePoint LIST that's being used to manage events. There are 6 participants for each event and each Participant has a column: "Participant 1", "Participant 2", "...
0
votes
1answer
26 views

Rounding edges for images in a SharePoint List

I have a SharePoint list with a column populated with pictures, however I would like to round the edges of said pictures. I tried the solution I found in this blog post, but it's not working for me. ...
0
votes
2answers
28 views

How to create column formatting with custom hyperlinks for multi-value lookup column with an additional field

I have two SharePoint lists: List 1 - has item details List 2 - has shipping details As one item can be shipped to different locations, List 1 has one to many relationship with List 2. List 2 has ...
1
vote
2answers
34 views

News Item Thumbnail in JSON

I am trying to create a JSON view in Site Pages that displays News Items in a nice way. Is there a way to display the thumbnail image in it? What is the name of that property/column? Thanks for any ...
3
votes
1answer
48 views

How to hide column if no choices are selected

From SharePoint Online, I have a multi-choice column. If the user does not pick any of the choices, how can I set a conditional formula to hide the column. I tried the following, but it does not work ...
0
votes
1answer
99 views

Complex Nested If Statement when using Format columns in SharePoint online

I am trying to format a column with a complex nested if statement but the column is ignoring the first if statement and only seeing the second. I have been trying to tweak this, but I can't get it to ...
0
votes
1answer
28 views

SharePoint List: squared image thumbnail

In my SPO list I can display images contained in the data set. Now depending on the image size (by setting the width to a fixed value) the height differes depending on the image. Can I display a ...
0
votes
1answer
50 views

Column Formatting with Approval Status

I got this problem: I have a button which should only be visible when the Approval Status is not "Genehmigt". This is the JSON I got right now: { "$schema": "https://...
1
vote
1answer
23 views

JSON column HyperText where @currentField needs to be in the Middle of the URL

I am trying to use Microsoft's Sharepoint List Dev document to do a "Turn field values into hyperlinks (basic). My code looks like this: { "$schema": "https://developer....
2
votes
1answer
116 views

Using json to modify lots of different columns in a SharePoint list

So I have this SharePoint list, and currently I have 3 columns, each using JSON to change the color depending on the data entered. for example, say that "Yes" is entered into the column1, it ...
0
votes
2answers
41 views

Is it possible to put JSON-code in metadata-columns?

I am using 2 metadata-columns in my SharePoint-List: "Created By" and "Change By". In these columns a name appear of the person who has created or changed the List-item. I would ...
0
votes
1answer
67 views

JSON-code doesn't show my picture in my list

I have added JSON-code to my list column "Person" which displays the persons name and profile picture. But it doesn't show my profile picture. What do i do wrong? { "$schema": &...
1
vote
1answer
17 views

How i can change the color of a single line of text if a People or Group column is empty or has a value

I have the following list view :- now i am trying to change the color of the Breaks field to be Red in-case the Engineer field has value, while make it Green if the engineer field is empty.. can ...
0
votes
1answer
115 views

Using Json to check if a column contains certain text

So I have this sharepoint list with a (for example) "Date" column, and I want to check if any of the rows contain certain text. For example, in the rows it will either say "The due date ...
0
votes
1answer
103 views

json column formatting, button that starts flow - can I prevent multiple clicks?

I have a button that starts Approval flow, with 'visibility' attribute that hides it if 'Status' column has value. But users make double-click and open Flow panel twice or more times, so my flow runs ...
1
vote
1answer
89 views

Extract description rather than URL in calculated column to use it with another url

Let's say the first column is UID having number 12345. You will be directed to the URL after you click on 12345. The second column I am trying to create is like a URL to some website followed by 12345....
0
votes
1answer
186 views

SharePoint multiline column json formatting adding a line break

I have a sharePoint multiline column in a library and added data with a # deliminator. I want to render the data so that where there is a # a line break occurs. So it provide a list and not wrap the ...
0
votes
1answer
77 views

Is there any way using column formatting if i can show it as a hyperlink

Hi I have a cascading lookup column in sharepoint modern view. That column is redering as html.I am new to column formatting and when i use this code it converts the whole html into link. What i want ...
1
vote
2answers
45 views

Manually Highlight a SharPoint List Cell

I'm wondering if there is a way to manually highlight a SharePoint list cell, without needing to use conditional formatting. The reason for this is that there isn't a strict rule in order to highlight ...
1
vote
1answer
88 views

Display units in a Number Column while retaining Thousands Seperator

I'm trying to adjust the way that a SharePoint Number Column displays its value so that it can include a specific unit of measurement. I want people to enter into the field only a Number, but for the ...
2
votes
1answer
91 views

List - Conditional formatting of a “cell” based on another cell in the same row

I have two columns: "LFR sign" and "Filing". I would like to: If the "LFR sign" is not empty -> "Filing " becomes red if it's empty I am sure this is quite ...