Modern SharePoint lists are here – Including integration with Microsoft Flow and PowerApps
Published Jul 25 2016 01:14 PM 86.2K Views
Microsoft

Earlier this year, we unveiled a new cloud-first, mobile-first vision and roadmap for SharePoint, along with 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 roll out of modern lists to SharePoint Online along with one-click integration of PowerApps and Flow. These enhancements will begin rolling out to Office 365 First Release customers the first week in August 2016.

 

What’s New with SharePoint Lists

SharePoint lists provide a powerful way for people to collaborate on structured data directly from their team site, helping teams organize content from investment account onboarding details, to field service requests, and even softball team t-shirt sizes. Over ten million custom lists are already in use across Office 365.  You can learn more about the general use of SharePoint lists on our support site.

 

 

 

Now, we’re delivering a modern lists experience that looks great and is responsive, accessible, and easy to use on any device. Modern list experiences will be automatically available to all existing classic SharePoint Online 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 itself
  • 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

ModernListInfoPanel.PNG

Modern lists with the information panel

 

And modern lists look great in the SharePoint mobile app, making every location and every device a first class component of business processes.

 

 

wp_ss_20160721_0001.png

Editing list items in SharePoint mobile browser

 

Integrating PowerApps and Microsoft Flow

Customers regularly exchange data between SharePoint lists and other systems to support business processes. These scenarios become more powerful through deep integration of Microsoft Flow with SharePoint 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.

 

PowerAppsInt.png

Building a PowerApp from a modern SharePoint list

 

 
   

 

 SP-Flow.PNG

 

Automatically build a new Flow from SharePoint

 

Microsoft Flow and PowerApps are currently in public preview. To learn more about PowerApps and Microsoft Flow integration, see video (https://youtu.be/x8tgKBXmmPg?t=7m16s)

 

Modern and Classic Experience

Almost all classic lists will automatically inherit the new modern interface. Modern lists support 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 reverts automatically to the classic experience. Users can choose to revert to the classic experience at any time, and   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.

 

What’s next

The initial rollout of modern lists to First Release 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 lists

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

 

To preview modern lists:

  • Navigate to a list in SharePoint Online.
  • In the URL bar, add TryNewExperience=true as a query string parameter. Query string parameters are values listed after the address in the URL. A question mark separates the address from query string parameters.
    • If there are other query string parameters in the URL, add &TryNewExperience=true [ampersand prefix]
    • If there are no other query string parameters, add ?TryNewExperience=true [question mark prefix]
    • When you have finished previewing the modern experience, close the browser to reset to classic experience. For some browsers, you may need to clear session cookies to return to the classic experience.

 

As part of digital transformation, one of our ambitions is to reinvent productivity and business process. We think that modern lists, along with PowerApps and Flow, unlock new collaborative scenarios in Office 365. We look forward to hearing about your successes and how we can continue to improve SharePoint lists. Join the conversation at sharepoint.uservoice.com or here. Thanks.

 

  • Chris McNulty, senior product manager

 

 

Subscribe to the SharePoint community blog to recieve future updates. 

47 Comments
Brass Contributor

The early preview query string isn't working for me.  Is it working for anyone?

Copper Contributor

not working for me either.

Iron Contributor

Worked for me!

 

Well .. I can see the "powerapp" button, but not the "flow" one.

 

I'm unsure if it's a prerequisite but, you might want to check that "new experience" is selected in SPO central admin & be part of the "First release program"

 

On a different note, when can we expect (modern) list to be added to Office 365 groups ?

Works in one of several lists I've tried.  Not sure at the moment whether it applies only to Custom Lists or lists like Contacts, Calendar and Tasks as well.

 

Looks nice when the UX does switch over - but may be the rollout hasn't hit everyone.

Iron Contributor

Not working for me either... Robot Sad

Nice, that TryNewExperience parameter! Reminds me of the EnableConnectorDevPreview parameter :)

 

