Submitting Information for Multiple Activities in MS Forms in One Submission? [Table feature?]

Hi rleer 

A few questions:

• Do you have access to Forms Pro (potential costs associated) or Forms only?
• Do you have access to Power Automate to be able to create flows?

If you want admin assistants to be able to create the travel approvals for multiple people but don't want them to do it one at a time, then it might not be the best option, and you might be better of creating spreadsheets still.

However, if you want to have all of the requests available on one area, but don't want everyone having access to the same spreadsheet, then Forms Pro might be your answer. That then takes you back to having the admin person filling out the form. 

What you COULD potentially do (assuming you have Forms Pro and Power Automate) is have a survey that asks how many people do you want to submit in the request for the first question. Then use branching rules to determine how many other questions show. However, you would only likely be able to do a handful of people at a time as you would need to have a question for each number. So it would be a question for Traveler Name One, then a question for Traveler Name Two, Traveler Name Three and so on. Those questions would need to exist so you could show or hide them depending on the number selected at the start. 

The best option if you are looking at a new process, is one form submission per traveller. It's the same amount of typing, and it means you can control what happens with the responses a little easier.

Hope it makes sense, any questions, let me know! This might help in terms of how you could add the responses to Excel/SharePoint etc. - https://meganvwalker.com/extracting-survey-variables-from-forms-pro-responses-without-access-to-cds/ - this is with Forms Pro.