SharePoint JSON Formatting

r/sharepointjson • u/wwcoop • Jan 09 '25

Priority Bubbles Template

2 Upvotes

Added colored priority bubbles to a choice field according to choice values 1,2 or 3. (Or set your own)

https://pastebin.com/raw/hxkKTyR5

https://sharepointdashboards.com/images/gallery/gal-12.webp

0 comments

r/sharepointjson • u/jiminak • Mar 31 '25

$FileLeafRef, $FileDirRef, $Name, and other "system columns" do not return any value.

3 Upvotes

(Cross posted from r/sharepoint by recommendation)

I'm trying my hand at some JSON column formatting for an SPO Document Library (modern). My main objective is to make PDF files open in Acrobat instead of the "sharepoint viewing experience" (or whatever it is called). I currently have this working by hyperlinking the "$Title" column, as long as my title is an exact match to the file name. BUT... when I try to use any of the suggested attributes to return the filename value, all I get is a "blank" (null, nothing is there).

So far I have tried $FileLeafRef, $FileDirRef, $ParentFolderLink, $Name. But none of these return any values.

Here is working JSON:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "attributes": {
    "href": "='../' + [$Title] + '.pdf'",
    "target": "_blank"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "color": "#0078d4",
        "text-decoration": "underline"
      },
      "txtContent": "[$Title]"
    }
  ]
}

This works perfectly for the href, as long as the "Title" column is a perfect match of the file name, since I can add the .pdf to the end. This obviously fails for any other file type, or if I fat finger the text over in the Title column.

If I swap in [$Name], or [$FileLeafRef], or any other attribute that should return something, the resulting URL is simply: https://redacted.sharepoint.com/SiteName/DocumentLibraryName/.pdf (simply nothing there).

I'm just a site owner, not part of our IT department. If there is something they need to do, I would need to know how to ask them.

10 comments

r/sharepointjson • u/wwcoop • Jan 26 '25

SharePoint JSON Training: Hyperlink Button

6 Upvotes

Learn how to code SharePoint JSON step by step. This module teaches you how to turn your hyperlink field into a clickable button:

https://sharepointdashboards.com/json/#hb

0 comments

r/sharepointjson • u/wwcoop • Mar 23 '25

Edit + View Buttons Combo

10 Upvotes

Template which adds both Edit and View buttons in one column as shown:

https://imgur.com/a/PPaIWe7

Create a calculated field called "Form" to use as a placeholder for the buttons. Format the column and paste in the provided code.

Code here:

https://pastebin.com/raw/QhDGa2Du

More free templates available at

https://sharepointdashboards.com

0 comments

r/sharepointjson • u/wwcoop • Jan 15 '25

SharePoint JSON Training: Inline Edit Field

1 Upvotes

Learn step by step how to code JSON. This module shows how to write code for an Inline Edit Field.

https://sharepointdashboards.com/json/#ie

0 comments

r/sharepointjson • u/wwcoop • Jan 24 '25

SharePoint JSON Training: Library Thumbnails

5 Upvotes

Learn how to code SharePoint JSON step by step. This module teaches you how to add thumbnail preview images for files in a library:

https://sharepointdashboards.com/json/#lt

0 comments

r/sharepointjson • u/[deleted] • Jan 15 '25

Time duration calculation

3 Upvotes

This is what I have attempted but it does not function as it should.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=floor((Number(@now)-Number([$DateHRNotified]))/10006060*24))" }

Any idea where I went wrong?

6 comments

r/sharepointjson • u/wwcoop • Jan 09 '25

Flow Button Template

5 Upvotes

Create a button which triggers a flow directly from the SharePoint list view. Insert your own Flow ID into the code.

https://pastebin.com/raw/cc8rSLD1

https://sharepointdashboards.com/images/gallery/gal-7.webp

1 comment

r/sharepointjson • u/wwcoop • Jan 22 '25

SharePoint JSON Training: Choice BG Colors

5 Upvotes

Learn how to code SharePoint JSON step by step. This module teaches you how to conditionally change the background color for a choice field:

https://sharepointdashboards.com/json/#cb

0 comments

r/sharepointjson • u/wwcoop • Jan 25 '25

SharePoint JSON Training: Star Rating

4 Upvotes

Learn how to code SharePoint JSON step by step. This module teaches you how to add an interactive five star rating to a choice field:

https://sharepointdashboards.com/json/#sr

0 comments

r/sharepointjson • u/mtank91086 • Jan 16 '25

Column formatting question

4 Upvotes

I have 2 columns; “Suspense Date” and a choice column - “Status”. Does anyone know how to make the “Status” column automatically switch to “OVERDUE” if the “Suspense Date” has passed?

3 comments

r/sharepointjson • u/wwcoop • Jan 21 '25