11-02-2017 03:41 PM - edited 11-02-2017 03:41 PM
Hi all,
I would like to update you all on the rollout progress of the column formatting feature. Today, we begun rolling this feature out to first release users. All first release users will have the capability by the middle of next week (Wednesday, November 8th). After that, we'll begin rolling out to first release tenants. All tenants worldwide will have this feature by the end of November.
Here are some handy links to help you get started with column formatting:
We are very eager to hear your feedback on this feature, and hear your suggestions on how we can make it more useful.
11-03-2017 12:30 AM
11-03-2017 12:57 AM
Slightly offtopic, but since you are responsible for modern lists and libraries....When are we going to see modern task lists? Any plans on this one? Or are those not converted to modern and we are supposed to use planner instead?
11-03-2017 01:10 AM
I think as Microsoft mentioned Planner is an integral part of the Office 365 ecosystem and is integrated with Office 365 Groups. And it is ready to use task management portal with all the required components but in case Task list you had to create your SP team site first and then security then you get to manage your project plan. So, i don't see Microsoft planning to apply modern UI to task list as we have Planner released with cool task management features.
11-03-2017 08:44 AM
Sunny is on the right track. Modernizing task lists is not a priority right now - Planner is where we're investing in task management for groups and teams. We are thinking about ways we can connect the two - for example, by migrating SP tasks over to Planner - but we don't have any definitive timelines or plans in this area yet.
11-10-2017 04:58 PM - edited 11-11-2017 10:51 AM
@Lincoln DeMarisLooks like Column formatting has hit first release tenants. Been playing with it and it is working pretty well so far.
However it does not look like the formatting is visible to the List WebPart on modern pages. Are there any plans for this feature to show up in the webpart. I am typically designing SharePoint pages so that a user almost never comes in contact with the actual List itself but sees a page with a list webpart. This is mostly for aesthetic reasons and so I can add things like text or pictures referring to the list on the same page as the list.
Thanks,
11-11-2017 10:07 AM
That's right, formatting does not show up in the web part yet. We are working on that now. When it's close to being released, we'll post here and on the Message Center.
11-15-2017 07:07 AM
this is just what ive been waiting for, i tried pasting / editing the json code in the appropriate place but it doesnt work, is it not up and running yet ?, is it possible our sys admin have blocked anything?
11-22-2017 08:45 AM
This feature is fully rolled out and to our knowledge, there's no way to block the functionality. Can you message me the JSON that you're trying that's not working? Are ALL samples that you've tried not working?
11-23-2017 06:41 AM
11-27-2017 10:16 AM
Column formatting only works in modern.
Try this JSON.
{
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": {
"operator": "?",
"operands": [
{
"operator": "==",
"operands": [
"[$Alert_x0020_date]",
"@now"
]
},
"#ff0000",
""
]
},
"color": {
"operator": "?",
"operands": [
{
"operator": "==",
"operands": [
"[$Alert_x0020_date]",
"@now"
]
},
"#ffffff",
""
]
}
}
}
11-28-2017 12:17 AM - edited 11-28-2017 12:24 AM
It works :) , thanks, I am trying to learn json code and am currently looking through some training videos on youtube.
I have one other problem, that I could do with some help with, the column in sharepoint is set as a calculated column, with the date and time format set as date only, but it displays like this 2016-01-03TO8:00:00Z, how can I get it to display correctly, ie 03-01-2016, it does however work correctly if I switch to classic view
12-11-2017 05:05 PM
Column formatting with JSON works great (I'm only trying to word wrap long titles), but as soon as I close the JSON code text box, the formatting is lost - I can't get the code to persist, either when I apply it from the column in the view, or from the Library settings page.
Is there a trick or a default setting I need to unwind in order for the code to be persisted?
This is the simple JSON code I'm using.
{
"elmType": "div",
"txtContent": "@currentField",
"style": { "white-space" : "normal" }
}
Thanks,
Owen
12-11-2017 05:44 PM
Owen, that actually worked for me in lists and I was trying to do that, so thanks. Ps. Just copied and pasted your code :) Will try in Document library to see if that works also.
12-11-2017 05:45 PM
12-11-2017 05:45 PM
Yep worked their also.
I just clicked the preview first, then save. and the code was still there when I came back to it.
12-11-2017 08:07 PM
Cool. It's not the code - (I don't think) - it worked for me in Preview, and when I hit save, and as long as I kept the little code window open, I could change the sort, scroll the view, etc. But, as soon as I closed the code window, the column went back to not being wrapped.
Strange and unexpected, I know. I was kind of hoping that @Lincoln DeMaris or one of his awesome mighty minions might have seen this before...?
12-11-2017 11:05 PM
12-12-2017 12:12 AM
I still have this problem, that I could do with some help with, the column in sharepoint is set as a calculated column, with the date and time format set as date only and the json code added as you sent me, but it displays like this 2016-01-03TO8:00:00Z, how can I get it to display correctly, ie 03-01-2016, it does however work correctly if I switch to classic view, is there some more json code I can put in to display it in dd/mm/yy format
12-12-2017 11:40 AM
Stephen mine did that as well, but the way I got around it was to use the =TEXT([Date],"dd/MM/yyyy") function in the Calculated field.
I see calculated fields are not yet supported. As json code on it only partially works for some reason.
12-12-2017 03:48 PM
So, I should have stated yesterday that it was the "Title" column where this is not persisting.
(In this doclib, Title is only a line of text, no link to edit, etc.)
In other columns, working fine.
@Deleted; @Juan Carlos González Martín
12-12-2017 03:53 PM
Owen, yes looks like you are right ... all other columns seem to work, just not the title column.
12-12-2017 03:57 PM
And in another tenant, the new doclib has a "Name" column, and it works fine there.
I can't get a "Title" column in a new doclib. This is a migrated doclib that still has a TItle column - perhaps there is some artifact that persisted there. But there must be a lot of doclibs that have both "Title" and "Name" still out there. - let's hope it's still worth a fix for "Title".? Or, maybe I can be told what I need to clear out of this doclib.
Thanks,
Owen
12-12-2017 04:44 PM
The issue where column formatting breaks wrapping on the title field is a known issue - we've got the bug logged and hopefully a fix will be available soon.
@Owen Allen is that the issue you're talking about, or are you seeing your entire formatting JSON not persisting in some title columns?
12-12-2017 05:29 PM
It doesn't sound like the same bug.
I have no column formatting on the document library column named "Title", so the title text is displayed in one line and is cut-off by the column to the right.
I add the JSON script to apply word wrap (white-space), and hit Preview, the cells in the Title column wrap as desired.
I hit Save, and the cells in the column remain wrapped.
I can select diff rows in the view, the cells remain wrapped.
if I close the column formatting right hand panel, the cells in the Title column revert to a single line, eactly as they were prior to my typing/pasting in the JSON script.
i then reopen the column formatting panel, no script.
Happy to get more detail or give access to tenant for testing.
My work around is to create a new column of type single line text, copy content, remove "Title" column from view. (sigh) the things I do for clients.
03-05-2018 04:21 PM
Owen, we looked into this, and it seems that the Title field on Document Libraries (not lists) is typically marked as Sealed=true, which is likely why you weren't able to apply a format to it.
03-20-2018 11:54 AM
I'm currently trying to format the Name column of a document library so that its title wraps, but the title/name doesn't even appear with this JSON:
{
"elmType":"div",
"txtContent": "@currentField"
}
Is the title/name column unable to be formatted?
03-20-2018 11:56 AM
03-20-2018 12:07 PM
We are working on the ability to support Name now. This should be out in the next month. As for wrapping, let me follow up.
04-09-2018 02:02 PM
Any update on when column formatting will be available in the web part on modern pages?
04-17-2018 06:44 AM
05-09-2018 05:07 AM
Any news on this? Our Enterprise Company is waiting to have this really valuable feature soon...