how to MS SharePoint

A Complete Guide to Microsoft List and Library Formatting

David Francoeur April 19, 2022


With two pillars of SharePoint Content Management, Lists and Document Libraries, we now have much more control over how our content is displayed and how users interact with it. While this functionality is desirable to many, it can be difficult to know how to get started and what resources exist to make sure you are not fumbling in the dark.

Elevate SharePoint Content Management with Formatting Support

Gone are the days when SharePoint Lists and Libraries made for a dull and boring experience.

Today, we not only can choose from improved pre-configured formatting but also the recently released Board View, we can also tweak these existing layouts or go even further and apply custom formatting.

Historically there have been some formatting functionality that was released first to Lists before it was available in Libraries; but today, both share similar formatting support. One notable exception is the new Board View, which is only available in Lists.

Another note for those wondering about how Microsoft Lists may fit into this conversation: as far as this conversation is concerned, it is not important whether your list is stored in SharePoint or whether it exists as a stand-alone resource – they both utilize the same underlying framework.

To introduce the concept of formatting, it is useful to begin first by defining the core concepts of Document Libraries and Lists. We will then discuss some of the reasons you may want to consider formatting. Finally, we’ll review the high-level areas that support formatting today: Column Formatting, View Formatting, and Form Formatting.

Content Management in SharePoint Lists and Libraries

Lists and Libraries are containers for information within Microsoft 365 and SharePoint. These two main “types” of containers have existed for years, but some still find the differentiation confusing.

A Document Library is in essence a “supercharged” folder that is intended to house and manage files such as Documents (PDF, Word, Excel, etc.) and other file types like Photos, CAD Drawings, and much more. In fact, the types of files that you would traditionally never store in a Document Library, such as videos, are diminishing to fewer and fewer use cases. While all file types are now supported in SharePoint 2019 and Online, this does not mean that all file types should automatically be stored in Document Libraries.

Lists, in contrast, do not inherently store files but rather store data or information. Each individual piece of data is called a List Item. Lists are great ways to store a wide variety of content such as Risks, Issues, Tasks, and so much more. Where some confusion can emerge is that Lists do support the ability to attach files to individual List items.

Sharepoint content management - Lists vs Libraries

How Formatting Can Simplify SharePoint Content Management

Formatting isn’t just about style, though that certainly has its own merits! User experience research in web design has repeatedly shown that we should employ techniques to make information more easily scannable.

Carefully applying style can also help apply a visual hierarchy to our information, drawing our user’s attention to the most important information and de-prioritizing any supporting information. A good schematic of this principle was laid out by Microsoft and Nielsen Norman:

Sharepoint content management - Visual Hierarchy
Reference: Microsoft: Building a beautifully designed intranet with SharePoint (latest design and branding capabilities)

Other advantages of formatting include creating layouts that better suit the type of information being presented. For instance, imagine laying out Images, Tasks, and Documents in a single rigid fashion. Clearly there are ways to display Images (such as a Tile or Gallery layout) that could be tailored differently than Tasks (such as a Kanban layout).

By leveling up the formatting of our list and libraries we also incentivize new users with a more modern and appealing user experience, and thereby simplify our change management and adoption efforts.

Sharepoint content management - How Formatting Helps

Types of Formatting

There are a few different areas where we could apply custom formatting, and it is useful to split these out and understand how each has a role to play. In some cases, you may want to consider getting started in only one area before exploring remaining options that introduce more complexity or have a broader impact.

Sharepoint content management - Types of Formatting

Column Formatting

Columns represent the “Fields” in our Lists and Libraries – the vertical segments of information. A good equivalent concept is Column Headers in an Excel Spreadsheet, in which each Column contains a different type of information. One column may contain a list of Products, while another may contain the Prices for each product. In the example below, we have a number of columns to house information that, together, make up a Risk Register.

Sharepoint content management - Columns

With Column Formatting, Lists and Libraries now have certain preconfigured “suggested” formats that appear by default, depending on the type of column selected. For instance, when creating a choice column, we now get defaulted to a simple colour-coded “Choice Pills” format:

Sharepoint content management - Column Formatter

