How to Connect a Form to a SharePoint List using Microsoft Flow in 3 Steps

When enabled by an organization that has deployed Office 365, Microsoft Flow provides end-users with the ability to create automated workflows between applications and many different services using connectors. Microsoft applications and an ever-growing list of third-party services are available to link together. Microsoft Flow lets employees create simple to more complex workflows that can provide efficiencies for businesses around their workflow needs. It's an end-user option, that in most cases does not require a developer for workflows.

 In this blog post I’ll show how you can use a simple Microsoft Flow to connect a Microsoft Form that captures data and then populate the information collected into a SharePoint List. The SharePoint list in my example is a list that is part of an Office 365 Group. If you’re not familiar with Microsoft Forms, it’s a very easy to use application that is included with your Office 365 subscription. If enabled in your organization, you can easily create polls, survey’s and quizzes. With branching capabilities, you can create some very professional looking data collecting forms.
Microsoft Forms may lack some more advanced features, SurveyMonkey or TypeForm provides some features you may find helpful. One thing that is certain with Office 365, is change. I'm sure we will see an increase in Forms features in the future.  Microsoft Flow has hundreds of connectors, so you could connect a SurveyMonkey form or a TypeForm to your SharePoint list if you need some of the advanced features now. The sample forms I show in this post all populate to the same SharePoint List. 
I often highlight the importance around governance for Office 365 Groups in SME’s. While Office 365 is a toolkit for user collaboration, a total free-for-all and the general ability for Group creation is not a best practice. In the examples I am using in this post, the back story is a request for an Office 365 Group. The Form collects information about the Group request, and the Flow will pull the results and store them in a SharePoint list that IT could then review and approve. 

Comments

Post a Comment

Popular posts from this blog

Microsoft Whiteboard: now more colorful and customizable than ever

Image
The Whiteboard team has been hard at work since our announcements at Ignite. A s we gather more and more feedback from our growing customer base, we’ve also been rolling out great new features, with more on the way soon. Let’s take a look at what’s changed. New pen colors and thicknesses Responding to popular demand, we’ve added 10 new pen colors and three more pen thicknesses, allowing Whiteboard users to express themselves more colorfully and boldly than ever. To access the new colors and thicknesses, click on the pen you have selected to pop up the palette. Background colors and gridlines Just like it’s great to have options for pen color, customizing the look and feel of the board itself can help your ideas stand out – and can make your boards more usable and readable as well. Whiteboard now offers nine options for board color and eight types of gridlines that can be used together or separately to customize your boards’ backgrounds. These options are selectable in
Read more

SharePoint page enhancements

Image
There’s a SharePoint page for that. From content-rich home pages that serves entire organizations, to recurring quarterly business review read outs, to internal campaigns, to “welcome to the company” starter pages. As the rich capabilities of modern SharePoint pages evolve, all communicators can better design and promote their information throughout their team and across the organization. We are excited to announce the following page enhancements (screenshots + links to learn more below): Customize title region  | control what the title region of each page looks like (layout, alignment, title, date). Section backgrounds  | display as distinct sections with visual variety throughout the page. Custom page thumbnails  | Choose a preferred thumbnail from Page details. Custom page descriptions  | Create a custom description from Page details. FYI:  removal of the Feedback button  in preparation of new feedback experience  |  in preparation for a new feedback experience coming soon
Read more

New device modeling experience in Azure IoT Central

Image
On the Azure IoT Central team, we are constantly talking with our customers to understand how we can continue to provide more value. One of our top pieces of product feedback has been for a clearer device modeling experience that separates the device instance from the device template. Previously, viewing the device and editing the device template took place on the same page through an “Edit Template” button. This caused a lack of clarity between when you were making a change that applied to the device or if your changes were getting applied to all devices in that template. Recently we've begun a flighted rollout of a new device modeling experience that begins to directly address this feedback. For app builder roles, we have introduced a new “Device Templates” navigation tab that replaces the existing “Application Builder” tab, as well as updated the pattern in which you view or edit your device templates. To edit your device templates, you can visit the “Device Templates” tab
Read more