Use Microsoft Forms and Flow to create Mad Libs

Have a holiday party coming up? Staff meeting you want to spice up? Send a form out to attendees in advance to collect adjectives, nouns and verbs and showcase your favorite completed libs at your meeting. Or just do it for fun – because work should be fun. Go ahead and try my test version to see for yourself!

Make your own (short version)

  1. Create a form at forms.office.com with questions for adjectives, nouns, etc. Be sure to collect email addresses as well so you can send participants the completed mad lib. You can use my template
  2. Create a flow at flow.microsoft.com that pulls responses into an email template. You can import the flow I built

Detailed steps

Create the form to collect words

Go to http://forms.office.com

Create an account if you don’t already have one (it’s free!)

Note: It must be an organizational account – Flow cannot currently connect to “personal” Forms accounts.

Create a new form or use my template (open link and click “Duplicate it” at the top)

Add a title, subtitle/instructions and then any questions/word parts you want. You must include email address as a required field if you intend to email the results to someone.

If you’re giving people multiple mad libs to choose from, you must also require a choice field like in my example.

Create the flow to send completed mad libs

This is the part that takes form submissions and turns them into the actual mad libs. It’s easiest to import the flow I built.

  1. Log into your account at https://flow.microsoft.com
  2. Go to your flows, click Import and upload the zip file you downloaded

Now select your existing connections for Forms and Outlook.

If you don’t already have an Outlook and/or Forms connection, you’ll need to click “Create new” and add them, then come back to connect them in the previous step. You can also modify the Flow to use Gmail or HTML emails instead. If you use HTML emails, however, they’re more likely to go to spam or be blocked since they come from a well-known “marketing” address rather than an individual (yourself).

Once you’ve set your connections, click “Import” (you should no longer see red x’s next to the connections under “Related resources”)

Once imported, click “Open flow”

Check every step, especially the “Forms” step to set the correct Form connection, and correct other fields like “email body” variables as needed.

Note: My Flow template has multiple mad lib options. If you just have one, you don’t need the “switch” at all (which is really just a conditional statement).

When finished, click “Save” in the upper right, go to your flows and make sure it’s “On”.

Finally, copy the “Share” URL from your form and send it to people to complete! Have fun!

Embed quizzes and/or results in SharePoint using Microsoft Forms

Asset 1quiz.pngThis morning I looked around for either pure javascript or custom service solutions for trivia or quiz embeds for SharePoint. The out-of-the-box survey web part wouldn’t allow the kind of features I needed such as showing a message upon submission about correct and incorrect answers, and I wanted something more robust than a newsfeed or Yammer quiz. I also wanted users to easily be able to change their own quiz questions and answers and no high-maintenance code solution was going to cut it.

What I learned? There aren’t a lot of free solutions out there for quick quiz creation and embedding in SharePoint. And the ones that are out there don’t look the greatest. Then I remembered Microsoft Forms has a quiz function! Don’t these look great? Even better – you can embed in SharePoint Server/On-Prem or SharePoint Online/O365!

sidebyside

Microsoft Form’s quiz capabilities are incredible. In five minutes you can create a quiz that looks good, is easy to update and has features ordinarily only available with a premium subscription through other services. And as seen above, you can embed the results as well, making voting fun or showing a group how everyone is performing as a whole on a topic quiz. Here are some of the great features you get with Microsoft Forms:

Continue reading “Embed quizzes and/or results in SharePoint using Microsoft Forms”

How to make a Microsoft Flow mobile button to be emailed Microsoft Forms or SharePoint data as Excel link or attachment

screenshot_20171109-143752.png
Microsoft Flow mobile buttons are magical. One touch on your mobile device, and gears start turning to retrieve and deliver the data you need when and how you need it. Recently, I set out to deliver all Microsoft Forms responses to a recipient on-demand as an excel file using a Microsoft Flow mobile button they could press whenever they wanted the results. I also created a button someone could use to be sent all the birthdays coming up in the next week for our organization whenever they need it. You can adjust the following steps to fit your situation and tools, but the following outlines two ideas:

  • Sending someone all responses to a Microsoft Forms survey whenever they press the button (Take a snapshot in time of responses, or pull up-to-the-minute feedback into your meeting)
  • Sending someone SharePoint list items in an excel sheet that match a certain criteria (Projects ending in the next two weeks)

Continue reading “How to make a Microsoft Flow mobile button to be emailed Microsoft Forms or SharePoint data as Excel link or attachment”