Column formatting is a good place to start, even if that means beginning with editing some of the preconfigured styles such as the choice pills. For instance, using the intuitive visual editor, you can modify the preliminary styles to something a little bit more interesting and relevant to your situation.

Sharepoint content management - Changing Style

When column formatting is applied across several columns, it can transform the entire visual experience and make a list feel more modern and dynamic. There are opportunities to make information more meaningful across different types of columns, such as showing a User with both their Profile Photo and their Name, a Due Date that is formatted when it is overdue, and numerical columns that are transformed into image-based indicators. When combined, these effects make the list content more scannable and easier for users to consume. Compare the two versions below:

Sharepoint content management - Transformation

While this blog will not attempt to cover all the possible ways to format a column, another very useful example of column formatting is to embed actions in line with the list content itself.

This can be tremendously useful for triggering things like Power Automate Workflows as the user experience to do this can otherwise be harder to locate. For instance, in the example below, we’ve created a Workflow that allows the Project Manager to elect to Promote an Active Risk into an Active Issue, by moving the content from one list to another and vice versa.

Sharepoint content management - Risk Register

In another example, we’ve used formatting to allow metadata modification directly in line with the content itself. This saves users a step of moving into Quick Edit or opening the properties panel to modify the metadata. This is especially valuable in Lists or Libraries where certain values are frequently updated. In our Policy Library below, we have a Last Published Date that we want to update frequently and by using formatting the contributors can simply click a button to update the date.

Sharepoint content management - Last Published

If you’re looking for inspiration, a great place to look and even copy and paste code from community examples is the PnP Column Samples in GitHub as well as the other resources below.

Sharepoint content management - Column Formatting Samples


  • A good place to dabble in formatting is at the Column level, as it is a localized change to a single column and can easily be reverted.
  • Apply formatting but try to use consistent patterns for similar columns. Human brains rely on Spatial Memory to reduce cognitive burden and complete tasks more efficiently. For users to be able to develop spatial memory, they require stable UIs where things don’t move around (much).
  • Consider using Workflow Launch buttons to make it more obvious how to trigger automation.
  • Use bars, charts, or iconography to simplify the consumption of numerical fields.

Useful Resources

View Formatting

While the ability to create custom Views within our Lists and Libraries is far from new, there are some interesting new options available for SharePoint content management. In contrast to Column Formatting where your styling will apply to a single column or field, View Formatting applies the stylistic change to the entire List or Library. When creating a New View from a List, you get several pre-built options to get you started.

Libraries offer the same initial options, apart from the Board View, which you’ll only find on Lists.

The Card Designer available when using the pre-set Gallery view can be very useful as it gives you an intuitive configuration experience to select what you want to show on your cards. If you’ve ever wanted to display your documents or list items as cards, now you can with no code!

Sharepoint content management - Create Card View

In another example, the View below can be achieved simply by tweaking the configuration to make a Library of Images much more interesting and informative.

Sharepoint content management - Gallery View

As mentioned earlier, Microsoft has recently released a new Board view for Lists, which gives us a Kanban-like layout for organizing our list items, and even facilitates moving them between columns by dragging and dropping.

Sharepoint content management - Board View

Much like Column Formatting, these formats can also be tweaked to your own needs, and there are quite a few use cases to consider, from accordions used to expand and collapse a list of FAQs, to tile-based buttons with iconography, to Gantt charts, to complex hover effects displaying additional metadata, and even timeline-based views. There’s even a quite amazing sample by João Ferreira that closely replicates the user experience of To Do in a SharePoint List.

Another interesting scenario is to have the formatting utilize conditional logic to only show information based on values in other columns, or based on the current user viewing the information. Using this technique, we can easily create a personalized experience for end users.

Sharepoint content management - View Formatting

Many teams find the ‘Grouping’ functionality useful in Views, which introduces the ability to expand and collapse groups of information and avoids the use of Folders. Formatting can be applied to adjust the look and feel of the groupings, adding colors, iconography, and even removing the annoyingly repetitive column name label at the beginning of every grouping!

Sharepoint content management - Group Formatting

A more recent addition is the ability to use View Formatting to configure the List or Library Action Bar. This can be used to hide or show certain actions, move their order, change their text, tooltip, or associated icon, and define in what part of the bar the actions appear. One useful way to use this new function is to make it even simpler for users to create certain document type, and removing additional actions that are not frequently used.

