Blog Post

Microsoft SharePoint Blog
5 MIN READ

Working with templates in Microsoft Lists

Mark-Kashman's avatar
Mark-Kashman
Icon for Microsoft rankMicrosoft
Jun 15, 2022

You can save a lot of time using templates when creating new Microsoft Lists. List templates, both ready-made ones and your own custom templates, help keep your information tracking consistent - being able to reuse templates to uniformly create a common set of columns, formatting, views, rules, and more - all within one click - saving you from having to always configure from scratch.

 

Join Chris Kent and me (Mark Kashman) as we share templating insights and walk you through numerous demos in this new video below, “The broad world of templates when using Microsoft Lists” – watch it all or use its six main YouTube chapters to jump to the section that most speaks to you. And aligned to the video, I highlight everything you see and hear in six sections below, along with more explanation and links to learn more about each aspect of list templates. 

 

 

Take a scroll and learn more about working with templates in Microsoft Lists.

 

Start from blank to learn what can be applied and created in a template

The best way to understand what list templates do, or are available for you to design into your own custom templates, is to learn the parts and pieces of what templates can create for you when you use them:

  • Columns | When you create a column for a list, you choose a column type that indicates the type of data that you want to store in the column, such as numbers only, formatted text, hyperlink, a choice column – templates support deploying any/all column types.
  • Views | You can create a view to save different sort, filter, and grouping selections you've made from the column headers or filters pane. The columns you've shown or hidden, and the column widths will also be saved with the view.
  • Formatting | You can use column, row, or view formatting to customize how lists are displayed. Think of this as color-coding specific fields/column or based on certain conditions. There is a lot you can do to configure and customize how your list data appears – and the real value is not having to do the same formatting over and over, just bake it into a list template and get on with the importance of tracking your information, the way you like to.
  • Rules | You can create rules to automate actions such as sending someone a notification when data changes in the list. You'll choose a condition that triggers the rule and the action that the rule will take. This, too, now includes the ability to include Power Automate flows as a part of what can get created and delivered by a list template.

Starting with a blank template is a great way to learn how to use Microsoft Lists, and to then understand what you can design into a template for the next list you create.

Learn more about getting started with Microsoft Lists – adding columns, creating views, adding rules, and more. I also created a video a little bit ago titled, “Microsoft Lists: The value of the Blank template”, that goes deeper into the beautiful abyss of the blank’ness of Lists around a specific scenario: A shareable list of resources :).

 

Ready-made templates

Microsoft’s built-in, ready-made templates help you create lists using pre-configured layouts that include columns, color formatting, and data structure. You can customize each list to fit your situation by changing the formatting to highlight important data, configuring forms to see more at a glance, and setting reminders to keep you and your team up to date on what’s happening. Our hope is that these templates will save you time and cover many of the common scenarios for using Microsoft Lists.

 

Choose from numerous ready-made templates available in Microsoft Lists as you click "New list."

Learn more about ready-made templates for Microsoft Lists in Microsoft 365.

 

Create a list from another list

When you need a consistent and reliable approach to creating similar lists, you can create one from an existing list – especially ones you’ve tweaked just the way you like ‘em. When you do this, the entire list structure is copied, including views, formatting, and columns. However, the actual content of the original list isn't copied.

 

Use the structure and formatting of another list to create a new list with the same schema. Above shows picking the list you wish to replicate in look and feel.

Learn more how to create a new list based on the columns in another list.

 

Design and deploy your own custom list templates

Sometimes you gotta roll up your sleeves and design what you need specific to your business. And with that, to be able to add it as a default template ‘from your organization’ that will be available to your peers and employees to use in your tenant – to save time and to organize and align with your preferred information tracking patterns.

 

Once you design the list characteristics to your preference, you then extract, package, and deploy the new using PowerShell.

Don’t miss Chris’ demo in the above video – using a great FAQs scenario – he goes into all the best practices for extracting the value from a list to create a custom, deployable list template.

Learn more about creating custom list templates. Note: You’ll need to be a global admin or SharePoint admin in Microsoft 365 and leverage the SharePoint Online Management Shell (built on top of PowerShell).

 

Microsoft 365 connected templates

One of the best things about SharePoint and Teams is how separately they provide world class collaboration, and when you combine them together that boundary disappears. With our newest Microsoft 365 connected templates, we are bringing both into one seamless creation flow – no matter where you start from.

 

Microsoft 365 templates combine Teams templates and SharePoint site templates - along with other app templates - so you more quickly, and consistently, start to your preference.

