Forms to Excel with Power Automate
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.
Could anyone give me any pointers as to how I can get this fixed? Thank you so much!!
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.Could anyone give me any pointers as to how I can get this fixed? Thank you so much!! Read More