Get Forms Responses using Power Automate | Download Excel, Filter, PDF of Quiz Results

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!

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).

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.

@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. 

@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?