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.
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.
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:
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.
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:
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.
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.
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.
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:
By combining Forms, conditional logic, and email notifications, teams can create lightweight automation that saves time and improves organization.
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.