{"id":161,"date":"2020-04-19T22:22:11","date_gmt":"2020-04-19T22:22:11","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/an\/digitallearningprototype\/?p=161"},"modified":"2020-05-15T20:58:20","modified_gmt":"2020-05-15T20:58:20","slug":"using-power-automate-for-pupil-check-in","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/an\/digitallearningprototype\/2020\/04\/19\/using-power-automate-for-pupil-check-in\/","title":{"rendered":"Using Power automate for pupil check-in"},"content":{"rendered":"
\n

These instructions are created thanks to Al Friend from CastleBay school in Barra and the #TeamMIEEScotland team where this was shared.<\/p>\n

This uses a Microsoft form to add an entry into a shared Excel spreadsheet.\u00a0 The form includes a rating question asking how the pupils are and if the mark is 3 or 4 out of 10 then it sends an email is sent upon submission to certain staff members.\u00a0 If the mark is 1 or 2 out of 10 an email is sent upon submission to other staff members.<\/p>\n

Our pupil care and support staff team, heads of years, deputes and senior leaders have access to the shared Excel file so can check the entries during the day and contact the young people or their families accordingly.<\/p>\n

Instructions for creation.<\/strong><\/span><\/p>\n

    \n
  1. Create the Microsoft Form .\u00a0 We have found this only works with a personal form.\u00a0 Power Automate doesn’t give the group forms as an option to choose from.<\/li>\n<\/ol>\n

    Here is the form we are using.\u00a0 A mixture of multiple choice, a rating, long answer questions.<\/p>\n

    \"\"<\/p>\n

    2. Create the Excel file that will store the data.\u00a0 Ours in created in the documents storage in SharePoint in a Staff Microsoft Team.<\/p>\n