Sharepoint content management - Command Bar

Critically, this function does not yet seem to allow for adding buttons to create Content Types.

Once again, if you’re looking for examples to get you started, there’s no better place than the many community examples found within the PnP Column Samples.

Sharepoint content management - View Formatting Samples


  • A good place to experiment with View formatting is with the new Card Designer.
  • Consider creating views that are personalized using conditional logic.
  • As before, experiment with different ways to visualize your information that makes it easier to consume for end users but try to use consistent patterns for similar lists and libraries.
  • Use Command Bar formatting with caution as inconsistent action bars throughout several lists and libraries will cause confusion for end users.

Useful Resources

Form Formatting

The SharePoint New and Edit Form has been around from the early days of SharePoint and provides a form-based experience to populate new Items and edit properties for existing Items. While Grid View (previously Quick Edit and many years ago known as “DataSheet View”) provides a powerful means to edit your Document or List Item properties, the SharePoint Edit Form remains the primary and traditional means by which to view and edit metadata.

When un-customized, the form will display all the existing List or Library metadata. One of the simplest things to do is to hide or show a subset of columns. This ability is not new but useful to reduce the amount of ‘noise’ displayed to end users if not all fields require attention. To do this in the modern experience, open the Form panel, and click the ‘modify’ drop-down, followed by Edit Columns. From here, toggle the visibility of fields to on or off. Note: If Content Types are in play, the display can be modified within the Content Type configuration. In the example below, we’ve chosen to hide the Project Manager Notes field from all users, as well as a Promote to Issue field which is used to launch an attached workflow from the List View.

Sharepoint content management - Edit Columns

One interesting new option is the ability to apply conditional logic to determine whether fields are displayed. This opens possibilities beyond a global on or off, but only shows the field in certain situations, such as if the current user needs to see that field, or whether it should only be shown dependent on values in other fields. In the example below, we can now display the Project Manager Notes field, but only to the Project Manager. We can also only show a Mitigation Plan field if the Impact or Probability levels are three or greater.

Sharepoint content management - Conditional Form

Once the unquestioned territory of PowerApps alone, we can now perform some configuration to modify the appearance of the form as well, including applying styling to the form Header, Footer, and Body. This gives us the ability to apply a more interesting Header to all items in the List or Library, as well as a potentially more tailored footer. In the body, we can also group related metadata into “sections”, which can add an enormous amount of context to the editing experience.

Sharepoint content management - Form Formatting


  • A good place to experiment with Form formatting is to consider fields that need not be displayed in the form in all scenarios and apply conditional logic to determine whether they are visible.
  • Similarly, if you have cases where you are capturing a significant amount of metadata, consider putting the metadata into sections to streamline the population process for content authors.

Useful Resources

Tailor User Experience with SharePoint Content Management

An often-overlooked element of the SharePoint content management experience is the power we have as Site Owners to tailor the user experience in our List and Libraries. With recent innovations that extend the areas that can now be formatted, as well as the introduction of new interfaces to make changes with little to no code, there is no better time to level up your SharePoint content management using formatting!

These efforts can not only make our List and Libraries more visually attractive but also offer a host of other benefits that make content more easily consumable by end users. These investments can also be realized on multiple fronts, especially if these Lists and Libraries are later integrated into Microsoft Teams to improve the collaboration experience from a single application layer.

About the Author

David Francoeur Image

David Francoeur

Orchestry Director of Product Delivery

As a speaker, author, and consultant operating across industries, David brings to Orchestry a diversified perspective on solving problems in the Digital Workplace. Working cross-functionally to guide products from conception to launch, he carefully connects the technical and business worlds. Passionate about user experience and design, David thrives on outcomes that are not only successful from a technological perspective but more critically; adopted, championed, and valued by the business.

Beyond his passion for the digital workplace, David enjoys spending time with his spouse and daughter, playing soccer, or reading a good book.


This Privacy Policy explains what information Orchestry Software Inc. and its associated entities (collectively “Orchestry”) collect about you, why, what we do with that information, how we share it and how we handle the content you place in our products and services. It also explains the choices available to you regarding our use of your personal information and how you can access and update this information.

