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
2 answers
1k views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
3 votes
2 answers
1k views

JSon REST API. Retrieving items in lists. Workflows

Using this: http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=224 I was able to make a workflow that loops through lists. Now I understand adding ?$top=5000 at the end of my URL I can pull more ...
0 votes
1 answer
2k views

How can I add all contents of a dynamic html table to a SharePoint list?

So my table is 1 row where rows can be added, although it does not have unique id's for each row. I'd imagine this is the issue. $('#submitdata').click(function(){ var table = document....
0 votes
2 answers
2k views

Sharepoint online list view formatting DefaultHoverView using forEach

I am using Sharepoint list JSON view-formatting and want a list of names to each show their live persona card on hover. I can get this to work for just one name, but when I use forEach I cannot get ...
0 votes
2 answers
2k views

JSON column formatting - reference column not in view

Hi we have Sharepoint online site using old template and switched list to use modern experience. Problem is with JSON formatting, because some things do not work as expected. Unable to use/reference ...
0 votes
2 answers
4k views

How to convert text to URL in multi line text column

I have a flow that populates a multi line text column in SharePoint. I want the fields to be clickable as they are links. I didn't format the column to be a hyperlink b/c some links are over the 255 ...
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 ...
1 vote
4 answers
5k 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 ...
1 vote
2 answers
1k views

Using Javascript REST API to do asynchronous batch POST to multiple SharePoint lists

I'm in a bit of a quandry as I'm just learning how to do development in SharePoint 2016 / SharePoint Online and using Javascript to perform REST calls. I have a form that is using REST to successfully ...
5 votes
2 answers
5k views

How can I populate a dropdown with a SP list?

I have a SP List with data that I need to be in a dropdown list. I also need these to have specific classes. I'm trying something like the following but having no luck: $().SPServices({ ...
1 vote
2 answers
1k views

How can I loop through a json result by substituting field/column names with a variable

How can I loop through a json result by substituting column names for a variable End result: I'm building a table from a list (~25 columns). I want to attach custom classes to each cell based on the ...
0 votes
1 answer
3k views

Using the JSON results from a SharePoint API search response

I am using the SharePoint REST API to do a search. I am pulling back the JSON results and reading them as follows: HttpWebRequest endpointRequest = (HttpWebRequest)HttpWebRequest.Create(querystring); ...
3 votes
1 answer
1k views

What is the correct way to create a custom action using REST API in SharePoint Online?

I'm trying to use Microsoft Flow and the Send an HTTP request to SharePoint action to deploy an SPFx application customizer to a modern team site. I'm able to use the /_api/Site/UserCustomActions ...
0 votes
1 answer
3k views

Reading and updating complex JSON Object in power automate

We have a requirement to update the content in the JSON Stored as multiline text column in one of the list, when one of the item in the another list is updated we need to update the JSON data stored ...
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 ...
2 votes
1 answer
2k views

Why is my Ajax call returning a 500 Server Error?

I'm currently building an application page for a SharePoint 2010 site. One of the methods on this application page retrieves the User Profile information from the server and displays it to the client. ...
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" ...
0 votes
1 answer
3k views

Python requests post JSON raw data in SharePoint

I want to update some property in a SharePoint ListItem. I'm using this code: body = '{"__metadata": {"type": "SP.Data.Documentos_x0020_compartidosItem"}, "Tarea": "TP 15"}' header = {'...
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 ...
0 votes
1 answer
4k views

JSON Sharepoint Calculated Columns

First time coding with JSON and need a little help...... I am attempting to make a calculated column with conditional formatting. So far i can get it to work but only partially. What i want is to have ...
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 vote
1 answer
2k views

Export Modern Team site as a JSONfile

I'm about to set up a new SPO env. In the env I should have 5 custom templates, which powerusers can select in the dropdown list when creating a new teamsite. I tried different tutorial and PS ...
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....
0 votes
1 answer
3k views

Help with JSON to format column to show picture instead of URL

I have a contact list created in SharePoint Online. My list has a column called "Picture URL". The "Picture URL" column is formatted as "Single line of Text". I have formatted the "Picture URL" ...
0 votes
1 answer
2k views

List view formatting with JSON - limit the container height

When I apply view formatting to a doc library view, a height gets applied to the container which leaves a huge white space. This is the html where it gets applied: <div class="e_b_ea5ab61a&...
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 ...
0 votes
2 answers
2k views

Using REST: Security invalid error with SharePoint Add-in

Currently getting an error when using REST to upload a file within SharePoint. Error reads "The security validation for this page is invalid and might be corrupted. Please use your web browser's Back ...
1 vote
1 answer
2k views

Format date in a list with quarter and year using JSON on the column

I have a list of projects with planned start dates. I want to use the JSON field formatter, the documentation to which is here, in order to format the date as 'Year'-Q'quarter'. I have a calcualted ...
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 ...
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 ...
0 votes
1 answer
45 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 ...
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 ...
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 ...
1 vote
1 answer
1k views

REST API return encoded Multiline Textfield but show it correctly

I save a JSON string in my SharePoint list. This looks like: {"columns":[{"name":"A","visible":true,"width":200,"sort":{},"filters":[{}],"pinned":"left"},{"name":"B","visible":false,"width":150,"sort"...
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 (...
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 ...
3 votes
4 answers
13k views

When I open my list on sharepoint, it always opens in quick edit mode. How can I fix this?

When I open my list on SharePoint, it always opens in quick edit mode, how can I fix this?
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 ...
0 votes
1 answer
2k views

limit row height, but display full value on hover

I have a field that could contain multiple sites. In the list I'd like to limit the row height, but on hover display all values in the field. Does someone have the JSON code to support this?
3 votes
2 answers
2k views

How do I hide blank fields/divs on lists' card/gallery view?

I have a sharepoint list being used in a visual way with the "Gallery/Cards" view format: Let's say for example I have a field in an entry that doesn't need to have information and another ...
1 vote
0 answers
67 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
274 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 ...
0 votes
2 answers
619 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" ...
1 vote
1 answer
889 views

How do you display text on different lines within a Sharepoint forms header using JSON?

I am attempting to recreate a word document type form on Sharepoint. I have been successful in creating a list and formatting the body of the form to a level where questions are in the appropriate ...
0 votes
1 answer
6k views

Using Json to check if a column contains certain text

So I have this sharepoint list with a (for example) "Date" column, and I want to check if any of the rows contain certain text. For example, in the rows it will either say "The due date ...
0 votes
1 answer
2k views

How can JSON column formatting be used to highlight duplicate entries in a column a list?

Column formatting is used in SharePoint Online to customize how fields in lists are displayed. Microsoft provide documentation regarding the use of JSON for column formatting. As is described in the ...
2 votes
2 answers
3k views

Set column height equal to height of record in List

I have a SP list where one of the columns is multi-line I have therefore set the style of this specific column as "height":"auto" which works perfectly for this column. I then have other formatted ...
1 vote
1 answer
3k views

Column formatting with JSON add dynamic hyperlink

I want to format a column using JSON to add a Workflow Start LINK but can not change the element ID dynamically. Can someone please help? { "elmType": "a", "txtContent": "", "attributes": ...
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 ...
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 ...

1
2 3 4 5
7