Mar 31 2020
02:12 AM
- last edited on
Aug 06 2023
05:09 PM
by
TechCommunityAP
Mar 31 2020
02:12 AM
- last edited on
Aug 06 2023
05:09 PM
by
TechCommunityAP
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.
Mar 31 2020 07:35 AM
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
Mar 31 2020 07:35 AM
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