Back
SharePoint

Modern SharePoint lists are here—including integration with Microsoft Flow and PowerApps

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Earlier this year, we unveiled a new cloud-first, mobile-first vision and roadmap for SharePoint, which included innovations that empower people, teams and organizations to intelligently discover, share and collaborate on content from anywhere and on any device. Today, we’re pleased to announce the rollout of modern SharePoint lists to SharePoint Online, along with one-click integration of PowerApps and Microsoft Flow. These enhancements will begin rolling out to Office 365 First Release customers the first week in August 2016.

What’s new with modern SharePoint lists

Modern SharePoint lists provide a powerful way for people to collaborate on structured data directly from their team site to help teams organize content—such as investment account onboarding details, field service requests or even softball team T-shirt sizes. Over ten million custom lists are already in use across Office 365.

Now, we’re delivering a modern list experience that looks great and is responsive, accessible and easy to use on any device. The modern SharePoint list experience will be automatically available to all existing classic SharePoint Online lists.

With modern SharePoint lists you can:

  • Improve ease of use by empowering users to add columns to lists and sort, filter and group data in place.
  • Elevate data quality by viewing and editing all item details in the information panel without leaving the list.
  • Improve productivity by bulk editing list items with Quick Edit.
  • Automate simple business processes with versions, approvals and alerts.
  • Enrich static information with rich data types including people, images and managed metadata tags.

Modern SharePoint lists are here 1

Modern SharePoint lists in the information panel.

In addition, modern SharePoint lists look great on the SharePoint mobile app—making every location and every device a first-class component of business processes.

Modern SharePoint lists are here 2

Editing list items in SharePoint mobile browser.

Modern and classic SharePoint list experience

Almost all SharePoint classic lists will automatically inherit the new modern SharePoint list interface. Modern SharePoint lists support the themes, navigation and custom buttons that were created in classic mode. We monitor the compatibility of customizations every time a user visits a list. If we see a compatibility blocker—like an unsupported browser or JSLink customizations—the list automatically reverts to the classic experience. Users can choose to revert to the classic experience at any time, and administrators can configure classic experience as default at the list, site, site collection or tenant level. And rest assured—we have no plans to remove classic mode anytime soon. Classic mode supports your customizations today and tomorrow. Looking forward, we’re going to continue to develop rich customization scenarios for modern experiences along with the SharePoint Framework.

Integrating PowerApps and Microsoft Flow

Customers regularly exchange data between SharePoint lists and other systems to support business processes. These scenarios become more powerful with deep integration of Microsoft Flow with SharePoint modern lists. Flow automates workflow and data exchange between SharePoint and a variety of Microsoft and third-party services. Now, you can create and launch Flows directly from a SharePoint list and store and modify that data within SharePoint.

With PowerApps, you can connect, create and share business apps on any device in minutes. You can build efficient mobile forms and apps directly from a SharePoint list, without needing to write code. PowerApps and Flow share a common connector framework that allows you to weave in dozens of data sources on-premises and in the cloud, including Exchange, SQL, Dynamics, Salesforce, Google, Mail Chimp, Twitter, Wunderlist and more.

Modern SharePoint lists are here 3

Building a PowerApp from a modern SharePoint list.

Modern SharePoint lists are here 4

Set up a new Flow from SharePoint.

Modern SharePoint lists are here 5

Automatically build a new Flow from SharePoint.

Flow and PowerApps are both currently in public preview.

To learn more about PowerApps and Flow integration, watch this video:

What’s next?

The initial rollout of modern SharePoint lists to First Release customers will be in early August 2016. After that, we will add PowerApps and Flow to the command bar. With Office 365 groups all receiving full team sites soon, even more users than ever will have access to our business app tools. We will have even more to show at Microsoft Ignite this fall in Atlanta.

Early preview of modern SharePoint lists

We recognize that customers want to validate these modern SharePoint list experiences for potential impact to users, training, customizations, or third-party solutions. Starting today, we are providing an early preview of the modern SharePoint list experience ahead of First Release and we look forward to your feedback.

