Microsoft Flow integration with SharePoint Modern Lists Preview

A few months ago, at the Future of SharePoint event, we unveiled how Flow will be integrated into modern SharePoint lists to enable you to seamlessly create workflows around your list items. You can now experience the integration yourself. In this blog post, we’ll show you how you can preview the new modern lists experience that includes the Microsoft Flow integration and walk you through an example.

Previewing modern lists

Over the past few weeks, we have been rolling out the experience to all First Release customers by default, so if you’re a First Release SharePoint customer, you should be all set. 

For those of you that can’t see the modern list experience yet, here’s what you need to do:

  • Navigate to a custom 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.

To see all the new features included with modern lists, check out this post by Chris McNulty from the SharePoint Product Management team.

Send SharePoint list items for email approval

Let’s go through an example. Let’s imagine you manage a team of amazing engineers and track who’s on vacation using a SharePoint list called Upcoming Vacations. You want to create a flow such that whenever a new item is added (someone is going on vacation); an email is sent to you with details about the item (the upcoming vacation).

In the SharePoint list, click on the Flow button and choose Add Flow.

In the Flow panel that appears on your right hand side, select the first template Send a customized email when a new SharePoint list item is added. In addition to sending an email, you can also connect to a variety of other services: Yammer, Dynamics CRM, Twitter, MailChimp, and Slack. You can also send an approval email or do something entirely custom using one or more of the 42 services supported by Flow.

 

Selecting the template in SharePoint will open a new tab in the Microsoft Flow site with additional details about the template. Simply enter your credentials and click Continue.

Click on Edit in the first step of the Flow.

Notice that the Site url and List name are automatically populated for you. Magic? We certainly hope you think so.

All you have to do now is click on Create Flow and you’ll start getting emails whenever someone logs a vacation in the Upcoming Vacations list.

The modern lists experience will roll out to all customers by the end of the year. We invite you to try out this new experience now and share your feedback with us, either using the comments below or through the Flow Community forums.