Guess the modern list experience hasn't rolled out to all tenants yet. I tried the parameter on three different tenants, without success. All three tenants located in Europe by the way. I've seen before that features are rolled out to US based tenants before tenants in other parts of the world.

So query string doesn't yet for me too. Would be great if the required version of SharePoint online can be added to such posts in future as they do with Windows Insider.

 

The current version you are on can be easily checked through appending /_vti_pvt/service.cnf to the query string.

 

 

Copper Contributor

Not in Australia yet ;) apparently

Deleted
Not applicable

Yep - nothing here in Australia either

 

SharePoint Online tenant is running build 16.0.5507.1207 at the moment

Iron Contributor

 I think I've got parts of the new experience in my developer tenant.

 

It shows the new list overview, but when I create a new list item, or when I edit the properties of an existing list item, I'm getting the old experience.

 

I was wondering about this quote: "If we see a compatibility blocker, like an unsupported browser or JSLink customizations, the list reverts automatically to the classic experience."

 

What are unsupported browser customizations that are detected. E.g. is jQuery manipulation of dom elements detected and does that count as a compatibility blocker? 

 

 

Microsoft

Hi folks.  If the Query String parameter isn't working for you it has nothing to do with First Release - everyone has the abilty to test the modern UX with that parameter.  However, if you have modern turned off in tenant admin, or you have unsupported cusotmizations,  automatic fallback to classic kicks in.  See https://support.office.com/en-us/article/Differences-between-the-new-document-library-experience-and... for specifics.

 

Please keep the comments coming - thanks!

Microsoft

Yes, for jQuery actions like that, for now, we fallback to classic - but we are absolutely committed to bringing full customizaiton to the modern expereince and to maintaing classic mode.

Microsoft

The preview is limited to the core lists experience - PowerApps buitton shouldnt show up (yet) in the test preview mode.  PowerApps and Flow buttons will be enabled soon.  Thanks!

Hi @Chris McNulty, I did some more tests. Apparently the Modern UI does not work on Announcement lists. I created a brand new Announcement list in a brand new site collection, and it showed me classic UI when using the ?TryNewExperience=true parameter. But when I created a new Custom list in the exact same site, this list did show the Modern UI!

 

Oh, and by the way, I do see the PowerApps button too :)

 

snip_20160726190044.png

Brass Contributor

Chris, can you share with us what the ETA for new customization available? Since JSLink and CustomAction might not be supported, we are wondering why would be the recommended way to customize the list and document library. Thanks

Copper Contributor

Hi Chris,

 

I do see message on my admin- But when I try 

https://ourspsite.sharepoint.com/Lists/test33/AllItems.aspx?TryNewExperience=true nothing changes.

there is no customization on the site as such. 

Updated Feature: Modern SharePoint Lists
MC72990
Published On : Jul 22, 2016
Expires On : Aug 21, 2016
We’re making some changes to lists in SharePoint. Modern lists offer many UI enhancements such as inline creation of custom views and columns; improved mobile support; PowerApps and Flow integration; and the information panel. We’ve replaced the Ribbon with a clean, responsive command bar. We’re going to start rolling out modern lists for First Release Users in early August, with First Release Tenants and Production rings following.
Copper Contributor

Great news. I have a question though. Currently viewing a list on a mobile device doesnt allow you to see a managed metadata column. Will this functionality be part of the modern list release?

 

Also powerapps currently doesnt support managed metadata column. how soon will it become available?

Copper Contributor

HI everyone , i tried to use preview of modern SP List but its really hard to find Outlook connection or excel export option which my user love most. how can i find that in new SharePoint list Modern experence ?

Iron Contributor

So as per my reply earlier, I was able to access the new look yesterday appending the url with ?TryNewExperience=true

I even showed a few colleague how cool it looked ...

 

Well, thanks for bursting my bubble, but I am not able to access the new Experience today .. Smiley Sad

Any reason for such a switcheroo?

 

Australian tenant here as well!

 

 

 

