cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidMath
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
efialttes
Super User III
Super User III

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!



I have my quizes in forms. 

@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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,150)