Privacy Policy Scope

Our Privacy Policy applies to the information we collect when you use one of our services, or when you otherwise engage with Orchestry Software, including, but not limited to:
when you visit our websites (“Websites“);
when you contact us for assistance;
when we connect with you as a prospective customer or as a customer;
when you attend customer or prospective customer events;
when you meet us at third party events, gatherings or meetups.
Orchestry is committed to protecting your privacy. This Privacy Policy applies to our websites (Websites), including, and, owned and controlled by Orchestry.

This Privacy Policy governs our data collection, processing and usage practices. It also describes your choices regarding use, access and correction of your personal information. By using the Websites, you consent to the data practices described in this Privacy Policy. If you do not agree with the data practices described in this Privacy Policy, you should not use the Websites.

Information We Collect

We collect personal data that you submit to us via our website or third-party tools including, for example, when applying for a job via our website or requesting support in relation to one of our services.
You are free to explore the Websites without providing any Personal Information about yourself. When you visit the Websites, we request that you provide Personal Information about yourself, and we collect Navigational Information.

Information Collection & Access

Orchestry acknowledges that you have the right to access your Personal Information. If requested to remove data we will respond within a reasonable timeframe.

We may transfer Personal Information to companies that help us provide our service, such as those organizations as part of our Global Partner Alliance. Transfers to subsequent third parties for the sole purpose of responding to requests from Websites in the appropriate geography service territory.

“Personal Information”
This refers to any information that you voluntarily submit to us and that identifies you personally, including contact information, such as your name, e-mail address, company name, address, phone number, and other information about yourself or your business. Personal Information can also include information that you enter into on the Websites, and information about you that is available on the internet, such as from Facebook, LinkedIn, Twitter and Google, or publicly available information that we acquire from service providers.

“Navigational Information”
This refers to information about your computer and your visits to this website such as your IP address, geographical location, browser type, referral source, length of visit and pages viewed.

We use Navigational Information to operate and improve the Websites. We may also use Navigational Information alone or in combination with Personal Information to provide you with personalized information about Orchestry.

Information About Children

The Websites are not intended for or targeted at children under 13, and we do not knowingly or intentionally collect information about children under 13. If you believe that we have collected information about a child under 13, please contact us at, so that we may delete the information.

Information Usage

We use the information we collect only in compliance with this Privacy Policy.

In addition to the uses identified elsewhere in this Privacy Policy, we may use your Personal Information to: (a) improve your browsing experience by personalizing the Websites; (b) send information to you which we think may be of interest to you by post, email, or other means; (c) send you marketing communications relating to our business.

We will never sell your Personal Information to any third party. However, we may share or disclose your Personal Information as follows:
we may provide your information to our business partners, vendors or service providers who perform functions on our behalf;
in connection with, or during negotiations of, any merger, sale of company assets, financing, or acquisition of all or a portion of our business to another company;
as required by law, government officials, or other third parties pursuant to a subpoena, court order, or other legal process or requirement applicable to our Company;
when we believe, in our sole discretion, that the disclosure of personal information is necessary to prevent physical harm or financial loss;
to report suspected illegal activity or to investigate violations of our agreements.

Reviewing, Correcting and Removing Your Personal Information
Upon request, Orchestry will provide you with information about whether we hold any of your Personal Information. If you provide us with your Personal Information, you have the following rights with respect to that information:
To review the user information that you have supplied to us.
To request that we correct any errors, outdated information, or omissions in user information that you have supplied to us.
To request that your user information not be used to contact you.
To request that your user information be removed from any solicitation list that we use.
To request that your user information be deleted from our records.
To opt out of being solicited by Orchestry or third parties.

To exercise any of these rights, please contact us at or by mail to Orchestry Software Inc., 422 Richards St, Suite 170, Vancouver, BC V6Z 2Z4, Attn: Privacy. We will respond to your request to change, correct, or delete your information within a reasonable timeframe and notify you of the action we have taken.

Retention of Personal Information