@Oko Djangmah Check out my two screenshots below. I've added a Business column to my list, which is a managed metadata column. The new SharePoint app for iOS does not display this column correctly (neither are currency columns by the way), but the mobile list view in the browser does.

 

20160727_075802000_iOS.png20160727_075416000_iOS.png

Microsoft

The publishing feature was causing some issues earlier, so autofallback was happening on sites where this feature was live. Happilyk we are seeing fewer issues with it later and will be removing the autofallback when this featruere is detected.

Microsoft

Modern UX is available for custom lists, so far, not the OOB list types like Tasks and Annoucements.  Further customization options are dependent on the release of the SharePoint Framework by year end.  In the interim, classic mode remains fully supported.  Thanks.

Iron Contributor

@Chris McNulty I hope you understand that quotes like these scares the crap out of people

 

"Further customization options are dependent on the release of the SharePoint Framework by year end.  In the interim, classic mode remains fully supported."

 

First, we need to wait to the end of the year before the SharePoint framework is released. That isn't a big surprise. But then you mention, as long as it's not released classic mode is fully supported. 

 

So when it's released you need to make sure you rebuild your solutions to work with the the new ui and framework asap, else you're in trouble.

 

I'm really looking forward to a quote from Microsoft where they state the minimal timeline where classic mode will be supported. Something like: We support classic mode to end 2020 and after that we look inti usage data to determine if we can phase out the classic model. Now we constantly hear and sometimes interpret: we will kill classic mode as soon as we can, and it's going to be in 2017 not later.

 

That's a really tough message for our customers. A scope of less than a year to rewrite all customizations.

 

I've created a seperate topic to address these concerns: https://network.office.com/t5/SharePoint-Developer/Classic-mode-support-timeline/m-p/3640

Microsoft

I'd like to correct your interpretation.  We have no plans to remove classic mode.  And not in 2017.  Even if we wanted to, 2017 is too soon for the kind of long term communication we would need for a change of that magnitude. 

 

And we haven't earned the right to even plan for it until we offer a complete extensibility story for modern UX, and we see that majority of our usage has shifted to it.  See http://dev.office.com/blogs/update-on-modern-document-libraries-and-extensiblity for more.

 

Before the rollout, you had classic expereince and classic customization.  Now, we've added modern expereince without removing anything.  And we're 100% committed to landing modern customization and extensibility to make modern mode even more capable than classic mode,  Thanks.

Copper Contributor
Working fine. Fun to look forward to.
Copper Contributor

 I tried to use the Modern Lists with my development tenant. I am able to see the Modern UI in Document libraries but not finding the same in custom lists ? Can you please specify the reason for the same  ? 

Microsoft

Modern lists began moving into First Release Users on August 1, full First Release will follow.  Please be patient as we move through the deployment cycle - it will be worth the wait.

Copper Contributor

@Chris McNulty fyi, you may already be aware but the Metadata Navigation SharePoint site feature (which provides Hierarchy and Key Filters nav on left of list/library) falls into unsupported "customization" category.  Had to first deactivate before I can try out the list modern UX

Brass Contributor

@Chris McNulty

 

This might be a bug but it seems when you select "Filter By" in the new experience and make a selection it closes out and refreshes the page. On the old classic view I used to be able to select multiple items in rapid succession, now for each selection I want to filter by I have to reopen the filter by menu on the column, click one item, reopen the filter by menu, click one item, etc.

 

Is that going to be changed before the new experience is released? 

Copper Contributor

@Chris McNulty ,

I am having all subsites automatically show on the global navigation bar when using the new look, but not in classic. I go to the navigation settings, but only the links that show in classic view appear in the global navigation links list. Do you know the reason why?

Thanks!

Chase

Microsoft

Yes, we are tuning the navigation customization.  Right now, some of the patterns cause automatic fallback, but its our intention to more fully enable custom navigation in the modewrn experience soon.

Iron Contributor

