Forum Discussion
Saving MS Form with many question responses to SharePoint
Hi,
A department wants to save responses received from a MS Form to a SharePoint list.
When I received the MS Form to create the columns in the SP list, noted there was 115 questions. Most of them are a Yes / No answer and a few where comments have been asked for.
Then a Flow will need to be created.
Firstly - This is too many questions.
Secondly - Would SharePoint be the best place to store these answers knowing that an Excel spreadsheet is created for the responses?
Thirdly - As the MS Form will be used regularly and responses coming in Day and Night is there another solution.
The results will be used to Analyse the results using PowerBI.
Chris_Clark1968 it's quite a lot of work, particularly if you are sending a confirmation email back to the responder, but it's within the 200 question maximum. I think the most I ever had to deal with was 135 questions.
You will need to make sure that the questions are unique, particularly the first 18 characters, otherwise it's very difficult to select the correct question in your flow.
Don't be tempted to make the columns names in SharePoint the full question. It's better practice to have short but identifiable column names.
SharePoint is definitely the best place to store the results; I certainly wouldn't save the responses to a different Excel spreadsheet. Over the years people have had problems with answers in the built-in spreadsheet being blank or rows deleted although I've never had this happen to me. So using a flow to save each response to a SharePoint list is best practice both from an audit and a backup point of view. The data can later be analysed in Power BI. There's no other good solution.
Rob
Los Gallardos
Microsoft Power Platform Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
2 Replies
Chris_Clark1968 it's quite a lot of work, particularly if you are sending a confirmation email back to the responder, but it's within the 200 question maximum. I think the most I ever had to deal with was 135 questions.
You will need to make sure that the questions are unique, particularly the first 18 characters, otherwise it's very difficult to select the correct question in your flow.
Don't be tempted to make the columns names in SharePoint the full question. It's better practice to have short but identifiable column names.
SharePoint is definitely the best place to store the results; I certainly wouldn't save the responses to a different Excel spreadsheet. Over the years people have had problems with answers in the built-in spreadsheet being blank or rows deleted although I've never had this happen to me. So using a flow to save each response to a SharePoint list is best practice both from an audit and a backup point of view. The data can later be analysed in Power BI. There's no other good solution.
Rob
Los Gallardos
Microsoft Power Platform Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Hi Rob_Elliott
Luckily the Form as sections so have used the sections names, abbreviated, within the column names..
I'm hoping that the responses are not required. If they are that's another issue 😁
I did think there isn't another way so thank for you response
