emails

(0) Share

Report

Posted on by Canadiansal

310

I have a group of students - say 35. I would like to give them an assignment and have them submit the files back to me.

After the due date, I would like to automatically send an email to those students who have NOT submitted the assignment. I will send them the email daily until the the submit, or the new deadline has passed.

For collecting the responses, I am thinking I can use a Form and use the file attachment option. Is this the best approach?

How would I go about using Flow or PowerApps to do this?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

v-siky-msft on at

Like (0)

Report

Hi @Canadiansal ,

Your needs can be achieved by a Schedule Flow, set start time to the due date, and repeat once a day.

In my understanding, there is an office365 group containing all students in your class, and then there is also a PowerApps Form with EditForm control for students to submit their assignment, so when a student submit his assignment, a record will be generated by himself, so we can use get all user that haven't submitted by comparing all students.

Here are the detailed steps:
First of all, Get all Items from SharePoint list and get all Students users from Office365 Group.
Second, initialize two variables, one is for Submitted user, another is for all group users.
Third, add two Apply for each action to append the Email/UPN to two variables
Then, Use Filter Array action to filter out all submitted users from All Group Users, so only remain Users who haven't submitted the assignment.
Last, Use Join action to concat the array into a string by semicolon, and send Email to all these users.
The flow steps are for your reference:

Hope this helps.

Sik

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

Thank you. I will try these steps. I just wanted to clarify that I was planning to use MS Forms - like a survey tool to collect the responses. I intend to make one question so that they can upload a file in the response. I am assuming that I can then store this in a Sharepoint list. Do you think the above approach is best?
I am not sure about how to initialize the variables you mentioned - I guess I will try it and see what happens.

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Canadiansal ,

MS Forms is also a great tool for submission. If you want this, instead of a PowerApps form, you need to create another flow to save each MS form response to SharePoint list. Here is a template flow for this scenario: Record form responses in SharePoint

Then use the flow I proposed above to achieve your needs.

Sik

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

I cannot find the "Submitted Users" option you have in the picture. Here is what I am doing:

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Canadiansal ,

Actually, it's 'initialize the variable' action, which is used to create a Array variable, and I just renamed its name to Submitted Users, the same as All Grouped Users.

Hope this helps.

Sik

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

Thank you. I have seen a few users answers some of these questions with detailed videos - would this be a possibility? I am working through the steps you provided in any case.

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

Hello, I have gotten this far - stuck at the email step. How do I select the recipients?

Was this reply helpful? Yes No
Canadiansal 310 on at

Like (0)

Report

And my Apply to Each does not look like yours:

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @Canadiansal ,

Put the Output from Join steps into Recipients field.

Sik

Was this reply helpful? Yes No