Column formatting now rolling out to first release users

[Lincoln DeMaris]

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:

• My session from Ignite 2017 where I talk about many of the new capabilities in lists and libraries, including column formatting.  Skip to 29:50 to view the portion of the talk devoted to column formatting.
• Column formatting overview - a high level overview of the column formatting capability
• Column formatting reference documentation - complete technical documentation on the capabilities provided, including many samples that will help you get started
• Community sample repository - this is a Git repository where you can contribute useful samples that demonstrate how to use the feature, or accomplish common user scenarios.  We've seeded this repository with some of the samples from our reference documentation, and we're hoping to see lots of submissions from the community. 

We are very eager to hear your feedback on this feature, and hear your suggestions on how we can make it more useful.

[#2]

Yeah!!! Finally

[#3]

That's great news....

[#4]

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?

[#5]

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.

[#6]

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.  

[#7]

@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,

[#8]

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.

[#9]

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? 

[#10]

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]

below is the json im using, it does work (but not when I switch to classic sharepoint (lol), can you tell me how to alter this code snippet so that the cells background is red with white text in bold

{

"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": {
"operator": "?",
"operands": [
{
"operator": "<=",
"operands": [
"[$Alert_x0020_date]",
"@now"
]
},
"#ff0000",
""
]
}
}
}

[#12]

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",
""
]
}
}
}

[#13]

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

[#14]

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

[#15]

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.

[#16]

Yep worked their also.

I just clicked the preview first, then save. and the code was still there when I came back to it.

[#17]

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...?

[#18]

In my tests, it has worked as expected

[#19]

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

[#20]

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.

[#21]

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

[#22]

Owen, yes looks like you are right ... all other columns seem to work, just not the title column.

[#23]

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

[#24]

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?

[#25]

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.

[#26]

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.

[#27]

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?

[#28]

I found here that Filenames aren't supported: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#supporte...

Any timeline to support this column? How would one wrap the title of a file?

[#29]

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.

[#30]

Any update on when column formatting will be available in the web part on modern pages?

[#31]

I am waiting for this as well - any updates on when it will be available?

[#32]

Any news on this? Our Enterprise Company is waiting to have this really valuable feature soon...