How to use Microsoft Forms as an enrollment form?

%3CLINGO-SUB%20id%3D%22lingo-sub-2893227%22%20slang%3D%22en-US%22%3EHow%20to%20use%20Microsoft%20Forms%20as%20an%20enrollment%20form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2893227%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20new%20to%20Microsoft%20Forms%20and%20I'm%20looking%20to%20digitize%20an%20enrollment%20form%20that's%20currently%20filled%20out%20by%20hand.%20I%20currently%20take%20this%20form%20that's%20emailed%20to%20me%20and%20then%20I%20have%20to%20manually%20log%20the%20information%20in%20Excel.%20The%20problem%20I'm%20running%20into%20with%20forms%20is%20that%20I%20don't%20know%20how%20to%20format%20the%20questions%20so%20that%20it%20returns%20it%20in%20the%20Excel%20format%20I%20need.%20Recipients%20receive%20one%20form%2C%20but%20the%20form%20then%20can%20have%20up%20to%20five%20people%20listed%20in%20it.%20I%20need%20each%20individual's%20Name%2C%20Title%2C%20ID%20and%20a%20share%20of%20percentage%20(this%20is%20for%20paying%20them%20out)%2C%20totaling%20100%25%20for%20that%20place%20of%20business.%20It's%20not%20possible%20for%20each%20individual%20to%20fill%20it%20out%20because%20they%20have%20to%20have%20their%20percentage%20add%20up%20to%20100%25%20for%20that%20one%20store.%20Is%20this%20possible%20through%20Microsoft%20Forms%3F%20I%20tried%20listing%20this%20information%20into%20multiple%20questions%2C%20but%20when%20I%20export%20to%20Excel%2C%20it's%20not%20generating%20what%20I%20need.%20Thanks%20for%20any%20guidance%20this%20forum%20can%20provide!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2893227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERegistration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, I'm new to Microsoft Forms and I'm looking to digitize an enrollment form that's currently filled out by hand. I currently take this form that's emailed to me and then I have to manually log the information in Excel. The problem I'm running into with forms is that I don't know how to format the questions so that it returns it in the Excel format I need. Recipients receive one form, but the form then can have up to five people listed in it. I need each individual's Name, Title, ID and a share of percentage (this is for paying them out), totaling 100% for that place of business. It's not possible for each individual to fill it out because they have to have their percentage add up to 100% for that one store. Is this possible through Microsoft Forms? I tried listing this information into multiple questions, but when I export to Excel, it's not generating what I need. Thanks for any guidance this forum can provide!

1 Reply

@MChen92618 what format do you need your answers to be in for Excel? It sounds like this could be easily achieved with a flow in Power Automate, but a bit more info about how you want to to look in Excel would help.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User