We retain Personal Information that you provide us as long as we consider it potentially useful in contacting you our services, or as needed to comply with our legal obligations, resolve disputes and enforce our agreements, and then we securely delete the information. We will delete this information from the servers at an earlier date if you so request, as described in “Unsubscribe from Communication” below.

Customer Testimonials and Comments

We post customer testimonials and comments on our Websites, which may contain Personal Information. We obtain each customer’s consent via email prior to posting the customer’s name and testimonial.

Security of your Personal Information

We use a variety of security technologies and procedures to help protect your Personal Information from unauthorized access, use or disclosure. We secure the Personal Information you provide on computer servers in a controlled, secure environment, protected from unauthorized access, use or disclosure.

Social Media Features

Our Websites include Social Media Features, such as the Facebook Like button and Widgets, such as the Share This button or interactive mini-programs that run on our sites. These features may collect your IP address, which page you are visiting on our sites, and may set a cookie to enable the feature to function properly. Social Media Features and Widgets are either hosted by a third party or hosted directly on our Websites. This Privacy Policy does not apply to these features.  Your interactions with these features are governed by the privacy policy and other policies of the companies providing them.

External Websites

Our Websites provide links to other websites. We do not control, and are not responsible for, the content or practices of these other websites. Our provision of such links does not constitute our endorsement of these other websites, their content, their owners, or their practices. This Privacy Policy does not apply to these other websites, which are subject to any privacy and other policies they may have.

Public Forums

We offer publicly accessible blogs, message boards and community forums. Please keep in mind that if you directly disclose any information through our public message boards, blogs, or forums, this information may be collected and used by others. We will correct or delete any information you have posted on the Websites if you so request, as described in “Opting Out and Unsubscribing” below.

International Transfer of Information

To facilitate our global operations, we may transfer and access Personal Information from around the world, including the United States. This Privacy Policy shall apply even if we transfer Personal Information to other countries.

Corporate Events

If we (or our assets) are acquired by another company, whether by merger, acquisition, bankruptcy or otherwise, that company would receive all information gathered by Orchestry on the Websites. In this event, you will be notified via email and/or a prominent notice on our website, of any change in ownership, uses of your Personal Information, and choices you may have regarding your Personal Information.

Cookies & Similar Technologies

Orchestry uses cookies or similar technologies to analyze trends, administer the website, track users’ movements around the website, and to gather demographic information about our user base as a whole.

The cookies we use on this website are broadly grouped into the following categories:

Essential: Some of the cookies on our website are essential for us to be able to provide you with a service you have requested. You may not be able to use our website effectively without these cookies.
Analytics: We use analytics cookies to help us understand how users engage with our website. An example of this is for counting the number of different people coming to our website, visiting a particular page or using a particular feature. Without this cookie, if you visited the website once each week for three weeks, we would count you as three separate users and this wouldn’t be a true representation. These cookies do not let us identify specific users as the information is aggregated.
Social sharing: We use cookies to allow you to share content directly to your social networking sites for example Facebook, Twitter and Google+ i.e. clicking Like on Facebook and Share on Twitter.
Interest-based advertising: You may have noticed that when you visit websites, you will be shown advertisements for products and services you may be interested in. Cookie information about certain pages you have visited on our website helps us be more relevant in our advertising. Having these cookies does not increase the number of adverts you will be shown on these specific sites. These ‘persistent’ cookies last no longer than 90 days, or until you clear them. These and the other cookies we use do NOT allow us to see what other sites you have been visiting, they simply act as a record of our web pages and advertisements that you may see.
Opt Out of Cookies
When you first visited the websites you will have been shown a status bar notifying you that this website uses cookies and inviting you to review this cookie policy. Once you have clicked to go further into our website, the cookie prompt will disappear, this confirms that you consent to us using the cookies detailed in this policy.
Please note that we can’t always control third party cookies (such as from social networks) stored on your machine from our website and where this is the case you will need to visit the relevant third party’s website directly to understand their cookies stored on your machine by them. Please see our ‘third party cookies’ section below.
If you want to reject cookies we use from this website you will need to:
Delete the cookies from your browser. Most browsers also allow you to prevent all or some cookies being stored on your machine in the future. For more information on how to delete or disable cookies from your browser please use the ‘help’ function within your browser, or alternatively visit By deleting our cookie preference cookie, the next time you visit our website the cookie status bar will appear again inviting you to again reconsider your preferences.
AND/OR: If you only want to reject the Internet Based Advertising cookies we store on your machine, you can opt-out of receiving these cookies at any time by going to the Internet Advertising Bureau website at and following the opt-out instructions.
Please do be aware that disabling cookies may impact the functionality of this website.
Third Party Cookies
Some of the cookies described above are stored on your machine by third parties when you use our website. We have no control over these cookies of how the third party uses them. They are used to allow that third party to provide a service to us, for example website analytics. For more information on these cookies and how to disable them, please see:
Internet Advertising Bureau website at where you will be able to opt-out of receiving Internet Based Advertising cookies from some of the third parties, such as Google, LinkedIn, Facebook and Twitter.
The use of cookies and web beacons by any tracking utility company is not covered by our Privacy Policy.

