2022 Developer Survey is open! Take survey.

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
0 votes
0 answers
5 views

How to deal with floating numbers and decimal comma?

With JSON we tried to compare values and failed for a long time until we recognized, that this only happens to columns with floating numbers. Then we tried to use floats with decimal dots (e.g. 2.25) ...
user avatar
0 votes
0 answers
5 views

How to calculate aggregates in a group header

We organize some of our projects in sharepoint lists. There are two columns of interest: TODO and DONE In "TODO" we assume the time in days to get something done and in "DONE" we ...
user avatar
1 vote
1 answer
11 views

Reducing decimal places on percentage

I would like to reduce the number of decimal places in a calculated column with some JSON formatting. I would like to reduce this to 101%. The JSON code I have written is shown below: { "$...
user avatar
  • 11
0 votes
0 answers
10 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
0 answers
12 views

Show charts based on JSON object

I have added this SPFx web part, which provides a Poll capabilities @ https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-quick-poll .. now the Poll results will be added inside a ...
user avatar
  • 2,234
1 vote
1 answer
16 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
21 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
1 vote
1 answer
21 views

SharePoint JSON footer - How to add multiple links below footer - I can only do one and need to show 5 more

SharePoint JSON footer - How to add multiple links below footer - I can only do one and need to show 5 more. Current JSON: { "$schema": "https://developer.microsoft.com/json-schemas/...
user avatar
  • 11
0 votes
1 answer
9 views

What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?

I've run across many descriptions on how to effectively/efficiently set up a click event that pulls data from a single SharePoint list and then exports the data to Excel in a Vue.js environment. So ...
user avatar
0 votes
0 answers
14 views

SharePoint JSON formula for "Contains" value from another Column

I am trying to JSON format my SharePoint list updated by Power apps, my issues is while two columns appear exact that are not due to differing column types and the way the data is created. I would ...
user avatar
0 votes
1 answer
22 views

JSON Language for over 30 days

Sharepoint List, I have a 'Status' column (Completed, In Progress, Requested, Created) and a Date Received column. I would like to 'Date Received' column to turn the text bold, red, 30 days (...
user avatar
0 votes
1 answer
28 views

SharePoint Calculated Column - Nested IF with dates and today's date

I have three columns: End_Date, Completion_Date, Status If the Completion date is before the end date then the status is "On Time" If the completion date is after the end date or today's ...
user avatar
0 votes
2 answers
48 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
10 views

Parse JSON: add description for dynamic content

Is it possible to add a description to the JSON elements in the dynamic content flyout? like in the standard dynamic contents (yellow marking)? My code in Parse JSON looks like this: { "type": "...
user avatar
  • 129
1 vote
1 answer
42 views

How can I format a column based on the formatting of another column?

In my list, I have several columns formatted in either green, yellow, or red based on their individual content. What I want is to format the first column to reflect the overall status of the row/entry....
user avatar
  • 13
1 vote
1 answer
63 views

JSON code for hiding a "See More" button in SharePoint list

Can anyone help me in hiding a class "ReactFieldEditor-MoreToggle" button in SharePoint list?
user avatar
0 votes
0 answers
75 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
0 answers
13 views

Building the Custom Connector's Actions Responses by Importing sample JSON is not working

I am creating a Custom Connector inside Power Automate and Power Apps, and inside the Actions section, i am building the responses objects by importing a sample JSON as follow:- Here is the JSON ...
user avatar
  • 2,234
0 votes
0 answers
26 views

With Management Shell, with Add-SPOSiteDesign cmdlet, I can't change the name of a library or give it a description

What I want to do is have a site template that: Changes the default document library's description; Creates a folder; Changes the title. But I can't manage to do 1 and 3. SiteDesign: Id ...
user avatar
0 votes
1 answer
64 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
3 votes
2 answers
117 views

Formatting column with multiple conditions

I'm having trouble formatting the JSON for a column called "SLA Day Counter". This column just counts the days between when the request was received and when it was actually handled. The ...
user avatar
0 votes
1 answer
119 views

Get JSON file contents into PnP PowerShell variable

I am generating a web page in SharePoint Online with some web parts, using PnP PowerShell. Now I am trying to set up a Highlighted Contents web part, that should display all documents in the site ...
user avatar
  • 323
0 votes
1 answer
263 views

Trigger a Logic App from SharePoint JSON view formatting

Using SharePoint JSON view formatting you can trigger a Flow using the executeFlow custom row action and then providing the ID of the Flow to be triggered, for example: "elmType": "...
user avatar
  • 103
1 vote
1 answer
160 views

JSON Failure: not found on the data object for SharePoint Online column formatting

I can't get SharePoint Online to recognize my field name. I know I could use @currentfield where I have [$2021_Q3] but I want to create a more complex formula and can't even get this basic one to ...
user avatar
0 votes
0 answers
68 views

Vertical Align SharePoint Online List

I have a list that holds 18 columns of KPI data for each month of the year and the 19th column is a multiple lines of text option. A majority of the data is calculated formulas for each row. Since ...
user avatar
0 votes
0 answers
33 views

Set boolean in JSON using if statement

I am building a flow to copy all items in one SharePoint list to another SharePoint list in the same site. The target list varies, so I am creating the list name as a variable. I can't use the Create ...
user avatar
  • 1,051
0 votes
2 answers
1k views

SharePoint Online JSON format phone column to display (555) 444-3333 or 444-3333

Brand new to SharePoint Online and I want to test out JSON to format a telephone column instead of an extra calculated column. I'm attempting to display entries: 5554443333 as (555) 444-3333 and ...
user avatar
0 votes
0 answers
14 views

Liking server file directory

I'm new to SharePoint and started building a page for my team. I am trying to link a Server Directory such as "file://server/serverdirectory/docs"(note: it's not mapped to any drive) --> ...
user avatar
  • 1
0 votes
0 answers
68 views

Modern List Item Layout using JSON. Make Field full width

I am customizing the modern list item form's body using JSON, using this article: Configure the list form This is the JSON I am using: { "sections": [ { "...
user avatar
1 vote
2 answers
117 views

Format column using JSON

I want to format a column if there is a date in the column, otherwise leave it blank. This is the code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting....
user avatar
  • 11
0 votes
0 answers
28 views

Simple JSON to CSV in MS Power Automate problem

I am trying to convert the following JSON using the URL: https://api0.solar.sheffield.ac.uk/pvlive/v3/pes/0 to CSV vis MS Power Automate. I use HTTP to get the response from above URL. And this is ...
user avatar
  • 1
0 votes
0 answers
23 views

SharePoint 365 List: Cannot create a new list from existing list due to stream data

I am making a database on SharePoint 365 for work, having customized the form layout with JSON. The list is pretty big, approaching the max number of bytes allowed for total number of columns. I know ...
user avatar
0 votes
1 answer
705 views

Customize Title column with JSON

Currently my Title column has a link in it, but I need to make it bigger and change the font while keeping the href function (after clicking on the title it opens editing). When I use "elmType&...
user avatar
1 vote
1 answer
105 views

Change choice column after reaching certain date via JSON in SharePoint list

I have a maintenance scheduler list with two inputs: MaintenanceStart (dateTime column) and Status (Choice column) The predefined value in status column is 'Scheduled maintenance' and I would like to ...
user avatar
0 votes
1 answer
185 views

extract the email address from the claim field inside the response message from "Get Items" action

I have the following Get Items action:- where the response body will be as follow:- now i need to extract the email address from the claim field as follow, where i need the email to be added inside &...
user avatar
1 vote
2 answers
128 views

Updating FieldName "Editor" to be same as "Created By" dynamic content using JSON

I am wracking my brain to find a way within SharePoint to overwrite the Modified By column value of an item with the value within the Created By column. I have scoured the internet and have found CSOM ...
user avatar
0 votes
1 answer
540 views

Power Automate - Set Column value to equal value of another Column in same list

I have a modern list with about 5,000 entries. My client has added two columns since creating all this data, and I need to set one column to equal the value of the other (doing this manually will ...
user avatar
  • 139
0 votes
1 answer
40 views

Sharepoint Date Formatting Tracker JSON

I’m creating a currency tracker in sharepoint and want to add some coloured date formatting. My parameters are the following: Expired including today ( #ff7676) Expiring in the next 2 months (#ffcf76)...
user avatar
0 votes
1 answer
86 views

How can I create a Cascade within a Cascade in SharePoint Online (modern or classic)?

So my customer has these two lists (one classic and one modern) in which they'd like me to create a cascade within another cascade. Here's a snapshot of one of the lists: As you can see, they tried &...
user avatar
  • 139
1 vote
3 answers
859 views

Wrap text on title and hyperlink columns

I'm trying to import a list from Sharepoint On-Premise to Sharepoint Online. In the old list, the text was wrapped for both the title and the hyperlink column which gave the list an organized and ...
user avatar
  • 11
2 votes
2 answers
1k views

Change Column Header Font Color on a Modern SharePoint List

I've been trying to hide a column header in a groupedby list on my Modern page. Since I haven't been successful (can't add a web part), I thought I might be able to format the column and add Json to ...
user avatar
  • 139
2 votes
2 answers
238 views

How to increase font size of displayname titles when it comes to JSON formating?

With SharePoint Online, is there a way for us to increase the font size of the displayname titles that we incorporate with JSON? For instance, here is my JSON formatting on a specific list... As you ...
user avatar
  • 1,309
0 votes
2 answers
229 views

How to remove Quick links, news with json

I would like to remove default team site components such as: Quick links and news. So far I have been using Site design JSON schema to change navigation(remove, add new) on the left side. Can this be ...
user avatar
  • 61
1 vote
2 answers
450 views

Hide Sharepoint row with JSON

I have a list of people with some data in the columns. I have managed to mark my own row, with my name in one of the columns, to have grey background. Now any one who views the list can find them self ...
user avatar
0 votes
1 answer
125 views

How to add default folder in document library Json Schema - Team site

I would like to add functionality to my script to add a default "Archive" folder to Document library. It would be good to add in the upper part of the screen an explanation what files should ...
user avatar
  • 61
0 votes
1 answer
303 views

Set a default image for thumbnail column

Within SharePoint online, I would like to set a custom default image for my "thumbnail" column (or "Hyperlink or Picture"). I named it "Cover Photo". If I go into my ...
user avatar
  • 1,309
1 vote
2 answers
736 views

Convert text to fluent icons in multi-value field

I have SPO list with a multi-value field, which is filled by a lookup list (other list on the same SharePoint). The values are the names of MS Fluent Icons. Now I want the names in that field to be ...
user avatar
  • 129
0 votes
1 answer
2k views

How to append additional element in JSON Array using power Automate

I have a SharePoint list having a Notes and another NotesHistory field. Every time user puts some note that should get appended with the NotesHistory field and the original Notes field gets reset. ...
user avatar
1 vote
1 answer
104 views

Using Json to format a columns data. Problems with the styling of a columns height

So I have a column whose data is a multi line field. The problem I am having is it contains a lot of data and stretches out the list. So I tried changing the width and height of the column, but I am ...
user avatar
  • 103
1 vote
1 answer
371 views

Using Json to hover over a column, and display its information

So I have a list with a comment column. I would like to hover over it, and have its information displayed in a card. However I used the code below { "elmType": "div", "...
user avatar
  • 103

1
2 3 4 5
7