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.

Filter by
Sorted by
Tagged with
1
vote
0answers
26 views

Writing numbers comma separated in JSON

Following a tutorial: SharePoint modern view formatting with JSON I realized that formatting a column with numeric or currency values are shown like strings. In this case I have the "Price" column ...
0
votes
1answer
14 views

Manage and Edit JSON in Power Automate

I'm using Get_Flow action in order to get the flow definition, it seems that the format of this definition is JSON My desire is to customise this JSON and change what it must change, and then create ...
2
votes
2answers
39 views

Set column height equal to height of record in List

I have a SP list where one of the columns is multi-line I have therefore set the style of this specific column as "height":"auto" which works perfectly for this column. I then have other formatted ...
0
votes
0answers
19 views

Sharepoint online - Guided tours, feature tour, walk throughs

TLDR; Is there a way to create in-app walkthroughs/ guides tours/ feature tours using open source packages like intro.js, chardin.js, joyride, bootstrap, HopScotch, Crumble with Modern SharePoint ...
1
vote
2answers
22 views

SharePoint workflow “now” function

I am trying to create a workflow that will automatically update a field based on creation date +3 days;3-5 days; 5> days. How can I tell the flow to calculate if 3; 3-5; 5> days have passed since ...
0
votes
0answers
61 views

SharePoint Online multiline with append - JSON formatting

In SharePoint Online I have a multiple lines of text column that has append checked. Instead of showing "View Entries" in multiple-line text column with append-only checked, will show all entries or ...
0
votes
2answers
33 views

Retrieve fields, fields type, fields values and column names of a Sharepoint Content Type used in a library using Javascript

I created a library that contains documents in Sharepoint Online. Let's call it myLib. I also created a content type, myCT. My objective is to retrieve informations concerning fields I created in a ...
0
votes
2answers
66 views

Formatting issue for View

UPDATE::: Sorry everyone I have been clearer. This is supposed to be for the "format my view" feature in the Sharepoint Online custom list. I'm trying to make the entire row change color based on ...
0
votes
0answers
19 views

How to parse JSON to return null as default if complex object empty/null/undefined?

Using HTTP Request to get SP item, having trouble parsing JSON to return anything for null object. Can return null for an empty string column as shown below, how to do so for a more complex object ...
0
votes
2answers
40 views

Column Formatting

