Skip to main content

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

Modified by Column for Changes to Specific Column

I have a document library which users and their managers need to provide acknowledgement on documents. We do this with a date field for both manager and user (Manager Acknowledgement and User ...
Whitney's user avatar
0 votes
0 answers
10 views

Image field thumbnail in custom JSON disappearing on publishing of the page

I have a custom tile view for a list containing information of all people. In this view, I want to have a thumbnail of the user's profile picture. This picture is uploaded in the list in the column of ...
sacoppe's user avatar
0 votes
0 answers
24 views

I need to show the results of a calculated field on the NEW ITEM Sharepoint list form...thoughts?

So, I have a calculated field that is calculated based on how other columns are populate on the NEW ITEM SharePoint list form. I am new but I understand that calculated field will not show on the form....
Jason L. Shaw's user avatar
0 votes
0 answers
21 views

Creating Swagger JSON Schema File out of Dataverse Web API

We have an integration project happening where a microservice would be connecting to Dataverse Web API through a middleware. I know direct point to point integration is possible but this is ...
Zakir HC's user avatar
  • 3,650
0 votes
0 answers
13 views

Date Value from Lookup Field displays in default View, but not in custom View

I have a series of Lists in SharePoint Online. In one List (Plans with Related Findings), I have several Lookup fields to another List (Plans). I'm able to get the Plan Name into a custom view using ...
Adam Freden's user avatar
0 votes
1 answer
46 views

Adding a URL Under a Title Header

I currently have a title header using JSON in a SharePoint list that works as I would like it to. I want to add a URL under the Title which points to a standard operating procedure outlining how to ...
LCZ's user avatar
  • 1
0 votes
1 answer
26 views

Use JSON to calculate Average

Can anyone please help !! Im using a 2x SharePoint Online lists. One list contains a REGISTER One list contains a list of ACTIONS to be taken against items on the REGISTER list I have managed to ...
Sparky's user avatar
  • 13
0 votes
0 answers
56 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 ...
AquaSoley's user avatar
0 votes
1 answer
40 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 ...
Lukas's user avatar
  • 65
0 votes
2 answers
18 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 ...
Adam's user avatar
  • 15
1 vote
0 answers
68 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 ...
Krisda Linsey's user avatar
1 vote
1 answer
277 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 ...
Michael's user avatar
  • 109
0 votes
2 answers
624 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" ...
Jan's user avatar
  • 27
1 vote
1 answer
1k 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
117 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
2 votes
1 answer
1k 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
  • 57
0 votes
0 answers
183 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
2 answers
97 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
2k 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
2k 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
218 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
1 vote
1 answer
148 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
1 answer
324 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
1 vote
1 answer
773 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
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 { "...
hellothere's user avatar
1 vote
1 answer
399 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
991 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 ...
Matthias's user avatar
1 vote
1 answer
1k 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
171 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
1 vote
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 (...
MTSpace's user avatar
  • 11
0 votes
1 answer
951 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
950 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
662 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
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?
Soundariya's user avatar
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 ...
Matthias's user avatar
0 votes
1 answer
474 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
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 ...
rilakkuma's user avatar
0 votes
1 answer
851 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
1k 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
  • 113
1 vote
1 answer
780 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
9k 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
263 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
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 ...
BobS's user avatar
  • 1
1 vote
1 answer
4k 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
554 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
1k 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
335 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
2k 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
  • 409
0 votes
1 answer
128 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
451 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
  • 409

1
2 3 4 5
7