Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
0 votes
1 answer
262 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 ...
  • 1
0 votes
1 answer
22 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
54 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 ...
0 votes
0 answers
235 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
0 answers
17 views

Bug with SPO list search and field customization

I'm building phone book, on my list is rich text field with simple bullet list with user absence. For that field, I added custom format to show the field value as a popup, and that work fine when ...
0 votes
1 answer
576 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 vote
1 answer
139 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 ...
  • 11
0 votes
1 answer
31 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
3 votes
2 answers
566 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 ...
1 vote
1 answer
394 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
0 answers
40 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 ...
  • 109
1 vote
2 answers
4k 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
38 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 ...
  • 1
0 votes
1 answer
170 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 ...
0 votes
1 answer
601 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 ...
  • 79
0 votes
1 answer
133 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 ...
1 vote
2 answers
222 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.
  • 79
0 votes
1 answer
990 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 ...
  • 3
0 votes
0 answers
256 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 ...
  • 7,970
2 votes
1 answer
56 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 ...
  • 33
2 votes
1 answer
1k 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 ...
  • 21
0 votes
1 answer
296 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 ...
  • 3
1 vote
1 answer
237 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;...
1 vote
1 answer
661 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[...
0 votes
1 answer
187 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' ...
1 vote
1 answer
35 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. ...
0 votes
1 answer
209 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 ...
  • 1
0 votes
1 answer
212 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 ...
  • 1
0 votes
1 answer
32 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 ...
  • 459
0 votes
2 answers
150 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
804 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:...
  • 11
0 votes
1 answer
70 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 ...
  • 11
0 votes
1 answer
1k 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", ...
0 votes
1 answer
116 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 ...
  • 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 ...
  • 219
1 vote
1 answer
642 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/...
  • 153
0 votes
1 answer
8k 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 ...
0 votes
1 answer
509 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" ...
  • 15
0 votes
1 answer
805 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 ...
1 vote
0 answers
203 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 ...
  • 11
4 votes
1 answer
326 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')" }" ...
  • 153
2 votes
1 answer
1k 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 ...
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, ...
0 votes
1 answer
969 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%, ...
0 votes
1 answer
57 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 ...
0 votes
2 answers
561 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 ...
  • 43
1 vote
1 answer
381 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 ...
  • 43
0 votes
1 answer
163 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(){ ...
  • 2,638
2 votes
2 answers
176 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: #...
  • 2,638
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 ...