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.
331
questions
0
votes
0
answers
13
views
Change element height in montly Calendar View
I am looking to customize a calendar view in SP Online. My boss requested that the elements shown in the calendar view be bigger, as they take too less space in his opinion.
I am not familiar with ...
0
votes
0
answers
26
views
SharePoint Online - JSON - highlight selected page
I have followed the guidance from this site and successfully created a menu based on Pages Library. However, I would like to modify the JSON so that the selected page (i.e. the page that is currently ...
- 45
0
votes
0
answers
10
views
Site Collection +New button options not available after applying site template (SiteDesign/SiteScript)
Hello and thank you in advance. I have deployed the following site design script below. However, once i apply the template the options under +New on the site collection homepage are no longer ...
- 15
1
vote
0
answers
47
views
Using Data from another Column to Populate Name (of employees without email)
I have created a list of all employees with the Primary column set to "Person / Group". Of course, all employees that have an active email address are registered in the Active Directory, but ...
1
vote
1
answer
122
views
How to conditionally trigger a JSON statement or display image
Team,
I am using the SharePoint conditional formatting (bottom) to display a PDF icon in lieu of a URL link to a PDF (I run a Power Automate flow to create a PDF copy of each file uploaded to ...
- 99
0
votes
2
answers
253
views
Hide/Remove "Edit All", "Show Comment" and the directory path from a list form in display mode
I have the following issue. I have a SharePoint list form (open in display mode which means every field can be edited and saves automatically) and I would like to hide/remove the "Edit All" ...
- 27
0
votes
0
answers
16
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
811
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
50
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
37
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 ...
2
votes
1
answer
806
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" ...
- 57
0
votes
0
answers
189
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
73
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
18
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
146
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
2
answers
83
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,481
0
votes
0
answers
1k
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
112
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
107
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
1
answer
253
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 ...
1
vote
1
answer
583
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
2k
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
321
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
690
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 [email protected]".
I want to format it with a JSON in the SharePoint Online.
Here is ...
- 21
1
vote
1
answer
881
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
144
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
1k
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
829
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
839
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
569
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
1k
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
1k
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
355
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
1k
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
678
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
976
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": "...
- 113
1
vote
1
answer
628
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
7k
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
239
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
2k
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
1
vote
1
answer
3k
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&...
- 228
1
vote
1
answer
495
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 ...
- 228
0
votes
1
answer
829
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
274
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 ...
- 373
0
votes
1
answer
105
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
360
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 &...
- 373
1
vote
3
answers
4k
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
3k
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 ...
- 373