Questions tagged [column-formatting]
This tag is used for the questions related to the column formatting using JSON in SharePoint Online, SharePoint 2019, etc.
366 questions
0
votes
0
answers
15
views
Fields should be blank when no date is added
Im new to sharepoint and currently working on some lists with dates and expiration dates to track employees yearly training refreshers. The list is functioning properly when it comes to the color ...
- 1
0
votes
0
answers
16
views
SharePoint list displays time since creation instead of creation time
In the list, on the SharePoint website, the creation date information disappeared and only one remained. (printscreen)
I don't know why this happened, but it could be easily fixed by changing the ...
- 101
0
votes
0
answers
30
views
Can SharePoint column-formatting JSON dynamically render approval metadata on hover?
I'm working in SharePoint Online document library and trying to display detailed approval metadata in a hover-triggered card. The data is generated dynamically via Power Automate and stored in a plain ...
0
votes
0
answers
31
views
"For a selected file" flow fails because the user is missing "prvReadOrganization" privilege
In a SharePoint library, I've implemented a button which should trigger a flow, for reference: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-advanced?source=...
- 351
0
votes
1
answer
51
views
How do I create a working button that updates dynamically depending on the values of two columns in my SharePoint document library?
I need help with creating a JSON structure for formatting a custom "single line of text" column in my SharePoint document library. The column, called "Start Document Workflow," ...
0
votes
0
answers
21
views
Remove ZWSP from SharePoint List
A while ago, I converted a table from a SharePoint wiki page into a SharePoint list so it could be used for lookups. The lookups don't always the results that are expected. Exports don't come out as ...
1
vote
1
answer
36
views
In a SharePoint Document Library, how do you create a column with the Properties (pencil) icon like in the attached screenshot?
In a SharePoint Document Library, how do you create a column with the Properties (pencil) icon like in the attached screenshot?
Screenshot of the Column Needed:
- 11
0
votes
0
answers
22
views
How to derive actual values from a JSON-column formatted text field in SP List - as they display as NULL when extracted into Tableau?
I have an SP List that has a multi-select Lookup Column that is a selection of DB tables (Asset Name). I need to display the SP List in Tableau including Asset Name however it is displaying as a ...
- 1
0
votes
0
answers
15
views
Automatic color scale conditional formatting for a column
I want to apply conditional formatting to a date column in a SharePoint list, similar to the color scale feature in Excel.
The formatting should automatically assign colors (e.g., shades of green) ...
- 113
0
votes
0
answers
83
views
Keep default appearance of Title field when using custom column format
In a SharePoint List I want to add an icon to the Title field while preserving all appearance and behavior of the default Title field.
I wrote a custom column format, and on the first pass I realized ...
- 101
0
votes
1
answer
150
views
In a Sharepoint list, can I format a date column by multiplying the date with a value in another column?
In my list I have a column with dates. I want a field in this column to turn yellow when the date is more than X years ago. Where X is a number in another column.
For example:
Date in field A2 is &...
0
votes
1
answer
36
views
When a user enters text in the column Opmerkingen than an icon must be displayed instead of text
I have a SharePoint list with 5 columns. One is called "Opmerkingen". What I would like is that when a user enters text in that column it shows an icon "comment"instead of the text....
- 71
0
votes
0
answers
419
views
Create a Gantt chart for Project List in Modern SharePoint using JSON code
Any Help will be greatly Appreciated!
I have a SharePoint list [Project List], and I have created a Gantt chart with JSON code below.
Gantt View:
But I need a Gantt chart view that takes tasks for ...
1
vote
1
answer
164
views
How to customize the column Title with JSON?
Is it possible to change the column Title with JSON? In the column Title a message-icon is displayed when a user has added a comment. I would like to hide the 3 dots and make the icon aligned to the ...
- 71
1
vote
1
answer
98
views
SharePoint Column Formatting that detects matching words across all the items in the same column
I have a SharePoint list that has a specific column that is a "Multiple lines of text" type that is used to store a serial number or multiple serial numbers in a single column (separated by ...
- 13