jordan rhea header

Automated Student Self-Reflections

May 24th, 2022

The greatest trick of saving time is gathering information effectively

Whether it is how you are collecting their homework, assessments, or feedback, you are just trying to take their input and handle it with efficiency. Microsoft Forms allows you to do that in a standardized way.

The first thing you need to do is design your form. Simple enough once you are familiar with how Forms works.

See an example of the form that I used here

The next step is handling the form inputs once they are submitted. We will use Power Automate (formerly known as Flow) to do this. I am going to try and break down the flow I made for my use, however, your use may differ. Let me know in the comments below, how you implemented something similar!

The first two blocks get the form itself and then get the responses.

First step of the flow

The next block defines the condition to handle different cases. You could omit this if all of your responses will be handled the same way. However, students will be handled different than teachers responding. The way I differentiate is in this block determining if the word student is in the email address.

Second step of the flow

If the condition is YES then I run a custom connector that connects to PowerSchool to get more information about the student. Then I grab all of the sections in the OneNote notebook. In the next block I will filter these to match the home_room information returned from PowerSchool.

Third step of the flow

Specifically which homeroom they are inwhich I match up with the different sections in OneNote. Fourth step of the flow

Once I have that, I use the Create page in a section block to write the actual HTML code. Just drop in the connections to dynamic data and away you go! Fifth step of the flow

I also have included a NO condition that handles the form if someone like a teacher completes the form. This step is optional, but I wanted a way to handle my own completion of the form!

Sixth step of the flow

How would you go about completing something similar? Is there something that I have not explained well? I would love some feedback! I have been out of the practice of documenting my work, and it is time that I get back into it.

jordan rhea wearing a hoodie
Written by jordan rhea Building tools and connecting systems