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.
346 questions
0
votes
1
answer
47
views
How do I create a working button that updates dynamically depending on the values of two columns in my SharePoint document library?
I need help with creating a JSON structure for formatting a custom "single line of text" column in my SharePoint document library. The column, called "Start Document Workflow," ...
0
votes
0
answers
21
views
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 ...
0
votes
0
answers
145
views
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, ...
0
votes
0
answers
171
views
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.
...
0
votes
0
answers
408
views
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 ...
0
votes
0
answers
36
views
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 ...
1
vote
1
answer
77
views
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 ...
0
votes
1
answer
356
views
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 &...
0
votes
1
answer
40
views
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....
0
votes
1
answer
417
views
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 ...
1
vote
1
answer
164
views
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 ...
1
vote
0
answers
80
views
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 ...
0
votes
1
answer
250
views
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 ...
0
votes
1
answer
107
views
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 ...
0
votes
1
answer
328
views
JSON code for Change Text to Red when value is $1000 or greater
I am new to JSON and am looking for some assistance. I created a SharePoint list with a calculated column set to automatically add selected cells to yield the total. My goal is to have the cell turn ...