Questions tagged [formatting]

The arrangement of data for storage or display.

Filter by
Sorted by
Tagged with
0 votes
0 answers
7 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 ...
user avatar
  • 1
0 votes
0 answers
15 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 ...
user avatar
0 votes
1 answer
100 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 (...
user avatar
1 vote
1 answer
46 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 ...
user avatar
  • 11
0 votes
1 answer
27 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
user avatar
3 votes
2 answers
191 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 ...
user avatar
1 vote
1 answer
215 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 ...
user avatar
1 vote
0 answers
31 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 ...
user avatar
  • 109
1 vote
2 answers
2k 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 ...
user avatar
0 votes
1 answer
31 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 ...
user avatar
  • 1
0 votes
1 answer
133 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 ...
user avatar
0 votes
1 answer
505 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 ...
user avatar
  • 59
0 votes
1 answer
88 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 ...
user avatar
1 vote
2 answers
152 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.
user avatar
  • 59
0 votes
1 answer
864 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 ...
user avatar
  • 3
0 votes
0 answers
187 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 ...
user avatar
  • 7,940
2 votes
1 answer
53 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 ...
user avatar
  • 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 ...
user avatar
  • 21
0 votes
1 answer
237 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 ...
user avatar
  • 3
1 vote
1 answer
209 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;...
user avatar
1 vote
1 answer
543 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[...
user avatar
0 votes
1 answer
115 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' ...
user avatar
1 vote
1 answer
34 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. ...
user avatar
0 votes
1 answer
33 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 ...
user avatar
  • 1
0 votes
1 answer
151 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 ...
user avatar
  • 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 ...
user avatar
  • 459
0 votes
2 answers
127 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
692 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:...
user avatar
  • 11
0 votes
1 answer
68 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 ...
user avatar
  • 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", ...
user avatar
0 votes
1 answer
82 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 ...
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 ...
user avatar
  • 219
1 vote
1 answer
609 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/...
user avatar
  • 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 ...
user avatar
0 votes
1 answer
489 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" ...
user avatar
  • 15
0 votes
1 answer
751 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 ...
user avatar
1 vote
0 answers
180 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 ...
user avatar
  • 11
4 votes
1 answer
283 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')" }" ...
user avatar
  • 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 ...
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, ...
user avatar
0 votes
1 answer
888 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%, ...
user avatar
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 ...
user avatar
0 votes
2 answers
538 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 ...
user avatar
  • 43
1 vote
1 answer
346 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 ...
user avatar
  • 43
0 votes
1 answer
106 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(){ ...
user avatar
  • 2,618
2 votes
2 answers
174 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: #...
user avatar
  • 2,618
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 ...
user avatar
2 votes
2 answers
5k views

How to show date as day of week?

It seems like an obvious request, but I could not find an answer. Within a list, how do I show the day of the week for a date? More specifically, how to show day of week for a default value for the ...
user avatar
0 votes
1 answer
2k views

How to force a number field to keep zeros at the start?

I would like to use a number field to add phone number to a Sharepoint list. But if the phone number starts with 0, it is automaticly removed by default. Is there any way to keep it? I didn't want to ...
user avatar
  • 319
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 ...
user avatar
  • 31