Microsoft Forms Get ALL Response Details Downloaded via Power Automate
Rather than using When a response is submitted trigger and get response details, it is possible to download all historic responses into Excel or as a JSON payload from Microsoft Forms using an unpublished API. Not only that, but you can easily delete all responses and reset the form. My thoughts are that you might use this to download and store a customer or employee response survey and reset the form submissions for use each week or month.
As the downloaded Excel file contains the scores from the quiz, it would be possible to calculate the percentage score and use it on a certificate. I have covered how to create a PDF certificate using SharePoint, Word and OneDrive Convert File here • Microsoft Forms to PDF without Premiu...
Hiro's article:
https://mofumofupower.hatenablog.com/...
00:00 - Introduction
01:25 - How to download the Excel File via PowerAutomate
05:30 - How to delete/clear historic responses from the Form
The flows are available to download from here https://github.com/DamoBird365/PowerA...
EndPoint
https://forms.office.com
HTTP GET
/formapi/api/16c901d1-9763-49b1-961c-6cd701f5d0f7/users/6c646262-4f6f-4bfb-88c7-86b3d1252cac/light/forms('@{outputs('FormID')}')?$select=rowCount
/formapi/DownloadExcelFile.ashx?formid=@{outputs('FormID')}&timezoneOffset=-60&__TimezoneId=Europe%2FLondon&minResponseId=1&maxResponseId=@{outputs('FormRowCount')?['body']?['RowCount']}
DELETE
/formapi/api/16c901d1-9763-49b1-961c-6cd701f5d0f7/users/6c646262-4f6f-4bfb-88c7-86b3d1252cac/forms('@{outputs('FormID')}')/responses Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