SOLVED
Home

Limit responses on drop down choice

%3CLINGO-SUB%20id%3D%22lingo-sub-1267216%22%20slang%3D%22en-US%22%3ELimit%20responses%20on%20drop%20down%20choice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267216%22%20slang%3D%22en-US%22%3E%3CP%3EHelo%2C%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20limit%20responses%20on%20a%20choice%20in%20a%20drop%20down%20menu%3F%3C%2FP%3E%3CP%3ESee%20pic%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20limit%20the%20response%20to%2010%20per%20date%20session.%20For%20example%2C%2016.04.20%20can%20only%20be%20chosen%20by%2015%20times.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22forms11.PNG%22%20style%3D%22width%3A%20416px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180821i5626A71F9D50949F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22forms11.PNG%22%20alt%3D%22forms11.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1267216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERegistration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1268177%22%20slang%3D%22en-US%22%3ERe%3A%20Limit%20responses%20on%20drop%20down%20choice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572044%22%20target%3D%22_blank%22%3E%40siri1231560%3C%2FA%3E%26nbsp%3Bno%20you%20can't%20do%20this%20out-of-the-box.%20What%20we%20do%20in%20my%20company%20is%20to%20have%20a%20list%20in%20SharePoint%20with%20the%20current%20increment%20number%2C%20that%20is%20the%20number%20of%20people%20currently%20signed%20up%20for%20each%20training%20course.%20The%20users%20use%20Microsoft%20Forms%20to%20request%20a%20place%20on%20a%20specific%20course.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20we%20use%20a%20flow%20in%20Power%20Automate%20so%20that%20when%20a%20user%20sends%20the%20request%20the%20flow%20triggers%20and%20gets%20the%20current%20increment%20value.%20If%20it%20is%2010%20or%20more%20an%20email%20is%20sent%20back%20automatically%20to%20the%20requestor%20saying%20%22Sorry%2C%20that%20course%20is%20now%20full%2C%20please%20select%20another%20one%22.%20If%20the%20increment%20value%20is%20less%20than%2010%20an%20email%20is%20sent%20to%20them%20saying%20%22Your%20place%20is%20booked...%22%20with%20a%20link%20to%20a%20SharePoint%20page%20with%20more%20details%2C%20and%20the%20flow%20updates%20the%20SharePoint%20increment%20list%20list%2C%20adding%201%20to%20the%20total.%20We%20have%20a%20list%20for%20each%20course%20and%20the%20flow%20then%20adds%20the%20person%20to%20the%20relevant%20list%20which%20the%20course%20leader%20can%20access.%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Helo,

Is it possible to limit responses on a choice in a drop down menu?

See pic attached.

 

I need to limit the response to 10 per date session. For example, 16.04.20 can only be chosen 10 times.forms11.PNG

1 Reply
Highlighted
Solution

@siri1231560 no you can't do this out-of-the-box. What we do in my company is to have a list in SharePoint with the current increment number, that is the number of people currently signed up for each training course. The users use Microsoft Forms to request a place on a specific course.

 

Then we use a flow in Power Automate so that when a user sends the request the flow triggers and gets the current increment value. If it is 10 or more an email is sent back automatically to the requestor saying "Sorry, that course is now full, please select another one". If the increment value is less than 10 an email is sent to them saying "Your place is booked..." with a link to a SharePoint page with more details, and the flow updates the SharePoint increment list list, adding 1 to the total. We have a list for each course and the flow then adds the person to the relevant list which the course leader can access.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User