MS Forms Simple 'Sign Up'

%3CLINGO-SUB%20id%3D%22lingo-sub-1745766%22%20slang%3D%22en-US%22%3EMS%20Forms%20Simple%20'Sign%20Up'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1745766%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20use%20MS%20Forms%20a%20lot%20at%20our%20School%2FCollege%20and%20would%20love%20to%20have%20the%20functionality%20wherein%20Students%20%26amp%3B%20Parents%20can%20'Reserve'%20places%20at%20school%20events%20by%20using%20a%20MS%20Form.%20Crucially%20the%20form%20would%20have%20to%20display%20the%20number%20of%20seats%2Fplaces%20available%20depending%20on%20the%20responses%20already%20submitted.%20(There%20is%20no%20need%20for%20ticketing%2Ftransactions%2C%20just%20the%20simple%20ability%20to%20reserve%20a%20place%20and%20see%20how%20many%20places%20are%20left%20-%20We%20could%20then%20mine%20the%20Database%20before%20the%20event%20and%20adjust%20event%20locations%2Fseats%20etc%20accordingly)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20along%20the%20lines%20of%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3EArt%20Presentation%20-%206.30%20-%20Room%20A1%20-%2025%20Places%20Available%20(15%20places%20left)%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EBiology%20Lecture%20-%206.40%20-%20Room%20B2%20-%2025%20Places%20Available%20(6%20places%20left)%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realise%20this%20would%20require%20the%20need%20for%20the%20form%20data%20to%20update%20the%20form%20depending%20on%20the%20responses%20received%20but%20it%20can't%20be%20Rocket%20Surgery....or%20could%20it%3F%20Any%20thoughts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1745766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERegistration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1769009%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Forms%20Simple%20'Sign%20Up'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1769009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F820555%22%20target%3D%22_blank%22%3E%40BudehavenResources%3C%2FA%3E%26nbsp%3Bthere%20is%20no%20way%20for%20that%20to%20be%20done%20with%20Forms%20as%20it%20can't%20query%20a%20SharePoint%20list%20before%20a%20user%20completes%20it.%20You%20would%20need%20to%20use%20a%20Power%20Apps%20form%20linked%20to%20a%20Sharepoint%20list%20for%20the%20event.%20Then%20it%20starts%20to%20become%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

We use MS Forms a lot at our School/College and would love to have the functionality wherein Students & Parents can 'Reserve' places at school events by using a MS Form. Crucially the form would have to display the number of seats/places available depending on the responses already submitted. (There is no need for ticketing/transactions, just the simple ability to reserve a place and see how many places are left - We could then mine the Database before the event and adjust event locations/seats etc accordingly)

 

Something along the lines of:

Art Presentation - 6.30 - Room A1 - 25 Places Available (15 places left)

Biology Lecture - 6.40 - Room B2 - 25 Places Available (6 places left)

 

I realise this would require the need for the form data to update the form depending on the responses received but it can't be Rocket Surgery....or could it? Any thoughts.

1 Reply

@BudehavenResources there is no way for that to be done with Forms as it can't query a SharePoint list before a user completes it. You would need to use a Power Apps form linked to a Sharepoint list for the event. Then it starts to become possible.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User