Skip to main content

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
0 votes
2 answers
21 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 ...
0 votes
1 answer
12 views

I cannot hide the "New" button in SharePoint list using JSON

I have tried using the following JSON code to hide the "new" button from SharePoint list but it has no effect. It works on all other buttons except new. Can some please help? Here is the ...
0 votes
2 answers
1k views

Can i define a default value for a HyperLink site column to include the item ID

I have the following column of type Hyperlink and I want its default value to include a url with the Id of the item, I tried to define the format inside the JSON but it did not work, as follow: So ...
0 votes
1 answer
52 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. {"...
0 votes
1 answer
21 views

change colouur of background button in json formatting

I'm doing some filtering on 2 webparts. Below is the firet webpart that filters based on the letter A,B etc.. When click is it possible to set the background colour to a colour (For exampleto the ...
1 vote
3 answers
4k views

Showing an Image on SharePoint online list (New and Edit form)

I am new to SharePoint online, and I am having an issue with displaying an image when the user try to create a new item in the SharePoint list. This image is just a table with some information about ...
2 votes
2 answers
3k views

SharePoint format groupby over full width (group props headerformatter json)

I have a SharePoint Online list with a groupby in the status field. Now I want to change the whole background of the groupby so that the status row has a different color. I have already applied JSON ...
1 vote
2 answers
2k views

SharePoint modern view formatting with JSON: URL returns void

I'm trying to format a List in SharePoint modern view. When clicking on the the URL "Bekijk recept" I get a javascript:void(0); instead of opening the URL. Here you can see some of the code:...
1 vote
1 answer
4k 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 ...
1 vote
1 answer
3k 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 ...
0 votes
1 answer
35 views

SharePoint Online Make only 3 columns appear per row using configure layout

SharePoint online, is it possible to make only 3 columns appear per row using configure layout? I'm using SharePoint online modern experience and want to display only 3 columns per row only using ...
1 vote
2 answers
5k views

JSON Row Formatting Display Icon based on column value

I am working on some custom JSON using the "rowFormatter" view formatting schema. I want to display an Icon depending on the value in another Column. My conditional statement is not working. ...
0 votes
2 answers
2k views

Making a yes/no column show an icon rather than text

I'd like to have a Yes/No column that rather than showing the usual text ("Yes"/"No"), shows an icon - say green or red. I know I can create another column (a calculated one) with a formula that ...
1 vote
1 answer
4k views

JSON to display SharePoint list choice column fields as visual checkbox, centered

I tried to use the out-of-box SharePoint "checkbox" field in a SharePoint list, however, it does not visually display as a checkbox either in classic or modern view. It was also cumbersome ...
2 votes
1 answer
5k views

How can I display a "View Comments" link on a list item only when comments exist?

My SharePoint list has a column for comments. It used to display a link to "View Comments" for every list item, though, even if there were no comments. Not helpful, since a user would have ...
0 votes
2 answers
62 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 ...
1 vote
2 answers
2k views

How can I show Attachment Name and preview in SharePoint List

SharePoint List view: I want to see a preview of the Attachment file in the list and the name of the attachment. Please share if you have any ideas about this or reference.
0 votes
2 answers
4k views

How to convert text to URL in multi line text column

I have a flow that populates a multi line text column in SharePoint. I want the fields to be clickable as they are links. I didn't format the column to be a hyperlink b/c some links are over the 255 ...
0 votes
2 answers
1k views

Format date and time with Json Formatting

I'm new to JSON Formatter and I need to format a list in gallery view. I have a date and time field, and I am using the expression "=toLocaleTimeString([$Date])", but the time is being ...
0 votes
2 answers
32 views

SharePoint - show Yes/No column from a lookup table

I have a list A which has columns ItemCode (text type) and Enabled (Yes/No type). In list B I created a lookup column to list A. I am able to show in list B ItemCode from list A however I don't seem ...
0 votes
1 answer
31 views

JSON formatting of list header part - two rows of text

I have the below json code added to the header section of a item list editing window. The code adds two links, one next to each other. I'd like the second link to appear either in a new row (i.e. ...
1 vote
4 answers
5k views

Wrap text on title and hyperlink columns

I'm trying to import a list from Sharepoint On-Premise to Sharepoint Online. In the old list, the text was wrapped for both the title and the hyperlink column which gave the list an organized and ...
2 votes
2 answers
2k views

JSON formatting column based upon added column of lookup column

I have two SharePoint lists. List one has the following columns: Productgroup (text) Min (number, percentage) Max (number, percentage) List two has columns: a lookup column for Productgroup Added ...
1 vote
1 answer
1k views

Separate a string in @currentfield by empty space

I'm currently using SharePoint column formatting JSON to turn a field's string entry into a URL using the following: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/...
0 votes
1 answer
23 views

Column formatting by elapsed time

I need to format a column in SharePoint Online with this features: If the value in the "Ordine" column is "ASSENTE" and it has been more than 5 minutes since the record was created,...
1 vote
1 answer
21 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 ...
1 vote
1 answer
2k views

SharePoint Online - JSON formatted Lookup Column - Values not visible when click to edit

Issue Description: I use JSON to format a lookup column in a SharePoint Online list. I click 'Edit in Grid View'. The column value and formatting are appropriately displayed in grid view. UNTIL I try ...
1 vote
1 answer
3k views

color formatting a date column

I'm very new at list formatting. I've created a new list and are trying to get the columns to turn red/green/yellow depending on the date that you put in to the date-column. I want the column to turn: ...
0 votes
1 answer
1k 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 ...
2 votes
3 answers
4k views

JSON - how to highlight duplicated items in a specific column?

I have a microsoft lists where the ID for each episode is a number. I want to format th ID Column so that each time a new item is added, if the ID column is duplicated from an existing ID it appears ...
2 votes
1 answer
2k views

What does the colon operator do in SharePoint column formatting JSON?

If you use the Fill background color template for formatting a date column on a modern SharePoint list/library, and you switch to Advanced mode to view the JSON, it makes extensive use of a colon (:) ...
0 votes
0 answers
13 views

Duplicated Headings in SharePoint List Forms

Recently, while immersed in the task of formatting the form body within the Site Pages library, my objective was to introduce structured headings to categorize the various fields. Leveraging JSON, the ...
0 votes
2 answers
28 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?
2 votes
1 answer
4k views

Vertical Alignment in List column

I have an InfoPath form that a user fills out and in one field they type an email address. The information is collected in a list. All of the columns but Email automatically aligns the standard way. ...
0 votes
1 answer
2k views

Column Formatting - HideSelection disable JSON Formatting

After one week waiting for a Solution from Microsoft, I need to ask. In About 5 SharePoint Online Tenants the JSON Formatting in Sharepoint lists stopped working. I Debugged the Scenario and find, ...
1 vote
3 answers
4k views

SharePoint column formatting with json for date fields

I am trying to set custom formatting for date field and followed the guide here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-conditional-...
2 votes
2 answers
2k views

Combine Column Wrap Text, Color and Column Width - JSON Code

I have the wrap code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "style":{ "white-space":"wrap" }, "txtContent": "...
0 votes
1 answer
35 views

Show/Hide Column Display name using a Condition using JSON Not PowerApps

I want to remove the title "Please upload the personal image if needed", if the Visa Support is "Yes", and show it if the Visa Support is "No". I want to make it using ...
0 votes
1 answer
2k views

Conditional Formatting based on choice selection from another column

I'm new to SharePoint List Conditional Formatting I've got two columns one is [$Status], and the other is Due Date. If the status is resolved it will be green, if the status is open and the due ...
0 votes
0 answers
27 views

JSON Code based on date and priority

I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends. In my priority column I have the following options: ...
2 votes
1 answer
8k views

Change the width of a card in Gallery view of a List

I've been been thinking of migrating our existing FAQ from a wiki to a List in SharePoint Online. Changing the view to a Gallery looks promising: But is there a simple way to make the cards wider?
1 vote
1 answer
2k views

Formatting hyperlink type field with file directory path

By default, a hyperlink type field in a SharePoint Online list looks like a regular field. It's not until you hover over the text that you actually see that it's a hyperlink. I am trying to edit/...
0 votes
1 answer
1k views

Masking a text field with JSON

I have searched for examples of JSON scripts to format a column output in a view and can't find anything for text field manipulation. In Excel I would use this formula: =concatenate("XXXXXXXXXX&...
0 votes
1 answer
71 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' ...
1 vote
3 answers
2k views

Sharepoint JSON not saving

I am just adding some JSON code to my columns to change the text color. All columns work as expected, but one ("Doc. #", a completely vanilla single line text column) keeps removing the code ...
0 votes
1 answer
45 views

SharePoint column show/hide condition - Multiple conditions with OR

I have a Choice column that I want to display if either of two conditions are true. It's an Approver Response column that I want to hide if "Approver Notified" checkbox = false, and Status = ...
0 votes
1 answer
77 views

Hide "Favorite/Unfavorite" button in ribbon via list view format CommandBarProps

Need to hide majority of button in library ribbon - using "Format View" option and JSON editor work for every button.. except "Favorite" and "Unfavorite". Syntax ...
0 votes
2 answers
2k 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
1 answer
25 views

SharePoint default form json - How to set a section name to = the display name of a user from a people-picker

I am building a SharePoint default form for creating a new doc set in a SharePoint online Library. This form has 3 Approver fields (people pickers). When they go into the submitted form to provide ...
0 votes
2 answers
8k views

tooltip column on hover a column in SharePoint List Using JSON- Modern List View

I need to show the description of column as a tooltip when a user hover a mouse on a column, I am doing this based on Adding custom hover text using json to a SharePoint list column But I need to ...

1
2 3 4 5
15