When we create this team using the template, the project management channels and apps, and the connected SharePoint template gets applied automatically. Critically, the pages, lists, and power platform integrations are pinned right here in Teams, and best of all these pages and lists are fully editable right in Teams.

 

This capability is not yet in production. You can track progress on “Microsoft 365 connected templates” on the Microsoft 365 public roadmap, ID: 82158. #ComingSoon

 

Lists MSA Preview - new consumer and small business-focused templates

Microsoft Lists – MSA Preview is a lightweight version of the Microsoft Lists app designed for small business and individual use in conjunction with your Microsoft account (MSA). It’s also a place where the team has deployed a few new list templates suitable for individuals and small businesses.

 

Two new templates only in the Lists – MSA Preview (as of June 2022):

  • Gift ideas | Easily organize your gift planning for your family & friends in one list and make gift buying and giving a breeze.
  • Expense tracker | Record all your personal and/or business expenses in one place.

When using lists.live.com (Microsoft Lists - MSA Preview), you'll see new templates in the updated create list experience; the two new ones we cover in the video are ton he bottom-right.

Expect more templates to be released, both for consumer and commercial use.

Learn more the Microsoft Lists – MSA Preview and try it today – go to lists.live.com: sign up, sign in and let us know what you think.

 

Final thoughts…

We hope you’ve learned more about the value of using and creating list templates – bringing to your own productivity and the time saving, organizational benefits they bring to your business. To learn more about Lists throughout the year, please visit our Microsoft Lists resource center for blogs, demos, help content, videos, podcasts, and more. Plus, jump into the value of Formatting samples in our PnP GitHub repository.

 

Thanks, Mark-Kashman & theChrisKent 

Updated Nov 09, 2023
Version 2.0
  • imorrish's avatar
    imorrish
    Copper Contributor

    Microsoft just delete all my listed I had created in lists.live.com 😞

  • Kim Williams's avatar
    Kim Williams
    Brass Contributor

    theChrisKent I am having an issue setting a Column Width for a Multiple Line Text Field with JSON for all users to see the desired width.  I saw you commented on a post saying there was a fix for this on github, but now I can't find it.  Is there a solution?

  • Astatke Belay's avatar
    Astatke Belay
    Copper Contributor

    TeriFeibel we have the same issue but was told by Microsoft as early as yesterday that the new ETA for this feature is early 2023. I suspect the below roadmap item entry might be the one that will fix the issue so that organization level custom list templates could show up in M365 tenants like mine and yours.  

     

  • TeriFeibel's avatar
    TeriFeibel
    Copper Contributor

    I am trying to use the new Microsoft List Templates, but I keep getting the error message

    "The requested operation is part of an experimental feature that is not supported in the current environment."

    Why could this be? How can I fix this?

  • Astatke Belay's avatar
    Astatke Belay
    Copper Contributor

    I just found out the right GUID for the Expense Tracker list template  is rather, 96d6dbe5-d7c3-030a-867a-0b72eb0ff1ce

  • Astatke Belay's avatar
    Astatke Belay
    Copper Contributor

    Thank you Chris Kent for answering this on Twitter:

    Gift Ideas: 008f8143-9644-0238-b4b5-c03e4f0ff1ce
    Recipe Tracker: a1755e7d-8e3a-4141-89fc-6c77eb0ff1ce
    Expense Tracker: 96D6DBE5-D7C3-430A-867A-0B72EB4065AB

  • Astatke Belay's avatar
    Astatke Belay
    Copper Contributor

    Thank you for the excellent updates on this. I have one question though.

     

    I work for big government enterprise IT and we have a policy where we disable and enable Microsoft custom lists as required from our tenant. In doing so, it was great Microsoft is providing Template IDs of these templates so that we can do our job via PowerShell.

     

    Having said that, I don't see the template ID of the so called MSA list templates (specifically Gift Ideas, Expense tracker and Recipe tracker) any where, which is making our job a bit difficult. Would you mind publishing template IDs of all your custom list templates? 

  • Mark-Kashman I really  love lists, but

     

    I am missing a feedback button, why?

     

    I would like to share some suggestions for improvement, i.e.

    Once you make a mistake in rules you can only switch it off in manage rules. However it is a wrong rule. In that case I just want to remove it, but that isn't an option. (yet?)

     

    Therefore if you add a feedback button in lists it is very easy for Microsoft to collect information about bugs an improvements

    Kind regards,

    André