Questions tagged [formatting]
The arrangement of data for storage or display.
161
questions
1
vote
0
answers
17
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/...
0
votes
1
answer
391
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 ...
0
votes
1
answer
113
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!
0
votes
1
answer
107
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
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 (...
1
vote
1
answer
254
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 ...
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 ...
1
vote
1
answer
628
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
61
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 ...
1
vote
2
answers
7k
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
48
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 ...
0
votes
1
answer
222
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
828
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 ...
0
votes
1
answer
201
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
258
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.
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
427
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 ...
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 ...
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 ...
0
votes
1
answer
368
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 ...
1
vote
1
answer
276
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
796
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
282
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
36
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
790
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 ...
0
votes
1
answer
233
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 ...
0
votes
1
answer
38
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 ...
0
votes
2
answers
179
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 ...
1
vote
1
answer
988
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:...
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 ...
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",
...
0
votes
1
answer
158
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 ...
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 ...
1
vote
1
answer
661
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/...
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 ...
0
votes
1
answer
528
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" ...
0
votes
1
answer
852
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
236
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 ...
4
votes
1
answer
405
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')"
}"
...
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 ...
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%, ...
0
votes
1
answer
64
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
604
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 ...
1
vote
1
answer
425
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 ...
0
votes
1
answer
225
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
votes
2
answers
177
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: #...
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 ...
2
votes
2
answers
7k
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 ...