Hey everyone! I’m a beginner with Power Automate and I’m trying to set up a flow that takes responses from Microsoft Forms and puts them into a Google Sheet. I’ve got the basic workflow set up, but I’m running into a problem. When someone submits a form, all I see in the Google Sheet is the response ID. I can’t figure out how to get the actual answers to show up in the sheet. Does anyone know what I’m doing wrong or have any tips on how to fix this? I’d really appreciate any help or advice you can give me. Thanks in advance!
hey there! i’ve done this before. make sure u use the ‘Get response details’ action after the form trigger. then, in the Google Sheets action, map each question to the right column. double check ur column names match the form questions exactly. good luck!
I’ve been through this exact scenario, and it can be frustrating at first. Here’s what worked for me:
First, make sure you’re using the ‘When a new response is submitted’ trigger for your Microsoft Form and then add the ‘Get response details’ action immediately after. This action is crucial since it retrieves all the specific answers submitted in the form.
Next, in your Google Sheets ‘Add a row’ action, map each form question to its corresponding column, ensuring that your column headers exactly match the form questions. Even minor typos can lead to issues. Finally, test your flow with a sample submission to verify everything is working correctly.
I’ve tackled a similar challenge before, and here’s what worked for me:
Make sure you use the “Get response details” action right after the form submission. This ensures that each response from Microsoft Forms is properly captured.
After that, configure the “Add a row into a table” action for Google Sheets so that each question from the form is correctly mapped to its corresponding column. It’s important to select the appropriate dynamic content and verify that your column headers exactly match the form’s questions, as even minor differences can cause issues.
I hope this helps clarify the process.