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

Amazing. Thanks for the rich information. Learning has no endpoint!

How to get form id

Hi Reza, thank you so much for the video. But I’m wondering how to fill the response details from a Form Quiz each time when a response is submitted to an exist excel (add a row). Can we do it without creating a file to our OneDrive?

Hello! Is there a way to add/delete columns in the spreadsheet created from the forms response? I want to add a column for a secondary key that's stored in a variable within this same flow that downloads the forms responses. Thank you!!

Hi, but why do all the replies come to me with the same email address?
How can I view the email address of someone who responds?

You could make a quiz tutorial by creating a sharepoint list

I am getting the wrong number of total points when doing the increment quiz total. There are 14 questions in my quiz, with 12 of them having 0 points (two questions are to enter your name and email). When the increment step occurs, it is adding 1 point for all 14 questions, which is incorrect as the name/email questions are worth 0 points. I have verified the outcome of the json shows all questionInfo as the 12 pointed questions, so I am not sure why the for each is processing for ALL 14 questions instead of the 12 from the JSON. I have verified that ALL steps are correct. Any ideas?

Thanks!!! how to create a flow for gamification: 4 quizzes in different teams channels, store the individual results and then store the total result

Thanks for the amazing explanation Reza. Is there any other simple or quick way to do the same function? It looks quite complicated for me.

Is there a way to delete the Excel file from OneDrive after the workflow is complete -- same with the .html file used to convert to PDF that is attached to the email as the certificate? Just looking for a way to clean up the collateral used in the workflow when it completes.

On the select array step, I am trying to map another column using a column available from Excel. I am not getting the Dynamic Content to show, similar to your Total Points. What am I missing so that those Excel columns list from the previous step?

Thank you!! You are the best!
Greetings from Brazil 👏

How to provide specific I'd or Name to the Ms form which is automatically Generated when you open the form.

We have a unique requirement to store responses from different forms as key value pairs in a child dataverse table. An user (in the contact table) would fill a form based on an event that they wish to attend. The form questions are different based on the event. We don not want to build a flow per form but use a single flow that uses the header row of the excel to get the questions and use that as the key in a child table while the answers are inserted in the value column. Is there a way forward? Any hint would be mighty useful.

You're the best, you have really made my job easier

Hi Reza.. Great video.. Can we collect ms form data to Smart sheet?

When I selectes 'manually trigger a flow' system says you can not select this trigger as an action....😢

Thak you, this was well described and helped me out with a problem that I was really struggling to solve.

Hello Reza, Is there way to download seperate excel sheet for each time user submit request on form using power automate ?

Hi Reza,

Thanks for all the amazing videos. I want to get the end date from the form setting and use it in my Power flow. Is there any way I can get the end date of the form from form settings.

Do you know any way to download the PDF answers of a Forms with a questionnaire, as well as it is done on the Forms page?
Since there are more than 100 questions and these questions depend on the branching

Hello Reza and thank you for the great videos. I have a question please, Is it possible to send the certificate to the user manager for example to sign it then send the signed certificate to the user? if yes, how to do it?

Excellent

very useful, but i got blank email when submitted no files no tables, where i have to check.?

Hello Reza! Great upload! I'm on the middle of building my flow and I got a different endpoint when I performed the network trace when I download my Forms responses which by the way has more than 50K. Hoping to help me on this to finish my flow.

PUT method (This API triggered upon clicking the Get latest responses)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/GenerateCSVFile

GET method (This API triggered multiple times between 25-30s interval)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/GetCSVInfoList

GET method (This API triggered once generation of CSV is completed which will download the responses in csv format)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/DownloadCSVFile/6ff2badf-f6d0-4e5f-abe9-dbae46ed9445.csv

Thank you for this awesome video! Everything worked great for me! I was just curious, when creating the certificate/pdf how did you get those URLs that you place in the compose function to display images for the certificate?

Hello Reza, great video, it helped me a lot

I have a question, how can I filter the array comparing the completion time propertie against the utcnow() ? I just want to receive the responses that are sent in the current day

How do I find out my tenant id?

Hello sir I want to know how we can connect two Ms forms in single shatepoint list through power automate flow

Hi Reza,
Thanks for the video. I tried following each step but every time it's giving total score not the score earned by the user. Please help.

Hi Reza, is it possible to extract the form responses using the form id? provided the form is not created by me.

That made my brain hurt, but I enjoyed it. Very cool.

Is there a way to add the quiz score into the Sharepoint list versus sending it via email in the table and excel file?

Thank you so much Reza. I have been looking around on how to calculate total point from quiz and save it to SharePoint List. This video really helps. I follow through the flow, however i am stuck at Compose Operation for Question Info, i cant locate body('FormInfo')?['questions']

The quizz results flow works even if the user gets 2 points and also the send email triggers more than 6 email notifications . dont know how to solev this error

Is this method still working for anyone? I'm getting an error 400

Very informative and useful. Thanks

Hi Reza! Thank you for this video. Is it possible to integrate this Power Automate flow to a .NET application? How would I do that?

Hi Reza, I follow your work, you are just amazing. I came across a situation where creating a flow based on forms. Can any form can be automated in a specific channel without picking up a single form to trigger a notification in a specific channel.

This is awesome. I have a quiz with each response (not the question itself) scored at different values. I created a flow using switch controls with increment variables assigning scores and then after I added the Add Rows in my table. The flow worked, but I added the increment variables hoping it would total the scores for me in Excel. It didn’t. Would something like this work in Excel to score each individual responders totals based on the increment variables I assigned each response?

Thank you so much for this! Is there a way to record the results to a SharePoint List as opposed to OneDrive?

Hi Reza, thanks for sharing your knowledge in such a wunderfull and clear way. I have a question. If I make an quiz in forms, and this quiz has TOTAL POINTS . How can you extract these total points to a list. Can you help. ? Thanks a million. !!

can we update the responses once it is submitted in Microsoft form?

Hi Reza, thank you for this video. How do you think would it be possible to send Form to a user that would have a unique ID in UTM, and then pull out this ID from UTM once form was submitted? Thank you in advance.