Forum Discussion

LincolnDeMaris's avatar
Nov 02, 2017

Column formatting now rolling out to first release users

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.

  • Oliver Zeiser's avatar
    Oliver Zeiser
    Brass Contributor

    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?

    • Sunny Rajpal's avatar
      Sunny Rajpal
      Brass Contributor

      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.

      • LincolnDeMaris's avatar
        LincolnDeMaris
        Icon for Microsoft rankMicrosoft

        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.  

  • Stephen WALKER's avatar
    Stephen WALKER
    Copper Contributor

    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? 

    • LincolnDeMaris's avatar
      LincolnDeMaris
      Icon for Microsoft rankMicrosoft

      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?

      • Stephen WALKER's avatar
        Stephen WALKER
        Copper Contributor





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

  • Owen Allen's avatar
    Owen Allen
    Iron Contributor

    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

     

    • Deleted's avatar
      Deleted

      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.

       

      • Deleted's avatar
        Deleted

        Yep worked their also.

         

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

    • Owen Allen's avatar
      Owen Allen
      Iron Contributor

      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; jcgonzalezmartin

      • Deleted's avatar
        Deleted

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

Resources