Adding a row to excel from a Microsoft form

[CWilson12]

I am trying to create a flow to take data submitted via a Microsoft form, and use that information to update a row in an excel table. There is already data in some columns (e.g. name, email address), and I want the new information to sit alongside the information that is already there, so for example I can easily see which people haven't yet submitted the form and their choices.

I keep getting stick on the 'Get a row' part, because I can't get the form data to match the data that is already in the file. I want them to match up using the student ID number that gets automatically added when a student submits the form, so I have added a row to my excel file with this ID number, but I can't select it as the Key Value, because the only option that comes up for this is 'Response ID'. How do I match up the data on the microsoft form with the data already in the excel file, so that the information I want can sit in the right row, next to the right name?

Thanks very much!

[rzaneti · Accepted solution]

Hi @CWilson12 ,

It looks like your main issue is to capture the student ID from the form to use as key value. Based on your description, you have only the "When a new response is submitted" step in your flow, but not the "Get response details", where the form fields properties can be accessed.

In the "Get response details", you must enter the "Response ID" from the trigger:

And then you will be able to see the dynamic content related to the form questions, like in the example below:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 
https://www.linkedin.com/in/raphael-haus-zaneti/ 

[CWilson12]

Thank you so much!