Power Automate Workflow (Forms Submission -> Email to Recipients) | Scribe

    Power Automate Workflow (Forms Submission -> Email to Recipients)

    • Chaos Delauney |
    • 16 steps |
    • 2 minutes
    1
    Navigate to [https://www.microsoft365.com/launch/excel?auth=2](https://www.microsoft365.com/launch/excel?auth=2)
    2
    Create blank workbook in Excel online; ensure the file path is correct before proceeding to the next steps.
    3
    Click "Insert"; click "Forms"; click "New Form". This will open a new Form in your browser.
    4
    Design new Form.
    5
    Switch to tab "Microsoft Power Automate"; click "Create"; click "Automated cloud flow"
    6
    Enter Flow name and choose your flow's trigger. In this case we will use the Microsoft Forms trigger "When a new response is submitted". Click "Create".
    7
    Locate your Form; in this case: "Title here".
    8
    Click "+New Step"; click the "Search connectors and actions" field.
    9
    Type "Outlook" in search bar; click "Office 365 Outlook"; choose "Send an email".
    10
    Specify email addresses separated by semicolons. Type your own email address to test that the flow is working as expected prior to activating flow. You can edit this later.
    11
    Type Subject; click "Add dynamic content"; Click "Response Id"
    12
    Fill out the body of the email; click "Save"; click "Test"; click "Trigger flow manually"; click "Test".
    13
    Switch to tab "Microsoft Forms"; click "Collect responses"; click "Copy link"; paste link into search bar; fill and submit the Form.
    14
    Switch to tab "Microsoft Power Automate" to confirm flow ran successfully.
    15
    Switch to tab "Outlook" to confirm email appears as expected.
    16
    Switch to tab "Microsoft Power Automate", click on "edit" in top right corner of page, and replace your email address with that of the intended recipients.