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
0 answers
8 views

Add value to a SharePoint Column using Json

I have a SharePoint Online list. I would like to format the column so when there is a value in a look up column the other "number" type column gets populated. Currently I am using { "...
user avatar
0 votes
2 answers
30 views

JSON Formatting: Triggering a flow from SharePoint list without a button

I would like to know if there is any chance with JSON to automatically trigger a flow from a SharePoint list without a button. Just when a new item is created. The solution with the buttons is as: { ...
user avatar
1 vote
1 answer
15 views

Multiselect Person column - concatenate multiple @currentFeild values for each record's txtContent

I have a multiselect person column, and need each record not just to display the users name, but also their job title in brackets, preferably deliniated by a new line. So far, I have the following ...
user avatar
  • 33
0 votes
1 answer
20 views

how to create a text in the footer with JSON in SharePoint Online

I need to know how I can create a string with the following appearance: "For further questions please contact IT@test.com". I want to format it with a JSON in the SharePoint Online. Here is ...
user avatar
0 votes
1 answer
12 views

Formatting library row based on dates, but ignoring blanks

I'm trying to use the in-built tools to format a row in SharePoint online. It is simple, I want it to highlight the row red when the due date is in the past AND another column value has been set. I ...
user avatar
0 votes
0 answers
20 views

How to render an unordered list without truncation?

In my sharepoint list, I want to have a column that displays an undordered list. I can do this with a richtext column, but SP truncates it. Long ago, I would do this, and it rendered the entire list ...
user avatar
  • 3,521
1 vote
1 answer
23 views

Cannot change the background color in SharePoint format View

I've working on a SharePoint list and I would like to change the background color of a row based on another column. First, I have use a column named "Entité" as value to change the color but ...
user avatar
1 vote
2 answers
19 views

Creating Column conditional formatting that are only visible in specific views

My department has a list that are used by many teams. For team's views I would like to format columns that will note affect the view of the other teams. It looks like by default, column conditional ...
user avatar
0 votes
0 answers
37 views

Adding an image to a folder using JSON formatting

I'm having an issue since I am a total beginner regarding JSON. On Microsoft Lists, you can customize the way it displays a spreadsheet under "Gallery View". You can find an enclosed picture ...
user avatar
0 votes
1 answer
20 views

list formatting: multiple mailto-links break code

When I use an a element in JSON to generate a mailto-link, everything works fine: { "elmType": "a", "style": { "position": "absolute", ...
user avatar
  • 129
0 votes
1 answer
29 views

List webpart: change background color

When I use a list as a webpart the background is plain white (see white behind honeycomb icons and the light blue background of the site panel). Is there a way to change the background of the whole ...
user avatar
  • 129
1 vote
1 answer
23 views

SharePoint List Advanced mode JSON Syntax for CC email to

I have a simple SharePoint list of email template to send an email to our customers. I have the basic JSON format that I got from here https://docs.microsoft.com/en-us/sharepoint/dev/declarative-...
user avatar
  • 11
0 votes
1 answer
24 views

Default ms-class for SVG element

I use this code to create a hexagonal shape in JSON for a SharePoint list. { "elmType": "svg", "style": { "fill": "currentColor", "cursor": "...
user avatar
  • 129
1 vote
2 answers
39 views

Trying to format column with another column

I have a "Completion Date" column and a "Current Step" Column in a list. I am trying to format this "Completion Date" Column so that when the "Current Step" is ...
user avatar
0 votes
1 answer
12 views

List: remove line delimiter

Is it possible to remove the light greyish delimiters in a SharePoint List? I already set margin to 0 but nothing happened.
user avatar
  • 129
0 votes
2 answers
41 views

Conditional formatting SharePoint list issue with JSON

I am trying to use JSON code on SharePoint list - works fine with 2 conditions(green,red) but I am not able to add additional condition, third with yellow...not sure how it should look. workable: { &...
user avatar
  • 1
0 votes
0 answers
39 views

How to format a managed metadata column based on the term?

I have a column with managed metadata from the local term store. I want to format each term in a different color, based on the value of the term. I am very novice so I started tried with the JSON ...
user avatar
  • 101
0 votes
0 answers
24 views

Adjust column width of hyperlink column type in SharePoint

I have a hyperlink column in SharePoint showing an icon, I want to reduce the width of this column using JSON but somehow my code: "width": "20px" is not working. Sharing the code ...
user avatar
1 vote
1 answer
38 views

Json formatting sharepoint list link inside gallery

I am trying to create a sharepoint list and customizing the json format of this list to make it look nice. I have decided to go with the gallery layout, would like to show a link to bring my users to ...
user avatar
  • 115
1 vote
1 answer
23 views

SharePoint online column formatting seems to affect Edit In Grid view

Even the most basic JSON column formatter seems to make the Edit in Grid view search results list box render blank. I've tried using @currentField.lookupValue as well as much more complicated ...
user avatar
1 vote
1 answer
19 views

Price Comparison in view formatting and highlight different price in different color

I am new to SharePoint. I have 4 different price columns ( different vendor price) for one item in a SharePoint list. I want to highlight the price in each field in a way that: 1st Highest price : ...
user avatar
  • 11
1 vote
1 answer
49 views

Using Sharepoint column format to show button for files only using JSON

I have added the following JSON code to sharepoint to show a button to request document approval, however I want to limit this to only show the button against files not folders using the Boolean ...
user avatar
  • 11
1 vote
1 answer
38 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/...
user avatar
  • 11
1 vote
1 answer
26 views

Sharepoint List - Configure Layout , want to change the Title color based on selection of choice type column "Category" . Sharing the code below

In Sharepoint online list - Configure Layout, I want to change the Title color based on selection of choice type column "Category". Sharing the current code below: { "elmType": ...
user avatar
2 votes
1 answer
34 views

For Sharepoint , In Configure Layout formatting ,the header does not take any other column field except title

This works and shows Title as an output: { "elmType": "div", "txtContent": "[$Title]" } Below doesn't work to show the Description column, type for ...
user avatar
0 votes
0 answers
66 views

Grouping with JSON SharePoint Online Gallery view

I want to group the following Gallery View after status, but I don't know how to and where I need to insert the "groupProps". Can you help me. Here is the JSON code. I tried to insert it at ...
user avatar
0 votes
1 answer
58 views

Conditional formatting if list item has attachment

I customized a list form via JSON to sort the entries for the user. Now I want to modify a text in the header based on if there's an attachment in that list item or not. I already included the ...
user avatar
  • 129
0 votes
0 answers
29 views

Change width of single column in edit form of list in SharePoint Online modern site

Given: SharePoint Online modern experience (--> no script editor) SharePoint list Site Owner permission Demand: Facing the edit form of an item in a list, I would like to change the width of a ...
user avatar
1 vote
1 answer
29 views

Json Gallery conditional formatting not working

I have a list with layout set to Gallery. The list has Title, URL and recently added a Display field. Currently clickable tiles are displayed and I now want these tiles to turn grey (disabled) when ...
user avatar
0 votes
0 answers
53 views

Column formatting with JSON not working properly

I'm new to sharepoint, so maybe I'm doing silly mistakes. I made a list with few fields, one was a numeric field, where I added a JSON string to change the background-color by changing class of the ...
user avatar
0 votes
1 answer
34 views

SharePoint list in Gallery view does not respect item limit setting

I have one quick question for which I am not able to find a solution now. It seems to me, when any SharePoint online list or Microsoft List in Gallery view is used, cards does not respect configured ...
user avatar
  • 1,614
1 vote
1 answer
64 views

SharePoint Online list - format group headers to remove column name when multiple columns are grouped

I have been searching the web to try and find an answer to this question however, all pages seem to relate to just 1 column grouping. I have a list of people who are grouped together as gangs and then ...
user avatar
1 vote
1 answer
156 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 ...
user avatar
1 vote
1 answer
82 views

JSON-code needed for a column in a SharePoint List

I have a SharePoint list. When a user inserts a new item in the list an dialog screen appears. On the dialog screen is a text box where the user can insert text and when the user clicks on the save-...
user avatar
0 votes
1 answer
83 views

Is SharePoint injecting a second command menu bar?

I've inherited the SPFx components of a SharePoint solution that has a custom command set that replaces the OOB command menu bar items.The OOB menu items are removed by looping over "ms-...
user avatar
1 vote
1 answer
227 views

Help with JSON formatting for email link in SharePoint list (displaying item details in message body)

I have a SharePoint online list and I want to include a column so users can click to send an email to follow up about a list item they're interested in, and would prefer not to use Power Automate if I ...
user avatar
  • 114
1 vote
1 answer
80 views

Format Hyperlink Column in SharePoint to highlight empty fields

I'm new to JSON column formatting and fairly sure this has been asked before or at least covered, but I'm trying to find a way to highlight empty fields in the SharePoint column (hyperlink) to display ...
user avatar
0 votes
1 answer
48 views

How to get photo of user json formatting view

I'm trying to get a photo to show on my view. Tried the below but it won't work: "attributes": { "src": "='https://aaa.sharepoint.com/sites/XXX/_layouts/15/...
user avatar
  • 4,080
1 vote
1 answer
21 views

Hi, I am new to JSON and I can't figure out how to integrate multiple strings. I need to hide columns and make the text of appearing items bold [closed]

So this is the code I'm hiding the columns with: And I need the rest of the items to appear in bold type.
user avatar
2 votes
1 answer
88 views

SharePoint Online View Formatting: Multiple If Statements Problem

I am really struggling with the following if statement inside a group header in SharePoint Online JSON View Formatter: "txtContent": "=if(@group.fieldData.displayValue == 'A' && ...
user avatar
1 vote
1 answer
41 views

Add mail button to list field when date is in future

Using SharePoint online in office 365. According to the Microsoft docs "Add an action button to a field" it is possible to render a Mail IconName including quickActions element to open email ...
user avatar
1 vote
0 answers
42 views

Is there any way to display the Events in Calendar based on the color set for Event Category without using Calendar Overlays?

I have a requirement where I need to show the events in Events list in Calendar View with the background color of the Category Selected. i.e., If Category is Meeting then event background should be ...
user avatar
0 votes
1 answer
41 views

Order of evaluation for || and && in column formatting (JSON)?

I'm having trouble finding an answer for how my JSON column formatting will be treated in SharePoint Online. Is there an order of operations/precedence based on the && (and) and || (or) ...
user avatar
  • 114
0 votes
1 answer
50 views

SharePoint Online - List view webpart

I have a category list and there is a view which shows category column only. I have about 30 categories listed here. How can I display all the categories say 6 across and in 5 rows. Does it make sense?...
user avatar
1 vote
0 answers
27 views

Show Text box to capture comment on button click in Modern SharePoint List View Formatting

I am building a card using View Formatting to allow user take the Approve or Reject Action. I am able to successfully update the status on button click using setAction attribute but, what I want is, ...
user avatar
0 votes
0 answers
93 views

How to display lookup values as plain text without making them invisible in the drop-down?

I have a few lookup columns in my list that, a few months ago, were working/displaying correctly. I don't believe anything has changed on my side, but I may be wrong... in any case, when I open up the ...
user avatar
  • 114
0 votes
1 answer
142 views

Conditional Formatting to change color 30 days prior to expiry date in column

I am trying to update conditional formatting of a column to change color to red, when expiration date in the column is 30 days prior to expiring.
user avatar
0 votes
0 answers
36 views

Format SharePoint Online List row based on multiple conditions in same field using json

From the code below, the [if(length([$Employee.lookupValue]) == 0, 'ms-bgColor-red'] portion changes a row to ms-bgColor-red if the field is empty. How do I extend this condition so that, in the same ...
user avatar
1 vote
1 answer
59 views

Sharepoint Online - Hide Column based on content type

so basically I have a library of nested folders and a column with a request approval button. I'd like to be able to hide the button for all folders and leave it visible for all files. I've tried a few ...
user avatar
  • 11
0 votes
1 answer
63 views

Using If-Then-Else structure to format rows based on a date column

Hoping someone can help. I have been working on this issue for a few days now (lots of googling and playing with the code formatting). What I'm trying to accomplish: I have a sharepoint site to track ...
user avatar

1
2 3 4 5
9