cancel
Showing results for 
Search instead for 
Did you mean: 

Create a Form that takes Specific Actions Based on Responses

One of the more powerful aspects of Flow is that it can take various actions based on conditions. Using Forms inside of Teams, you can very easily set parameters around different actions that will be taken based on the responses people give on your Form. This is a very common requirement of many workflows and can be accomplished  by even the most in experienced users in Flow in just a few minutes. This workflow is a great place to start if you are beginning to learn Flow or have not yet played with "Conditions" in the flow application.

 

About Conditions

Rather than just adding an action in Flow, a "Condition" allows the user to set up some "If, then" logic within a Flow that has already been triggered. Depending on the action that as being taken, this can allow to create a "Flow within a Flow" if you will, and if used properly can also help larger organizations save their number of allotted Flow runs. If you are building your own bot or using a bot like H3's At Bot, then the possibilities can be… I guess… even more endless?

 

Well, at this point I think you get the idea- let's get started with building this Flow! Todays Flow is going to be a Form embedded in Teams that sends email notifications of the Form submission to different people in the organization based on the responses given by the person submitting the Form.

 

OK! Here we go!

 So the first step is to build a personal Form directly in the Forms app, then add the existing form to a Teams Tab, the result of my form seen below in Teams:

Image 001.png

 

Now, heading over to SharePoint, I'm going to set up a list under a SharePoint Site (the site behind the Team/Group of the Form in the Teams Tab would probably be best) where my Columns correspond with the text of the Questions in the Form.

 

Untitled picture.png

 

 Once this is done I can head over to the Forms application and get started with the Template to record Forms responses to a SharePoint List:

Image 002.png

The next step is to fill out the template and get the response details from the Form, and then enter in the information as needed for the SharePoint List.

 

Image 003.png

 

 

Next, I will populate the information for the columns of the list via the dynamic data from the Form, as seen below:

 

Image 005.png

Now, here's where the fun really begins! Instead of just adding another action, I am going to create a "condition" via Flow. For this example I'm having the responses kick of emails to employees in the company based off of the answers submitted in the Form.

 

My first condition I will set up as follows, with Dynamic data in my email response to the employee in question. If a contract has been noted as being in place by the Form in the Teams Channel, Adele will be notified and sent so she can actually see why she is getting this notification. Note that I've also added a link to the actual item that is recorded in SharePoint so that she can easily get to the record that has been created as well:

 

Image 006.png

In my form response, if a contract is NOT in place, a different person will be notified. I do this by filling out the "If No" section under my condition. 

 

Image 007.png

 

Now, I'm also going to add a Planner Task to Brian so that the whole team can have some visibility in the process.

To get the Plan ID for the plan in question, I can simply navigate to the plan, and pull the plan ID from the URL as seen below:

 

Image 008.pngImage 009.png

 

Now, just for fun, I've continued this out with yet another set of "Yes/No" conditions and email notifications:

Image 011.png

 

All of this is nested under the original "If no" condition from my first step.

 

You could add additional conditions under the "If Yes" step back at the beginning of this process.

 

The last thing to touch on is that all of this is just some fun toys if you do not understand your company's business processes.

 

If you have not already been given an understanding or requirements by your organization,  get to know some people in your organization and see if you can gather the "If/When" information you need to automate some of their business processes.

 

If you have some power users in your company, see if you can get them do it on their own- or even train others to do this! I know such ideas seem ridiculous and "pie in the sky" pipe dreams to many people in IT, but I've personally met people in IT that are overburdened that find ways to make such things happen, and their reward is being seen as the hero by their users and their company!

 

After all, nothing is impossible… well, almost nothing.

Comments

Nice article, Microsoft Forms, Microsoft Teams, Microsoft Planner and Microsoft Flow 
😁

Nicely presented Hunter, and easily relatable to many use cases!

Very well done. It is great to see great examples

Thanks for sharing. I am new to using all these O365 products and trying to implement them within our business.   This helped me understand how it should work, I just don't know how to apply it to my specific situation. Do you know if there is someone I could contact that can help me set up my Form into Flow with Approvals?

 

Thanks in advance!

Meet Our Blog Authors
  • Working daily with Microsoft Cloud to deliver the needs of my company, my customers and various Microsoft communities and forums. | Office 365 | Flow | PowerShell | PowerApps | SharePoint |
  • Co-founder of https://plumsail.com, Office 365 and SharePoint expert. Passionate about design and development of easy to use, convenient and flexible products.
  • Microsoft Business Apps MVP. Owner of ThriveFast, an Office 365 consulting company.
  • 7x Microsoft Business Solutions MVP (CRM)
  • Solution Architect with Slalom, and organizer of the Boston Office 365 User Group, and long term SharePoint/Office 365 veteren. Find more at http://www.davidlozzi.com. Follow @DavidLozzi
  • I'm keen in MS technologies, SharePoint, Office 365 and development for them
  • Daniel is a Business Productivity Consultant & Microsoft Business Solutions MVP who is very enthusiastic about all things Office 365, Microsoft Flow, PowerApps, Azure & SharePoint (Online). Since the preview, Daniel has been working with Microsoft Flow and later on with Microsoft PowerApps. That led to him being awarded an MVP Award for Business Solutions. He loves to blog, present and evangelize about improving productivity in the modern workspace with these amazing tools!
  • Michelle is an Office 365 solution architect in Twin Cities, MN. She has been delivering business collaboration solutions for years with her focus on SharePoint and Office 365. Michelle is a recent board member of the Minnesota Office 365 User Group and has been a member of the SharePoint community since 2009. She is a frequent speaker at MNSPUG and SharePoint Saturday and co-chaired the Legal SharePoint User Group for 4 years. Her most frequent projects have involved rolling out a large deployment of Office 365, SharePoint Online intranet, build of a "CHAMPS" Office 365 user adoption program and most recently, SharePoint On-Premise to Online Migration. Michelle is very excited about cloud technology as it is shifting her IT Pro focus to collaboration strategy and technical adoption.
  • I'm a Microsoft Office Servers and Services MVP with a special interest in SharePoint, Office 365, Microsoft Flow, Microsoft Teams and PowerApps. I work at Triad Group Plc ( https://triad.co.uk)
>