Log Files

We may collect demographic information, such as your region, preferences, interests and favorites using log files that are not associated with your name or other personal information. There is also information about your computer hardware and software that is automatically collected by us. This information can include: your IP address, browser type, domain names, internet service provider (ISP), the files viewed on our site (e.g., HTML pages, graphics, etc.), operating system, clickstream data, access times and referring website addresses. This information is used by Orchestry to provide general statistics regarding use of the Websites. For these purposes, we do link this automatically-collected data to Personal Information such as name, email address, address, and phone number.

Clear Gifs (Web Beacons/Web Bugs)

We employ a software technology called clear gifs (a.k.a. Web Beacons/Web Bugs), that help us better manage the Website by informing us what content is effective. Clear gifs are tiny graphics with a unique identifier, similar in function to cookies, and are used to track the online movements of Web users.  In contrast to cookies, which are stored on a user’s computer hard drive, clear gifs are embedded invisibly on Web pages or in emails and are about the size of the period at the end of this sentence. We use clear gifs in our HTML-based emails to let us know which emails have been opened by recipients.  This allows us to gauge the effectiveness of certain communications and the effectiveness of our marketing campaigns. We tie the information gathered by clear gifs in emails to our customers’ Personal Information. If you would like to opt-out of these emails, please see “Opting Out and Unsubscribing”.


We partner with a third-party ad network to either display advertising on our Web site or to manage our advertising on other sites. Our ad network partner uses cookies and Web beacons to collect non-personal information about your activities on this and other Web sites to provide you targeted advertising based upon your interests.  If you wish to not have this information used for the purpose of serving you targeted ads, you may opt-out by clicking here: (or if located in the European Union, by clicking here: Please note this does not opt you out of being served advertising.  You will continue to receive generic ads.

Unsubscribe from Communications

You may unsubscribe from our marketing communications by clicking on the “unsubscribe” link located on the bottom of our e-mails, or by sending us email us at or by mail to Orchestry Software Inc., 422 Richards St, Suite 170, Vancouver, BC V6Z 2Z4, Attn: Privacy.

Contact Us

If you have any questions about this Privacy Policy or our treatment of the information you provide us, please write to us by email at or by mail to Orchestry Software Inc., 422 Richards St, Suite 170, Vancouver, BC V6Z 2Z4, Attn: Privacy.


We may amend this Privacy Policy from time to time. When there are changes to this Privacy Policy, we will update this page. The date on the bottom will always indicate when we last made changes.
Last Updated: July 28, 2020

Step 1 of 4

  • Congratulations...

    Congratulatons, you are taking the first step to making work simple in Microsoft 365, Microsoft Teams & SharePoint. Complete this form to see Orchestry in action with a FREE personalized tour of the platform.

In completing this form, you are providing your contact information to Orchestry Software Inc to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.

Step 1 of 4

  • Congratulations...

    Congratulations, you are taking the first step to making work simple in Microsoft 365, Microsoft Teams & SharePoint. Complete this form to get started with FREE access to Orchestry for 28-days

In completing this form, you are providing your contact information to Orchestry Software Inc to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.

Step 1 of 3

  • Congratulations...

    Congratulations, you are taking the first step to join the global Orchestry Partner community, making work simpler in Microsoft 365.

In completing this form, you are providing your contact information to Orchestry Software Inc to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.