cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to automate an assignment for my class group using Flow?

I have a class group of 400 students, and I have 5 different quizzes with me on equal weightage.  I want to assign a random quiz set to each of the team members at a particular time.  Is there a way to do it using Flow? 

 

I can assign the test manually but definitely that's not a good idea. On the other side, there is no way to choose a quiz from its ID but only by the name of the quiz. And I don't want to name my quizzes differently(means all the 5 sets should have a name and only the questions should be different) as that may open the gate for sharing answers. 

 

 

4 REPLIES 4
Highlighted
Dual Super User
Dual Super User

Re: How to automate an assignment for my class group using Flow?

Hi!
Where do you have your quizzes defined? Where do you have your students defined?
Where do you want the assignment be stored?
Excel? Sharepoint list items? Microsoft Forms surveys? Microsoft Planner tasks?
There is a funtion called rand() that I think fits your needs
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#u...

I have a flow that assigns Sharepoint tasks randomly to 3 teammates, give me some minutes and I will share a screenshot (not with my laptop now)
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Regular Visitor

Re: How to automate an assignment for my class group using Flow?

I have my quizes in forms. 

Highlighted
Super User
Super User

Re: How to automate an assignment for my class group using Flow?

@DavidMath  and you want to send the url from the test? if is yes you can do this.

 

1.-Create an excel with the columns you need form example

ID Quiz Name Quiz URL from MSForms

2.- Then fill the data and in power automate do this

url1.PNGurl2.PNG

 

then you are sending a random url to a specific student group



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Dual Super User
Dual Super User

Re: How to automate an assignment for my class group using Flow?

Ooops! @ChristianAbata was faster than me, so I guess no need to share example anymore!

I more suggestion: I would store somewhere (in the same excel but in a different table?) the assignment list... a structure like

 

STUDENT#email   QUIZ#ID
========================
student#1       quiz#2
student#2       quiz#1
student#3       quiz#4
...
student#n       quiz#3

 

Moreover, if you initialize this second table with student#email column values, you can make your flow iterate over all of them by means of an 'Apply to each', so in each iteration (i.e. on each table row) you can both update quiz#ID column, and also assign current student email to your 'Send an email' 'To' input.

 

Hope this makes sense



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,437)