See the Office 365 Network for details about how to enable early preview of modern lists.

—Chris McNulty, senior product manager for the SharePoint team

Top
37 comments
  1. Looks good, but the $64,000 question is “does it support having a view with more than 5,000 items”?

  2. Nice improvement that plays well with new doc libraries, but when does it get rolled out beyond First Release? And unlike what I had to deal with for doc libraries, the new experience should default to admins choosing to opt in. I was unpleasantly surprised to find myself opting out of the new doc libraries when they finally rolled out. I had no option to turn them off ahead of them reaching my tenant.

    • You can always optout before release – the admin controls are available in all tenants at all stages of rollout, First Release and Production. Production rollout should be complete by the end of Q3 CY2016. Thanks!

  3. Love the new custom list template and the opt out feature but not being able to enforce control over the tenant BEFORE features are deployed will be a major blocker for our 1500 user business from going cloud. This ‘deploy to everyone’ policy is going to kill Office 365 from being a solution for the middle end of town.

    We only need a couple weeks to a month to allow these significant changes to be validated through our change control processes. Note here that our intranet (like many others) is not owned by the Technology division but rather by the business. They don’t like being told that they suddenly have to spend their shrinking budgets on remedial development to fix a problem that Microsoft has introduced. Microsoft! You’re give IT a bad name. We’ve worked hard to build a working relationship with our business users only for you to ruin all that hard work.

    The alternative of going private cloud has not financial benefits as we’re still having to run a data centre only its now in the cloud. We still need server engineers to look after the servers. Only Office 365 means that we don’t have to worry about the OS and hardware management. Sure we expect to loose some control but if you already allow users to opt out after the fact for lists, sites and site collections what is the difference to making this opt in across the board? Especially for the top tiers.

  4. So many words and you don’t answer the one question everyone is interested in: Does this remove the extremely silly limit of 5000 items in a list? Otherwise I don’t really see the point of doing all this. SharePoint lists are basically unusable because of that limit.

    Whoever even thought that was a good idea? That limit is so ridiculously low, I’d understand if it were 100,000 or even 50,000 – but 5000 is inexcusable.

    • Modern lists are one of the steps along the way to lifting that query limitation. We don’t have a timeline to share yet, but it is actively being worked on. Thanks.

  5. The new UI for lists is very nice path away from folders, the new list and library modern UI nake it easier to use columns and metadata. This would make it possible to create views that are handling the limit of displaying more than 5 000 items.

    SharePoint lists and libraries do allow to store a lot more than 5 000 items. The limit is to view more items than 5 000.

    Every list and library is a SQL table, when the list and library is displayed are the table locked. If the view would contain more than 5 000 items more would be locked. Microsoft could raise the limit but it would create higher response times and delays for the users.

    SharePoint is not a replacement for a file server, the use of SharePoint features such as list views by sorting, filtering and grouping can make it possible to have lists with more than 5 000 items.

    A good source for SharePoint limits and best practice is to be found at https://support.office.com/en-us/article/SharePoint-Server-2016-Help-a95922df-83bb-466c-a9fb-11e576d9363d

  6. Will you be bringing back the ability to export to Excel for both modern doc libraries and lists?

    • It never stopped – however, there’s a bug in Chrome we’re tying to work around, and have hidden the Excel button in the interim wince Chrome doesn’t work as expected. Thanks.

      • Excellent–I look forward to the return of this feature. Prior to SharePoint, some of our users were creating these types of tables/spreadsheets manually (sometimes taking hours!), and it’s always fun to watch their reaction to seeing this feature for the first time. 🙂

  7. Is the Connect to Outlook feature still available with this new document library experience?

  8. Is the Connect to Outlook feature still available with this new Document Library experience?

  9. Could we have Flows tied to the list, rather than tied to the user? Having Flows tied to the user who created the Flow makes Flow very hard to manage and support.

    • This is a feedback request we’ve already heard, and are working through these and other related features for Flow manageability and shareabilty. We don’t have timeframes to share, but we very much want to extend Flow to cover those scenarios too. Thanks.

  10. When will the modern lists be available for on premises customers?

    • While we haven’t determined specific fe3atuires and timelines yet, we are looking to bring many of our clo0ud experiences and innovations to on premises SharePoint 20-16 via Feature Packs, coming in 2017. Thanks..

      • While we haven’t determined specific features and timelines yet, we are looking to bring many of our cloud experiences, and innovations to on premises SharePoint 2016 via Feature Packs, coming in 2017. Thanks

  11. Will this allow a new Form solution instead of InfoPath? With Power Apps it appears we can create Mobile Forms, but what about browser forms?

    • Bring PowerApps into the SharePoint page experience is very much a part of the roadmap that we plan to rollout later this year.

  12. As much as we like the functionality of the new document libraries and feel it’s more intuitive, our managed navigation no longer works. We are using term sets and managed metadata to provide consistent navigation with drop down menus. The place on the page it used to display is now taken up by the new menu bar. What are customers to do that were using managed navigation now that this area of the page is off limits?

    • I am in this predicament as well, can a Moderator specifically address this gentleman’s question?

      • We are continuing to work on enabling custom navigation customizations for the modern experience – no public timeline yet but its actively being worked. In the meantime, all customizations to classic mode remain supported, so that’s the best guidance until we turn on modern navigation. Thanks!

  13. Looks good. A nice enhancement based on customer productivity along with great features. Keep it up.

    • Thanks very much for the feedback – more innovations are coming soon.

  14. When will the tools be available to customize the new interface. I have implemented custom navigation on a clients tenant that doesn’t show up in the new UI.

    Thanks,

    John

  15. Nice, but is the Connect to Outlook feature still available with this new list experience?

    • Today, linking to Outlook requires the classic experience. But we’d welcome a chance to learn more about the scenarios where this is still needed at sharepoint.uservoice.com. Thanks!

      • Think of the following scenario:
        – customer gets copy of project file folders in including mails (single msg files)
        – colleagues put mails in SharePoint via connected library in Outlook

    • As we announced on May 4, we are planning to release many of our cloud innovations to SharePoint 20-16 next year as feature packs. We hope to have more to share about the timing and substance of feature packs later this year. Thank you.

  16. The new UI looks nice for lists that have only a few columns. What about lists with 20+ fields? What is the future of Infopath with the new UI? We use Info Path to create more efficient data entry views beyond the one field per line automated design. Would these views be compatible?

    • I think you have a few options in that case. First, you don’t need to show all the columns in a given view – but all that data is accessible in the full item view AND in the info pane;.

      Second, you can build a PowerApp form for the data as well. PowerApps are not a replacement for everything InfoPath does, and are still in preview, but have a very promising future as a great means to deliver business process and business apps inside Office 365.

  17. I like what you have done for the most part. Two issues that I see and that I hope will be corrected soon.

    Column Widths – We have a list the the first column is an IP address and on the Classic Experience the column was perfectly sized to fit the 12 character width. In the New Experience the width looks like it sized at 50 characters, takes up way too much space with nothing, and will not stay the width when it is resized. Please fix.

    Row Height – On our Help Desk, in the Classic Experience you could have a column that showed all of the text in the field. This way you could quickly scroll down the list and see the information. In the New Experience the row are limited to just 5 lines, so to be able to see the information, each item has to opened , closed, the scroll down to the next item. That is a big waste of time. Please fix.

    I realize some instances where this would be good. How about a check box to let us decide?

  18. Looks good. but does it also lack the feature similar to the new doc library which is we cannot edit the page to insert any custom script? How about the existing pages with custom script in it what happens to them?

  19. In company I work for, Office365 SharePoint modern libraries are available, but moderns lists are not. Is there any other reason than tenant choice? I am sitecollection admin and I can set flows (via https://flow.microsoft.com) thru my work account.

    thank you.

  20. How can I switch back and forth between new and old look just for myself? Specially going to new look from old.

Comments are closed.