Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Power Automate (formerly Microsoft Flow) is a powerful tool that allows you to automate workflows and integrate Microsoft Forms with other applications and services. By connecting Forms to Power Automate, you can streamline processes, save time, and enhance productivity. This guide will walk you through how to use Power Automate with Microsoft Forms.

...

  • Automate Repetitive Tasks: Save time by automating workflows, such as sending emails or updating spreadsheets.

  • Connect with Other Apps: Integrate Forms with hundreds of apps, including SharePoint, Excel, Outlook, and more.

  • Enhance Data Management: Sync form responses to databases, CRM systems, or other platforms.

  • Improve Collaboration: Notify team members or stakeholders customers when a form is submitted.

...

  1. Go to Power Automate and sign in with your Microsoft account.

    Click Create and select Automated Cloud Flow. (Pic)

    Or select from a template by selecting Templates

    Templates will have already developed

Expand
titleStart with a Template
  1. Select Templates to select from a variety of pre-built flows.

  2. Use Search to look up specific flows, or refer to the tabs organized by category.

    • Templates will have pre-built flows for simpler processes such as

...

    • Send an confirmation email to the

...

    • respondent”.

templates.pngImage Added

Expand
titleCreate your own flow
  1. Click Create and select Automated Cloud Flow.

create cloud flow.pngImage Added
  1. Name your flow and choose the trigger When a new response is submitted under Microsoft Forms.

  2. Select Create.

...

select forms.pngImage Added

2. Connect Your Form

  1. Select the form you want to use from the dropdown menu.

    1. It may say Invalid parameters, Select the node

    2. Select Pick a form withinForm Id

  2. Authorize Power Automate to access your Forms account if prompted.

...

You can also refer to Connector type to filter the apps based off its type of connection.

Example if add an email

  • Can you edit email message by determining who the recipient of the email after a form is submitted

  • Add a subject of email

  • Write custom message.

  • Use “/” to use dynamic values within your message to make it more personal for the recipient.

    • To ensure you can pull specific data from the form, make sure to connect the Get response details action previous to the email as shown in the image.

4. Test Your Flow

  1. Click Save and then Test to run your flow.

  2. Submit a test response to your form and verify that the flow works as expected.Select

    • For your first test, select manual and Power Automate will redirect you to your Form.

    Submit a test response
      • If it takes a while to load, then go to your form

    and verify that the flow works as expected
      • in a separate tab and submit a response.

    • For each test moving beyond your initial test, select automate as it will resubmit the previous submission for you.

  3. After the flow runs it tests, you will be notified if it was successful or not. You will also see where parts of your flow process succeeded or failed with green check marks or red X’s.

    1. The image shows a flow that ran successfully.

5. Microsoft Copilot

  • Copilot is also helpful if you are unsure how to develop next steps to a flow.

  • Select Copilot

  • Type in what you would like Copilot to do

    • It will generate and modify your form based off your input

    • Make sure to continue testing to ensure it performs the functions you expect.

Info

For more information about copilot, please refer to this wiki page.

6. Monitor and Manage Your Flow

  • Go to the My Flows section in Power Automate to monitor the status of your flows.

  • Edit, delete, or delete share flows as needed to adapt to changing requirements.

...

  • Plan Your Workflow: Map out the steps and actions you want to automate before creating the flow.

  • Use Dynamic Content: Leverage dynamic content from form responses to personalize emails, notifications, or database entries.

  • Test Thoroughly: Test your flows with sample data to ensure they work as intended, especially with MS Copilot.

  • Monitor Performance: Regularly check the My Flows section to ensure your flows are running smoothly.

...

...

Additional Resources

  • Microsoft documentation

  • YouTube videos

  • Self-learning courses

    • Show how to do that on Power Automate