Questions tagged [formatting]
The arrangement of data for storage or display.
166
questions
0
votes
1
answer
21
views
Can you apply conditional formatting to a single word in a SharePoint Online List view
Is there JSON coding in Advanced mode (SharePoint Online) that will limit the field formatting to a single word and not the whole row?
The below code will make the whole row have red text, but I would ...
- 1
0
votes
1
answer
22
views
SharePoint List formatting a Date column
I have a SharePoint list with a date column. I want to format the Dates in the column to be centered with Bold Red Text and keep using the existing background color, if the date is within the last 7 ...
0
votes
0
answers
17
views
SharePoint Online List not respecting Formatting
We have a SharePoint online tenant with several subsites. Each subsite contains several lists and libraries. Suddenly, last week, we noticed a few oddities among some (not all) of our lists. They ...
- 21
0
votes
0
answers
57
views
Hyperlinks / HTML / Rich Text in list column fields
I know there're couple older questions regarding this out there. But I wanted to ask an up to date question.
By now, is there a way to use links together with text in a SharePoint list column field? ...
- 573
0
votes
1
answer
33
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 ...
- 13
1
vote
0
answers
22
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/...
- 21
0
votes
1
answer
481
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
367
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
1
vote
1
answer
165
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 ...
- 13
1
vote
1
answer
2k
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 (...
- 11
1
vote
1
answer
335
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
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
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 ...
- 55
1
vote
1
answer
877
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
74
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
10k
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
...
- 13
0
votes
1
answer
61
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
249
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 ...
- 396
0
votes
1
answer
948
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
236
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 ...
- 11
1
vote
2
answers
292
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
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 ...
0
votes
0
answers
580
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 ...
- 8,070
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 ...
- 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 ...
- 21
0
votes
1
answer
393
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
308
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
955
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
357
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' ...
- 105
1
vote
1
answer
39
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. ...
- 53
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 ...
- 1
0
votes
1
answer
239
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
43
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
182
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 ...
user82126
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:...
- 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 ...
- 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",
...
- 3,919
0
votes
1
answer
189
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
3k
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
670
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
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 ...
- 244
0
votes
1
answer
536
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
901
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
252
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
465
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
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 ...
- 2,504
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
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%, ...
- 1
0
votes
1
answer
73
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
621
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