How to upload and download data to Microsoft Forms to add feedback to the Form's responses?

Question

I am trying to start a project with the aim of using an AI such as ChatGPT to mark students' work, but I'm struggling with some steps, and I'm not sure if the process I want to use is even possible.

Currently I want to automate the following process after students have completed an Assignment set using a Microsoft Form in Teams.

1. Download the spreadsheet of all the students' results.
2. Submit the responses to ChatGPT for marking
3. Putting GPT's marking and feedback into the spreadsheet
4. Re-uploading the spreadsheet to Teams/Sharepoint/where ever it needs to go

I have written Python code to do steps 2 and 3 fairly easily, but I cannot seem to solve steps 1 and 4. Is this even possible? I am happy to use Python, Power Automate, or whatever, but there has to be a way to access this data in the background to avoid me having to manually copy and paste AI generated feedback into response boxes in a Microsoft Form!

Any help greatly appreciated

Answer 1

Hi @O. Toogood

Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description, your question is not in our support scope. The following suggestion is just for your reference.

You can use PowerAutomate to accomplish this requirement:

1. Whenever a student submits a Form, submit their answers to a table (Excel or SharePoint)
2. Enter the GPT score into a table. It is worth noting that if you want to enter the GPT score back into the Form, PowerAutomate currently does not provide a direct out-of-box method.
3. Upload the file.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---