Forum Discussion
Solved
New to Forms -Some Questions
Hi, I'm enjoying working with Microsoft Forms. It's really quite easy to create some high end survey forms.
With that being said, I have a few questions.
Can any information about the perso...
If you export the results to Excel, do you see information about the person who completed the survey, like their e-mail address and/or name? I use Forms at work, so they're always set to the "in my organization" option rather than the "anyone" option. I always can see the name and e-mail address of the respondent if I view results in Excel. If you are using the "available to anyone with link" option, I'm not sure how that works. You could always add a field for Name or e-mail and make it a required question.Besides Excel, Forms has a Flow connector. I'm doing some pretty impressive things combining Forms and Flow. Flow will allow you to do almost whatever you want with the responses after they're submitted. It's relatively easy to figure out if you want to do something simple, like send yourself an alert and log the results into a SharePoint list whenever a response is completed. If you want to get more complicated, there's a learning curve but it's doable. I'm not sure where you were hoping to export the responses to, but definitely set up a SharePoint list and have them logged into there. Then if you want them somewhere else, add that on after. Trust me, it'll much easier to work with SharePoint lists in Flow than it is to work with any other type of document.
If you export the results to Excel, do you see information about the person who completed the survey, like their e-mail address and/or name? I use Forms at work, so they're always set to the "in my organization" option rather than the "anyone" option. I always can see the name and e-mail address of the respondent if I view results in Excel. If you are using the "available to anyone with link" option, I'm not sure how that works. You could always add a field for Name or e-mail and make it a required question.
Besides Excel, Forms has a Flow connector. I'm doing some pretty impressive things combining Forms and Flow. Flow will allow you to do almost whatever you want with the responses after they're submitted. It's relatively easy to figure out if you want to do something simple, like send yourself an alert and log the results into a SharePoint list whenever a response is completed. If you want to get more complicated, there's a learning curve but it's doable. I'm not sure where you were hoping to export the responses to, but definitely set up a SharePoint list and have them logged into there. Then if you want them somewhere else, add that on after. Trust me, it'll much easier to work with SharePoint lists in Flow than it is to work with any other type of document.
Wow Ryan. Thanks very much for your response, they really helped.
Following up on your responses, Everything I'm doing so far is going through Microsoft Teams. Are you referring to SharePoint? On the team site I didn't see any options for Flow.
1) With SharePoint lists, can you set up a list as a survey form similar to the way it's done in Microsoft forms? Is there flexibility in design, etc.
2) Are there any good examples out there that are similar to the way that you describe, in your response, using flow and forms within SharePoint?