I am trying to implement column formatting on a column that can have a value from (1-17) Pseudocode =IF(value<=4,"Low", IF(value=5,"Low-Medium", IF(value=6,"Low-Medium", IF(value=7,"Low-Medium", ...
0
votes
0answers
12 views

Strikethrough based on another column

I have a list called Resources that include name and status (Active, Inactive) as well as other information. In another list called Allocations it has a lookup column to the Resources list looking up ...
0
votes
1answer
357 views

SharePoint JSON tileProps breaks formatting

I am attempting to troubleshoot a formatting issue with JSON and actually found a Microsoft example that has the same problem for me. I developed a list using the same column names as the code below: ...
1
vote
2answers
91 views

SharePoint Column Formatting: Referencing External Columns in Mail To Body

Hello Stack Exchange Community, I have a question regarding referencing external columns. In my code below, external columns are referenced using square brackets as specified in Microsoft's online ...
0
votes
1answer
158 views

How can JSON column formatting be used to highlight duplicate entries in a column a list?

Column formatting is used in SharePoint Online to customize how fields in lists are displayed. Microsoft provide documentation regarding the use of JSON for column formatting. As is described in the ...
0
votes
2answers
82 views

response.json return problem - undefinied

I have got problem with response . json() return problem. I have got two methods one is Mocking List, and another is by JSON. Mock method works superb. but return from response.json() returned me ...
0
votes
2answers
38 views

If current field (target closure date <= today AND Status = “Open”(This is drop down option)), then text should display in red color

If current field (target closure date) is <= today AND Status = "Open"(This is drop down option), then text should display in red color. I have tried with below JSON but no luck: { "$schema": ...
1
vote
2answers
203 views

Highlighted Content Column Creation

Our SharePoint tenant is host to multiple Client sites, all of which are structured more or less the same and with access to each Client site given to ourselves and the respective client. Each site ...
0
votes
1answer
73 views

Read Swagger (JSON) from Sharepoint

appreciate if anyone can help on my below queries. SharePoint list have swagger(json) files. How to read swagger form SharePoint list through problematically. Is it possible? If possible what are the ...
0
votes
1answer
90 views

SharePoint modern view formatting with JSON

My style is accepted but it overrides the ATTRIBUTES: Class. How would you suggest I take advantage of incorporating the if(indexOf(@currentField inside the STYLE - which will allow me to do a ...
0
votes
1answer
297 views

Help with JSON to format column to show picture instead of URL

I have a contact list created in SharePoint Online. My list has a column called "Picture URL". The "Picture URL" column is formatted as "Single line of Text". I have formatted the "Picture URL" ...
0
votes
2answers
238 views

error in Parse JSON Step in MS Flow

Sorry for the long question, but I wanted to include all the JSON to get the best help. we are getting an error parsing JSON from an HTTP Get request in our flow. Here is the schema we are using in ...
1
vote
2answers
53 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
1
vote
0answers
13 views

C# api upload to SharePoint [closed]

I want to read and upload on SharePoint, anyone can help me ? I use C# api. I try by Cloudinay and Api works.
1
vote
1answer
70 views

Get certain field from returned JSON object

I am editing a SharePoint List using JS Link. Within a SharePoint-Column, I would like to display information from another SharePoint column. The source is a SharePoint Person Column (Entliehenan). ...
1
vote
1answer
321 views

JSON datetime tracking custom formatting

I am trying to format a sharepoint list with JSON so that the From/To column highlights the current phone number when todays date falls into the timespan given. I have managed to have past on future ...
0
votes
1answer
149 views

Reference Metadata field with JSON Formatting

I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value? { "elmType": "a", ...
0
votes
0answers
15 views

List View JSON warning if date is 1 month away

I would like a row on my list view to show red if a date is one month away. Very new to JSON, this is what I've started with: I think where I have typed ONE MONTH AWAY I need a calculation but just ...
0
votes
0answers
75 views

Provisioning Quicklinks

I have a request to create a template that includes a QuickLinks web part. I noticed that PNP exports the web part like this: </pnp:CanvasControl> <pnp:CanvasControl WebPartType="QuickLinks" ...
0
votes
0answers
187 views

JSON column format not working for Rating Scale questions

When adding JSON column formatting to a 'Rating Scale' question it does not appear in the survey. When I use the same JSON column formatting on a list however it does work. The purpose of the JSON is ...
0
votes
1answer
82 views

SharePoint online site script

I'm havin' trouble with adding a managed metadata column trough JSONsitetemplate. When adding a 'self-made' column I get an error 'parameter Internalname references a resource that coud be found' ...
0
votes
1answer
261 views

Resolution for SharePoint: Uncaught TypeError: Cannot read property of undefined?

Successfully grabbing values for person columns with multiple selections allowed. Looking at the call in the browser I see the info I need: function dChange() { $.ajax({ url: xurl + "/_api/web/...
0
votes
1answer
207 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
0
votes
0answers
733 views

SP Lists - JSON Conditional formatting based on other columns

I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns. Here is what I was trying to set up: (1) IF @ColumnName1 = "status 4" THEN @...
1
vote
2answers
350 views

SharePoint Online Version Column Formatting via JSON

I am trying to archive the following within a document library modern experience on SharePoint Online: All minor version (everything .1-9) the background should have the color red or similar All ...
0
votes
1answer
2k views

How to utilize if/else condition for JSON column formatting in SharePoint?

I am trying to format the color of a column based on the selection of another column in the same View. But, I am having trouble writing the JSON to check for multiple values in the other column. Here ...
0
votes
0answers
20 views

How to loop through array of objects grouped by date?

I want to get the properties of array including its length to get the count and the requested date of each objects inside the array which is grouped by date. Can anyone please help me on this ? ...
1
vote
1answer
251 views

Export Modern Team site as a JSONfile

I'm about to set up a new SPO env. In the env I should have 5 custom templates, which powerusers can select in the dropdown list when creating a new teamsite. I tried different tutorial and PS ...
0
votes
0answers
28 views

JS script to convert repeated section from XML to HTML - help required

I found this script, see below, which converts the XML format generated from the repeated section within a sharepoint list and renders it in HTML format. <script type="text/javascript"> ...
0
votes
1answer
1k views

REST API How to retrieve the ID of a newly created file

Using the Sharepoint Online REST API I have successfully created a new file using a POST request - https://company.sharepoint.com/_api/lists/getbytitle('MyTitle')/Files/add(name='test.jpg',overwrite=...
0
votes
0answers
26 views

How to get data from Status field using Json?

I have a requirement to get the count of Requested and Completed items in a particular date in SharePoint. I was using json to retrieve the data from SharePoint list. Status is a SharePoint List ...
1
vote
1answer
38 views

Dynamically Constructed JSON/Javascript Object Will Not Stringify

I am trying to take selected listed items and pack specific data values from them into either an array or JSON "object" to then stringify and store in local browser session storage so I can pass it to ...
0
votes
1answer
58 views

Ajax is being called in Chrome but not IE

I'm using Ajax calls to pull in data for a table and I have successfully been able to pull in data for Chrome and everything shows up perfectly fine, but my table is not wanting to show up in IE at ...
1
vote
0answers
115 views

SharePoint 2016 - Polygon in SVG (clickable)

at the moment I try to develop a SharePoint 2016 Visual Web Part project (my first time). I define the content from this Visual Web Part withe JavaScript, becaue I have to build a SVG element by ...
0
votes
0answers
14 views

when i updated any other column, its repeating and apend same values and showing in list version code below

Hi I am using the following below code, but when I updated any other column, it's Repeating/Appending and showing this: function getAllnotesList(requestId){ $().SPServices({ operation: "...
0
votes
2answers
2k views

Rest API Post Request Returns '403 Forbidden'

I am trying to create a new choice (radio buttons) field using REST API request in my SharePoint Online environment and this is the code I'm using: $.ajax({ url: "https://mydomain.sharepoint.com/...
0
votes
1answer
1k views

Use Sharepoint list fields in JSON column formatting

Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
1
vote
2answers
46 views

O365, I have a Column Named 'Status' to show Green/Red circle but I am struggling

This is from a List and on List setting there are two Columns that involves the problem I am facing. Status (absolute name = ColorStatus) NewCol2 Users will enter in either 0 or 1 in NewCol2 field ...
0
votes
1answer
23 views

Backslash being appended to header variable within dictionary in new workflow

I am trying to make a call to a parent list using a workflow. I need to create a dictionary containing two headers: Accept and Content-Type. Both items should have the value of 'application/json;odata=...
1
vote
1answer
639 views

SharePoint Online - Conditional formatting using JSON

I have a Hyperlink column in my list which I want to apply some custom formatting. the column is not Required, meaning the field might be blank on some rows. How can I check if the field is blank, ...
1
vote
2answers
385 views

Using Javascript REST API to do asynchronous batch POST to multiple SharePoint lists

I'm in a bit of a quandry as I'm just learning how to do development in SharePoint 2016 / SharePoint Online and using Javascript to perform REST calls. I have a form that is using REST to successfully ...