Power Automate Tutorial: Send Forms Responses Via Email

In this Pragmatic Works walkthrough, Jonathon Silva demonstrates how Microsoft Power Automate can help streamline everyday work by automating routine tasks. Rather than spending time manually coordinating simple processes, Jonathon shows how organizations can use Microsoft Forms and Power Automate together to create a more efficient and organized workflow.

The video centers on a practical university scenario. Jonathon explains how a professor could simplify the thesis topic submission process for students. Instead of collecting information through scattered emails or manual scheduling requests, the professor can use a Microsoft Form to gather student responses and then trigger an automated email notification whenever a student requests a meeting.

The Goal of the Solution

Jonathon frames the solution around a common business challenge: reducing time spent on repetitive coordination tasks. In this case, the goal is to collect thesis topic submissions and automatically notify the professor when a student wants to schedule a discussion. This allows the professor to focus more on meaningful work rather than administrative follow-up.

He emphasizes that this same process can apply to many other situations beyond education, making it a strong introductory example of how Power Automate can support both work and everyday organizational needs.

The Microsoft Form Setup

Jonathon begins by creating a simple Microsoft Form called Graduate Thesis Topic Submission. The form contains three straightforward questions designed to capture the key information needed for the workflow:

• Student Name – a text field for the student’s name
• Thesis Topic – a text field where the student enters the chosen topic
• Would you like to schedule a meeting? – a choice field with Yes or No responses

This form acts as the entry point for the automation. Jonathon shows that even with a very simple structure, the form can provide enough information to trigger useful downstream actions in Power Automate.

Building the Power Automate Flow

After creating the form, Jonathon moves into Power Automate and builds a new automated cloud flow. He names the flow based on its purpose: sending an email notification from a form submission.

The process follows a clear logical sequence:

1. Create a trigger for when a new Microsoft Forms response is submitted
2. Select the correct form ID so the flow knows which form to monitor
3. Add the Get response details action to capture the submitted answers
4. Use the response ID as dynamic content to retrieve the exact submission
5. Add a condition to evaluate whether the student selected Yes for scheduling a meeting
6. Send an email notification if the response is Yes

Jonathon explains that thinking in a logical, step-by-step manner is important when building flows. First, the data must be captured. Then, the condition must check the relevant answer. Finally, the automated action should happen only when the condition is met.

Using Conditional Logic

One of the most useful parts of the demonstration is the condition step. Jonathon uses the response to the question Would you like to schedule a meeting? as the deciding factor in the flow.

If the answer is Yes, Power Automate sends an email notification. If the answer is No, the flow takes no further action. This makes the process efficient because the professor is only notified when follow-up is actually needed.

The email itself includes dynamic content pulled directly from the form response. Jonathon inserts the student’s name into the subject line and uses the thesis topic in the email body. This makes the notification specific, useful, and immediately actionable.

Testing the Flow

Jonathon then tests the flow manually. Because the flow is newly created, he chooses the manual testing option in Power Automate. He returns to the form, enters a sample response, and submits it.

For the test, the student name is entered as Steven Smith, and the thesis topic is listed as Allied Strategic Plan for Operation Overlord. The response to the meeting question is set to Yes.

Once the form is submitted, the flow runs successfully. Jonathon confirms that the email arrives as expected and contains the correct student name and topic. This proves that the automation works correctly from end to end.

Why This Example Matters

Jonathon highlights the broader value of the solution by explaining that the same design can be reused across many business scenarios. The workflow is simple, but it demonstrates the real strength of Power Automate: connecting Microsoft tools to reduce manual effort.

Some possible use cases include:

• Internal employee meeting requests
• Manager follow-ups on workplace concerns
• Customer service escalation workflows
• Feedback forms with different actions based on responses
• Departmental intake processes that need quick notifications

By combining Forms, conditional logic, and email notifications, teams can create lightweight automation that saves time and improves organization.

Final Thoughts

Jonathon Silva presents an accessible and practical introduction to Power Automate by showing how a simple Microsoft Form can drive an automated email workflow. His example makes it clear that automation does not need to be overly complex to deliver value. With just a few steps, users can collect information, evaluate responses, and trigger meaningful actions automatically.

For organizations already using the Microsoft ecosystem, this kind of integration offers an easy way to improve efficiency, reduce repetitive work, and create smoother communication processes.

 Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Forms and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.