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
12 views

PowerAutomate-SharePoint List: invalid response for workflow operation 'Create_new_folder'

I have been working on this list and flow for a few weeks now and it took me a while to figure out how I could extract an attachment from the SharePoint List and send it to a newly and automatically ...
Nicolle's user avatar
1 vote
1 answer
104 views

JSON formatting: make some words inside body text of email bold

I know how to make text bold in its entirety, but is there a way to make SOME text within my email body bold? Example: "&body=This is a test" How do I only make the word 'test' bold ...
MV90's user avatar
  • 25
0 votes
1 answer
19 views

Background color of fields according to input - SharePoint Online List

I know nothing about JSON but I need to get JSON that will allow me to set the background color field of a "Status" field based on the selected "Status" - i.e selection of yellow ...
user107691's user avatar
0 votes
0 answers
17 views

How to create a filter link to what we want with formatting when there are two lookups from the same list?

I have two lists. In the first list, I have a column calculated according to the active/passive status of the title column. In my second list, I create a lookup column according to the calculated ...
UmitcanSoylemez's user avatar
1 vote
1 answer
343 views

Add Text to Body of SharePoint List Using JSON

Is there a way to add text for instructions in the body of a list without PowerApps? I would like to change up this JSON code to make it possible. I'm aware that there is a "Description" ...
Nanu's user avatar
  • 47
0 votes
0 answers
94 views

Using JSON AST to conditional format columns

I'm trying to make a sharepoint page for a company as user friendly as possible. Now I'm new to JSON and I just get the hang of it. The problem is that the sharepoint only works with JSON AST, which ...
Mathbeginner's user avatar
0 votes
0 answers
44 views

Update existing .json file using PnP PowerShell

I have exiting .json file. Please find the exiting file tags. Exiting .json file: { "properties": { "connectionReferences": { "shared_sharepointonline": { ...
Harish Patil's user avatar
0 votes
0 answers
17 views

Is it possible to deploy JSON to every view, of every list/library, of every site collection in a tenant?

I have a requirement to hide the 'Integrate' and 'Automate' buttons in the ribbon of a SharePoint list and library for all sites in a tenant. I understand this can simply be done using some JSON ...
Harry Jones's user avatar
0 votes
0 answers
82 views

Display modified time without seconds

Trying to display modified time in a list, showing the time only in hh:mm format. I added json as follows to column formatting, which shows hh:mm:ss - { "$schema": "https://...
MattDwyer's user avatar
0 votes
0 answers
49 views

Rest API Search output schema issue - change in the order

We have noticed below changes in the Search Rest API output schema (JSON Output), earlier these default columns (Rank, DocId) used to come as the first two nodes "RowCount": 1, "...
Virendra Kumar's user avatar
0 votes
2 answers
65 views

Get items from SPO and past them in Azure SQL

I am trying to make a logic app with "Recurrence" triger which get items from SPO list (from view) with condition: if have null values, then pass them some string or boolean (if column is ...
jck4real's user avatar
1 vote
0 answers
1k views

How to get Key Value Pair value from valid JSON string in PowerApps?

I am working with the requirement in PowerApps where I have a JSON string like below { "Created": "2022-08-29T16:40:19", "IsCurrentVersion": true, "VersionId&...
Aakash Maurya's user avatar
0 votes
0 answers
614 views

Align text with JSON in the middle of a column in Sharepoint online

Hey i am trying to set text vertically in the middle of a column in Sharepoint online. I found some solutions and i tryed all so far but none of them works. I wonder if the coding or naming of JSON-...
Jannik's user avatar
  • 11
0 votes
1 answer
53 views

Add a right sided border to a column in a list in SharePoint

I'm hoping to add a plain black border to break up the columns on what is going to be a list with a lot of columns. Thank you!
Kaz's user avatar
  • 1
0 votes
1 answer
70 views

MS List Conditional Formatting JSON with SharePoint 365

I've reviewed a lot of threads and none seem to quite fit my fact pattern. I'm using the Modern MS Lists, in Office 365 Online. We have a list of contracts that we want to color code rows based on ...
FSomers1's user avatar
0 votes
0 answers
327 views

SharePoint JSON Formatting - Custom Card Props performance issues

I have noticed huge performance issues with customCardProps (CCP) JSON formatting recently. I'm not sure what has changed as this hasn't caused me issues in the past and seems to have occurred within ...
Joshua's user avatar
  • 1
0 votes
1 answer
123 views

Multiple URLs in a single JSON Hyperlilnk

I have a quick question about JSON HREF in SharePoint lists: Is it possible to trigger opening of 2 URLs in 2 new tabs by one hyperlink click? I tried some things like the one below, but they all ...
Olicanvio's user avatar
0 votes
0 answers
31 views

Removing unnecessary fields across SharePoint API requests

I'm currently building an app which will use the _API to pull the list into (currently) an XML format, however, there are multiplier fields that I don't really need. I have first created the API link ...
Ollie Rooke's user avatar
0 votes
0 answers
71 views

Word wrap formatting Name column in document library

I want to word wrap the Name column. I am using the following code to wrap the column "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json"...
hellothere's user avatar
1 vote
1 answer
352 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: { "$...
Carson's user avatar
  • 11
0 votes
0 answers
1k 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 { "...
hellothere's user avatar
1 vote
1 answer
196 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 ...
Bh1208.'s user avatar
  • 33
0 votes
1 answer
409 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 ...
Matthias's user avatar
1 vote
1 answer
572 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/...
Patty's user avatar
  • 11
0 votes
1 answer
107 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 ...
readytodrum's user avatar
0 votes
1 answer
735 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 (...
MTSpace's user avatar
0 votes
1 answer
610 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 ...
JDaniels's user avatar
0 votes
2 answers
710 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: { &...
szzz's user avatar
  • 1
1 vote
1 answer
427 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....
Foxhole's user avatar
  • 13
1 vote
1 answer
829 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?
Soundariya's user avatar
0 votes
1 answer
999 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 ...
Matthias's user avatar
0 votes
1 answer
276 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 ...
Troy Pickens's user avatar
3 votes
2 answers
797 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 ...
rilakkuma's user avatar
0 votes
1 answer
530 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 ...
Gunilla's user avatar
  • 355
0 votes
1 answer
749 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": "...
neptr's user avatar
  • 103
1 vote
1 answer
454 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 ...
Patricia Fifield's user avatar
1 vote
2 answers
5k 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 ...
RogueVeggie's user avatar
1 vote
2 answers
218 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....
llrinct's user avatar
  • 11
0 votes
1 answer
1k 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 ...
BobS's user avatar
  • 1
0 votes
1 answer
2k 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&...
Martin Dub's user avatar
1 vote
1 answer
397 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 ...
Martin Dub's user avatar
0 votes
1 answer
571 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 &...
John John's user avatar
1 vote
2 answers
208 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 ...
k1dfr0std's user avatar
  • 129
0 votes
1 answer
1k 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 ...
Chris's user avatar
  • 261
0 votes
1 answer
78 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)...
James Bellinger-Brown's user avatar
0 votes
1 answer
237 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 &...
Chris's user avatar
  • 261
1 vote
3 answers
3k 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 ...
Joseph's user avatar
  • 11
2 votes
2 answers
2k 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 ...
Chris's user avatar
  • 261
3 votes
2 answers
588 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 ...
klewis's user avatar
  • 1,329
0 votes
2 answers
495 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 ...
Jelon3k's user avatar
  • 61

1
2 3 4 5
7