How do you turn off PowerApps button. We don't want our users to be playing with this feature.

 

I do not see the Flow button yet.

Microsoft

Take those users out of First Release Users, and they shouldn;t see the button yet.  Thanks. @Michelle Porreca

Copper Contributor

I did not run through all the comments, but is there a plan to provide an option to fix the headline/first row of a list when scrolling vertically? Same question for first (or more) columns when scrolling horizontally. Especially to fix the headline/first row is of high interst for our internal users.

Copper Contributor

@Chris McNulty, thank you for showing a demo of he new SharePoint List and integration with PowerApps and Flow at SharePoint Fest Seattle today. It made sticking around late on the last day completely worth it.  The conference PowerApp you showed could easily be applied to any business whose Sales groups host Sales meetings. 

We're a first release customer who've kept the Classic UI as the default in the SharePoint Admin panel settings.

 

I am still not seeing Modern List UI as an option for our list (we do see that option for Doc Libraries). Shouldn't this be available to all First Release customers by now?

Deleted
Not applicable

Is there going to be a way to manage what Flows can be created from a list? We dont want people being able to e.g. share content to Twitter...

Copper Contributor

I see the "Modern" views by default. Thank goodness my users do not! Several of the list functions no longer work in the views that I had set up when "Classic" views controlled. For example, it is critical in several of our lists that certain columns "Total". The sum requests for these columns in these views are still checked, but nowhere do these sums appear in the Modern View. The pupose of list views is to show filtered data to users in a way that is useful and easy to review. Sums (or totals) can be critical components of a view, providing instant information. If my users have to pull out their calculators, what is the point of the list view?

Brass Contributor

Is there a time line on when the Issue Tracking list will receive the modern UI??

 

Many thanks! 

Iron Contributor

If you have this many "we know, we're working on it, should be coming soon" answers, then why would you even roll it out to anyone, first release users or otherwise? It would be so much more useful if it worked.

 

And, some kind of 'where did it go' tutorial for all the functionality that's on the ribbon that is lost or obscured in the Modern UI would be incredibly helpful to all, I would presume, but especially my end users.

Iron Contributor

I agree with Lisa. Wanted to add a "like" to her comment, but there is no ability for me to "Like" it.

 

This forum needs some work too.

Bronze Contributor

Is this parameter ?TryNewExperience=true still supposed to be working? It is not for one of my lists, and I wanted to see how that list would look in Modern.

 

Thanks

Bronze Contributor

@Rob O'Keefe Its not working 

Copper Contributor

Hi @Chris McNulty, once you're in the classic experience on a doc library or a list, is there a way to switch to the modern experience?  I just tried adding ?TryNewExperience=true to the end of the URL on a library I was in classic on, but it did not get me to modern (nothing happened and I stayed in classic).

Copper Contributor

Is there a timeline of when this will hit enviroments that were not part of the initial rollout?

Microsoft

We are finally at 100% for the general rollouts!  At this point, you should be seeing the modern list experience unless you are running one of the unsupported customizations, like JSLink or IE9.

Copper Contributor
  1. Our tenant is set to targeted release for everyone and so we have used the modern web parts for some time.  Probably a year ago, the List (Preview) web part only showed the default view of a list, but eventually it actually did show the view selected in the properties pane.
  2. Today, the List (Preview) web part has reverted back to showing only the default view no matter what view you pick in the properties pane for the web part.  This happens in all browsers and for all people.  The List (Preview) web parts worked fine the week of July 7/23 but I noticed the change this last week starting 7/30.
  3. If you add another List (Preview) web part to the page and open the properties pane, you can select a view that is not the default and the columns for this non-default view will show in the web part while you are in edit mode.   Once the page is published, the view reverts to the default view and you cannot make it change even if you open the properties pane again.
  4. If I want a view to display in the List (Preview) web part it has to be switched to the default view.
Version history
Last update:
‎Sep 21 2016 08:05 AM
Updated by: