Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 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
1 vote
0 answers
20 views

SharePoint change date format in access request email

The image shown above is a sharepoint user access request approval email we received on the 12th of July 2023. It was approved that day. But it is formatted as mm/dd/yyyy. How do we change it to dd/mm/...
John Doe's user avatar
0 votes
1 answer
438 views

Hover card for groups in sharepoint lists

I have a person type field in a sharepoint list. This field accepts both groups and individuals. When hovering over an individual I can see the default person card, but nothing appears when I hover ...
rmorel's user avatar
  • 1
0 votes
1 answer
198 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
147 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
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
1 vote
1 answer
304 views

Will Conditional formatting to hide a column in a SharePoint list work if the column name contains a /?

I have a choice column name that is "this/that" with the choices "this" and "That". I would only like some other columns in the list to appear when "this" is ...
FatZack's user avatar
  • 11
0 votes
1 answer
35 views

hide a specific Sharepoint form field if the user is not the creator of the record

I would like to hide a specific Sharepoint form field if the user is not the creator of the record. I'm trying to use conditional formatting without success. Some one can help me? Thank in advance
Alexandre Gondar'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
1 vote
1 answer
766 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
0 answers
70 views

Column formatting - add style on top of existing styles

I have a "person" column in one of my lists which allows multiple selections. I would like to format it so that all the pills are displayed as flex with wrap enabled. I'm looking for a ...
Gangula's user avatar
  • 109
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
0 votes
1 answer
56 views

infopath formatting condition not working

I have these 2 button: When amount is more than 1,000,000, I want to hide button approved and show button approved & forward to gceo. When amount is less than or equal 1,000,000, I want to show ...
moon's user avatar
  • 1
0 votes
1 answer
242 views

json column formatting - change txtcontent onhover or active css link?

I have a button for a flow that users can click in a SharePoint library [modern experience]. I'm wondering if it's possible to change the txtcontent of the button after the button is active? Just ...
user2004758's user avatar
0 votes
1 answer
904 views

I am working on a microsoft flow which updates a column on the basis of another column

Here is the screenshot of the source and destination: 1. I am working on a flow which updates a column SME Comment CK on the basis of another column SME Comment. These columns are multiline text. but ...
HRY's user avatar
  • 79
0 votes
1 answer
224 views

InfoPath 2010 from dropdown list not showing choices when conditional formatting rule applied

Another "driving me crazy" I add a dropdown list box to my infopath form publishing to SharePoint 2013 list. I add a formatting rule to highlight field. Works fine in preview, when I publish to ...
Midwestsusan's user avatar
1 vote
2 answers
277 views

HTML to display currency $45700 as $45,700 [closed]

I need to display currency $45700 as $45,700 using HTML.Can anyone please help me here how do I do it.
HRY's user avatar
  • 79
0 votes
1 answer
1k views

Multi line text field with enhanced rich text is displaying text with an awkward format and extra empty lines are created in the email notification

Please help me in how to correct the format of the text display in the email body. I saw an answer from Ms. Erin L but, I couldn't understand exactly what I should do. Instead of changing the data ...
user89951's user avatar
0 votes
0 answers
519 views

How to get items vertically aligned across multiple columns on a modern page?

Given a modern page with three columns, I'd like the following in each column: a little bit of text and a button below it, with both the text and button centered. If each text block has two lines of ...
Mike2500's user avatar
  • 8,060
2 votes
1 answer
61 views

SharePoint List column validation related to another item

I have a SP list with 3 fields: "report type" (choose list "A", "B" or "AB") "Type A due date" "Type B due date". I want to set-up column validation for the due date so that "Type A due date" is ...
Nico's user avatar
  • 33
2 votes
1 answer
2k views

Formatting list row background color

I am trying to change the background color of rows in my SharePoint (365) list based on values in a column. I am aware you can use additionalRowClass in the JSON formatting pane to alter a row based ...
txc03u's user avatar
  • 21
0 votes
1 answer
386 views

Sharepoint 2016: Format hyperlinks in a column

How can I format the hyperlinks of a specific column. In my case I have a list with several columns and one of them with title "Quicklink" is formatted as "Hyperlink" and displays a standard link to ...
Tom's user avatar
  • 3
1 vote
1 answer
294 views

Changing list column width with Script Editor doesn't break line

I have a webpart that has a list with columns. To change the width of these columns I inserted a Script Editor and used this code: <style> .ms-vh-div[displayname='Beschreibung'] { width: 450px;...
stepbysteptomathpro's user avatar
1 vote
1 answer
895 views

Modify SharePoint List column width of custom webpart with HTML source

I have a custom webpart called Available seminars: I want to modify the width of certain columns. On the Internet it is written that I have to use <style type='text/css'> .ms-vh-div[...
stepbysteptomathpro's user avatar
0 votes
1 answer
331 views

Date is correct, but String is not being recognized as a valid datetime

I use this to get the current date with one month added to it: var date = new Date(); day = date.getDate(); month = date.getMonth() + 1; month = month + 1; if((String(day)).length == 1) day = '0' ...
Ramanujan Taylor's user avatar
1 vote
1 answer
38 views

Conditional formatting for a row that contains any information

I have a list that I am using for a library check out. When a person populates the check out date field I want my row to be grayed out. The condition would be if a field contains "any" information. ...
Gary Peters's user avatar
0 votes
1 answer
1k views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
Ralphy's user avatar
  • 1
0 votes
1 answer
235 views

SharePoint 2013 - format webpart list column text not based on a condition

I would like to change the color and text size of a calculated column in a SharePoint 2013 not based on any condition. Searching online I have only been able to to find ways of applying conditional ...
Bob's user avatar
  • 1
0 votes
1 answer
42 views

No Column formating template

I am trying to add a column format template , basically marking the column “red” when the column is set to “No” and “blue” for when it is “Yes”. My custom columns, they don’t have the option to ...
Ed1995's user avatar
  • 459
0 votes
2 answers
180 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
user avatar
1 vote
1 answer
1k views

Color Coding List Item by Web Part based on value

I am currently trying to get color coding on a list to highlight good medium and bad properties. I have tried to follow the examples shown here for color coding: SharePoint 2013 Client Side Rendering:...
Daniel's user avatar
  • 11
0 votes
1 answer
71 views

Conditional Formatting based on whether or not time is present

Is there a way to set background color conditionally ony when data is present? Only when someone sets a time due it shows up in the column and I want to make that more visible. I am familiar with ...
Jason D's user avatar
  • 11
0 votes
1 answer
2k views

Reference Metadata field with JSON Formatting

I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value? { "elmType": "a", ...
Michael Colbs's user avatar
0 votes
1 answer
176 views

Hide items in list based on group membership

I have a list of items in Sharepoint. I want to allow group members to submit items to the list, but I only want owners to be able to view the items. Microsoft has an example of hiding fields in rows ...
Adam V's user avatar
  • 101
0 votes
1 answer
2k views

How can you edit the format of modern style list/library column headers in Sharepoint Online?

Is there a way to format the column headers of a modern list or library in Sharepoint Online? I would like to make the dividing borders between column headers show up even when you're not hovering ...
gtew234's user avatar
  • 219
1 vote
1 answer
667 views

Column Formatting using JSON: Get value of the column “_ModerationStatus”

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval. I have the following JSON: { "$schema": "https://developer.microsoft.com/...
Perka's user avatar
  • 153
0 votes
1 answer
9k views

Formatting list row based on status column Office365

I am trying to change the background color of each row in SharePoint list on office 365. I have been looking online for two days there are so many solutions and most of them don't work on new list ...
Ehsan Aliverdi's user avatar
0 votes
1 answer
535 views

Format text on lookup popup and text inside a table

I have a multiple lookup data inside a table. I have to format a text "Stato" with green background if it is "PRONTO CONSEGNA". And do the same thing inside the table isolating the single "Id_uni" ...
MarkR's user avatar
  • 15
0 votes
1 answer
885 views

List View Row Formatting Using Ratings Column

I have a SharePoint Online list that contains the standard like style ratings feature. I am trying to format a row view for this list, I can get everything to work except for the ratings column (I ...
Trey Kent's user avatar
1 vote
0 answers
247 views

Column formatting for multi-choice field in SP Modern

Context: I'm working as a regular user consuming my company's modern Sharepoint deployment, so my capabilities are pretty limited other than what's available from the GUI. I'm trying to format a ...
TWNA's user avatar
  • 11
4 votes
1 answer
445 views

Column Formatting using JSON: Get value of the column "CheckoutUser"

I´m trying to check the value of the column "CheckoutUser" with json. ""style": { "min-height": "35px", "margin-top": "6px", "display": "=if([$CheckoutUser] != null, 'block', 'none')" }" ...
Perka's user avatar
  • 153
2 votes
1 answer
2k views

Using modern list view formatting to alternate row colors

I have been looking into using view formatting to alternate the colors of rows in order to recreate what came out of the box in the classic views. However it seems like I can't access the row ID as a ...
Kasper Bo Larsen's user avatar
1 vote
1 answer
1k views

SharePoint Online - Conditional formatting using JSON

I have a Hyperlink column in my list which I want to apply some custom formatting. the column is not Required, meaning the field might be blank on some rows. How can I check if the field is blank, ...
Frank-Ove Kristiansen's user avatar
0 votes
1 answer
1k views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
Stefan A's user avatar
0 votes
1 answer
72 views

Modern Page - Display Powershell Code with corrent visual format

is there a way to display powershell code in a code block with the correct visual elements to it (colour, font, etc)? We are moving to modern pages for our internal how to guides and this would help ...
user3284404's user avatar
0 votes
2 answers
614 views

Change the background colour of a cell - not highlighting text

I'm using the script editor to format my list. When I use this block of code: function boldTemplate(ctx){ var value = ctx.CurrentItem[ctx.CurrentFieldSchema.Name]; switch(value){ case ...
Jummi's user avatar
  • 43
1 vote
1 answer
444 views

Sharepoint 2013 - issue with using java script to format columns

I found a few tutorials to do this, many of them point to using the jslink or content editor. I tried following the instructions in this site: CSR code samples #1 (Task Priority color) but it's not ...
Jummi's user avatar
  • 43
0 votes
1 answer
247 views

Color coding a single cell in list with jquery

based on this jquery that worked, how do I change it to color code a single cell instead of the whole row? I also need 3 colors <script type="text/javascript"> $(document).ready(function(){ ...
susan's user avatar
  • 2,678
2 votes
2 answers
181 views

CQWP ItemStyle: how to display background of description with conditional formatting

I have 3 elements in a field and I would like the CQWP to display red as a bg colour of the field or amber or green. I guess the starting point is <xsl:if test="RAG = 'Red'">background-color: #...
susan's user avatar
  • 2,678
0 votes
1 answer
23 views

How can I change the format of a Combo-Box with fill-in answers?

I'm trying to create a field with InfoPath 2013 that is a list box that allows a user to enter in their own values. That part is simple. Where I'm running into issue is that I want to change the ...
Matt Kemberling's user avatar