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.
330
questions
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 ...
- 1
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 ...
- 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 ...
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 ...
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" ...
- 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 ...
- 101
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": {
...
- 11
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 ...
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://...
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,
"...
- 359
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 ...
- 1
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&...
- 8,461
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-...
- 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!
- 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 ...
- 3
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 ...
- 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 ...
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 ...
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"...
- 77
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:
{
"$...
- 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
{
"...
- 77
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 ...
- 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 ...
- 21
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/...
- 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 ...
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 (...
- 1
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 ...
- 1
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:
{
&...
- 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....
- 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?
- 11
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 ...
- 21
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 ...
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 ...
- 55
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 ...
- 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": "...
- 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 ...
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
...
- 13
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....
- 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 ...
- 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&...
- 218
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 ...
- 218
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 &...
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 ...
- 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 ...
- 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)...
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 &...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 61