Questions tagged [json]
JavaScript Object Notation, is an open standard format that uses human-readable text to transmit data objects consisting of attribute–value pairs. It is used primarily to transmit data between a server and web application, as an alternative to XML.
349 questions
0votes
0answers
10views
How to derive actual values from a JSON-column formatted text field in SP List - as they display as NULL when extracted into Tableau?
I have an SP List that has a multi-select Lookup Column that is a selection of DB tables (Asset Name). I need to display the SP List in Tableau including Asset Name however it is displaying as a ...
0votes
0answers
58views
Sharepoint List not opening Edit form after New
I have a Sharepoint list that has two linked Power Apps forms - one for New and one for Edit. Everything seems to be working fine, aprt from: If I double click on a record or click and choose Edit, ...
0votes
0answers
61views
Amending drop down box options using JSON in SharePoint list
Sorry I'm a complete beginner to using JSON. I have two drop down boxes within a SharePoint list and I wish to amend the choices on the second drop down box based on the selection made from the first. ...
0votes
0answers
156views
Create a Gantt chart for Project List in Modern SharePoint using JSON code
Any Help will be greatly Appreciated! I have a SharePoint list [Project List], and I have created a Gantt chart with JSON code below. Gantt View: But I need a Gantt chart view that takes tasks for ...
0votes
0answers
17views
I am trying to reduce the size of gallery tiles
I am trying to reduce the size of the gallery tiles in sharepoint document list of which contains an image column bit when i change the dimensions. The image doesnt change size of the image so i can ...
1vote
1answer
57views
List view formatting in combination with column formatting
I have 2 lists with each 5 columns (see the picture). In the top list, I have created my own view using view formatting in JSON. In the bottom list, I have applied column formatting in JSON on the ...
0votes
1answer
105views
Adding custom hover text using json to a MS List column
I found the below code on this website and it is just what I've been looking for for some time. The problem I'm having with code is that if I change the name of the column to something other than &...
0votes
1answer
25views
JSON for SharePoint to ignore blank date
I need to format a SharePoint Date column to be red if it is late and ignore blanks because it is coloring the blanks red. This is my current code. { "$schema": "https://developer....
0votes
1answer
259views
Automated export of a SharePoint list, with multi selected choices columns
I have a SharePoint list that contains 8 text columns and 4 multi selected choice columns. and I want to automate a daily export via power automate. find my flow down below. The problem is I don't ...
- 3
1vote
1answer
123views
SharePoint Library Choice Column - Modify without Grid View - JSON Formatting
I have a SharePoint Library with a choice column ("yes" and no" values) in which I want the user to be able to modify without entering Grid View. The idea is for the user to create a ...
- 497
1vote
0answers
74views
JSON Formatting In Views
My gallery views that are JSON formatted are all of a sudden not displaying correctly, although nothing has changed and the views have not been edited. I can create a new Gallery view, but the JSON is ...
0votes
1answer
130views
Sharepoint JSON if else conditional on txtContent
I am trying to display different text in a multiline text field depending on the value in a separate single line text field. I can get the if statement to work with one condition but if I try to nest ...
0votes
0answers
307views
Gantt Formatting in Sharepoint list
Topic that often does the rounds, in relation to a Gantt style view in modern Sharepoint. TLDR: assistance required in amending position of bars within and them linking/ displaying correctly to dates ...
0votes
1answer
55views
Display List GUID and List Name In SharePoint Online Column in View
I'm trying to display the list name and the list GUID in the default view of a SharePoint Online list. Is this possible? I haven't found a calculated column method or JSON formatting method but I ...
0votes
0answers
80views
Need help adding JSON code to existing code (Sharepoint List in gallery view)
Ok, very new to JSON and coding Sharepoint Lists. I found a great tutorial on how to generate a list and 'transform' it into a beautiful gallery card view . link in case above didn't work: https://www....
- 1
