Forum Discussion
Create a Survey
I'm creating a survey for HR that will have 4 time periods (7 Day, 30 Day, 60 Day and 90 Day). My initial plan is to have the questions in a separate list and store the ratings for each of those questions with the Employee's Name in a separate list. I'm trying to figure out the best way to accomplish this.
2 Replies
Hi Kim Williams​ , As I understand it, you would like to use the same version of the form (with the same questions) but track the survey results for each time period to compare them. In that case, you could create a Microsoft Form with your questions and then build a Power Automate flow using the "When a new response is submitted" trigger.
In the flow, you can create a SharePoint item that includes information about the user, their answers, and the time period. You can manually update the time period after publishing a new version of the survey.What do you think about this approach?
I thought about using Forms. The questions are different for each time period. I currently have the questions in a separate list with their time periods and was going to have another list for the user information and their responses. Just not sure which way to go on the layout of it...Gallery or a Form or Both.
