Get Forms Responses using Power Automate | Download Excel, Filter, PDF of Quiz Results 03-24-2022 18:56 PM

[RezaDorrani]

This video is a step by step on how to get All Responses from Microsoft Forms with Power Automate. We will use flow to automatically create an Excel file from Forms Responses, Filter Form Responses based on specific answers, Save & Report on Forms Data, Send an Outlook Email notification of Forms Responses, Generate PDF Certificate from Forms Quiz Results & more. For Quiz type Forms, we will download the Excel file containing the scores, calculate the percentage score & generate a PDF certificate for respondents.

✅ Get All Responses as Excel file
✅ Filter Responses & Run Calculations
✅ Generate PDF Certificate from Quiz
✅ Send Results to Email

#PowerAutomate #MicrosoftForms

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

watch?v=4eWGdi_C2hQ

[IanPS]

This tutorial was a blessing, my company recently super heightened their IT standards so I can no longer directly download the form data of forms I made, even though there is no secure or confidential data in them and this work-a-around has been a life saver. THANK YOU!

[lazevedo]

It's possible to export to JSON the Microsoft Forms answers through Power automate and then consume them in Power BI or any other tool you might need (like another power automate flow).

[NickWarner]

oh and I should add that when you do use the increment variable, you would need to use int() eg: int(item()?['selQuestionInfo']?['Point']) to increment correctly if the point values are more than 1.

[NickWarner]

@RezaDorrani Thank you for this excellent tutorial. It has opened up some fantastic opportunities for automating basic training assessments and training records in our organisation.

I discovered an issue where if the quiz has questions with no points assigned, in our case an entry for an ID and an acknowledgment selection, the quiztotal method still counts those questions. The increment integer function will still increment even if there is no point value assigned to the question giving an incorrect quiz total. I'm happy to report that it is a simple fix with a filter array function on the selection to remove values without a point assigned. 

[shavora]

@RezaDorrani  Hi Reza, very good video tutorial. I am stuck at step "Send an HTTP request to sharpoint". Getting the message "Access token not found\r\nclientRequestId:". The form I have been invited to edit, but I am not the owner. Should I look up the Owners ID instead?