Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 90e0JqSpXtI1IXM3S9tZO1
Power Automate - Using Flows
Unanswered

Limit responses on MS forms question

Like (0) ShareShare
ReportReport
Posted on 26 May 2020 12:52:17 by 119

Hi Community,

 

Is there a way I can restrict the number of responses on MS forms for a specific question for event planning?

 

I have a MS forms page which has only one question on whats your preferred time slot with 3-4 options given in that question. Now as soon as the 10 entries for the 1st slot is filled, user should be notified through email that the slot is closed, choose from the remaining slots.

 

I can think of :

Step 1- When forms response is submitted as first step

Step 2 - update the entries on the SharePoint with the information from MS forms

I am stuck with 3rd step how to count the responses for a particular slot if it already has number of rows more than 10?

If its more than 10 then send email to user for rejection and choose a new slot. 

 

Any thoughts?

 

Thanks!

  • JG-29101545-0 Profile Picture
    2 on 29 Oct 2024 at 16:17:50
    Limit responses on MS forms question
    Hi @RobElliott. I have the same problem that @Mishatandon did. I've tried following your step-by-step instructions but, as that was more than four years ago, many of the options in Power Automate aren't the same.
     
    I'm new to Power Automate, so it may well be me being stupid! Either way, could you let me know if the process you outlined on 26 May 2020 is the same now.
     
    Thanks very much!
  • eehsparks Profile Picture
    2 on 21 Dec 2023 at 16:42:31
    Re: Limit responses on MS forms question

    Where do I get what the site address should be?

  • OD1 Profile Picture
    Microsoft Employee on 16 Aug 2023 at 16:13:10
    Re: Limit responses on MS forms question

    Hi I followed the approach above and PA said that the test ran successfully when i submitted a sample response via my form however I didn't get any email nor were either of the SharePoint lists updated. Can you please help?

     

    Also I would love more detail about the increment counter as requested by FFSuePugh and the solution outlined by ManishJain as I am also interested in limiting the number of responses per option rather than per form. Thank you

  • FFSuePugh Profile Picture
    2 on 09 May 2023 at 20:11:46
    Re: Limit responses on MS forms question

    I am a complete newbie to this. How did you even get to step one? How do I get that increment counter started?

  • forfeitt Profile Picture
    13 on 16 Mar 2023 at 09:23:13
    Re: Limit responses on MS forms question

    Good day Dear,

     

    I am a beginner so can you please share step by step guide 🙂 (or record a video how to do it). Many thanks!

  • MJain Profile Picture
    2,450 on 26 May 2020 at 19:33:04
    Re: Limit responses on MS forms question

    Hi @Mishatandon ,

     

    Get items from Sharepoint will bring all the responses submitted so far . You can filter the response by category and should be able to get count of each category and do further processing .

     

    Thanks

  • Mishatandon Profile Picture
    119 on 26 May 2020 at 17:36:28
    Re: Limit responses on MS forms question

    Hi @RobElliott ,

     

    The solution is great and there is only one exception in can see or have to build in . How would it tackle 2,3 or may be 4 slots which are available for the end user?

     

    Currently its taking into consideration the first 10 users based on only 1 slot, however I have 2-3 slots available.

     

    For example the question on MS - forms is 

     

    Q) what is your preferred time slot for the meeting?

    a) 27th May 10 AM

    b)27th May 5 PM

    c) 30th May 10AM

    d) 30th May 5 PM.

     

    So I want as soon as the there are 10 users signed up for option 'a' then the person should get notification that the slot is filled. however if there are only 5 slots filled in for option 'b' ( which may not be visible to user nor I want that to be visible) the user can successfully register for slot b or slot c or slot d if there are slots available.

     

    If you could help or guide with the above tackling of slots?

     

    The solution otherwise is great, I learnt a new thing today!

  • RobElliott Profile Picture
    10,134 Super User 2025 Season 1 on 26 May 2020 at 14:25:11
    Re: Limit responses on MS forms question

    @Mishatandon one way that this can be done is to have a separate list for the course to hold the current number of participants. So initially you would create the item in that list (there will only ever be 1 item) and set it to 0. It will increment as each user signs up.

    0-IncList.png

     You would hold the details of the participants in your main list:

    1-ParticipantList.png

     The flow is as follows. When a new response is submitted, get the response details. Next get the row from the SharePoint Course increment list

     

    4-flow1.png

     

    Next, add an apply to each and select value (from the Get items). Add a Compose control (which I've named ComposeCurrentNumber) to hold the number from the NumberSignedUp column.

    Next, add a condition of if the output of the ComposeCurrentNumber is less than or equal to 9. In other words if the increment list has a NumberSignedUp value to 10 you don't want to sign up any more people.

     

    5-flow2.png

    I recommend you set the concurrency settings in the Apply to Each to On and set it to 1 so that if 2 people respond at the same time the flow will run correctly:

    8-Concurrency.png

    In the green if Yes channel update the SharePoint Course increment list and set the new value of the NumberSignedUp column to the following expression: 

    add(outputs('ComposeCurrentNumber'),1)

    Next, create an item in the main Participants SharePoint list.

    6-Flow3.png
    The last action in the green If yes channel is to send a "You are registered..." email

    7-Flow-4.png

    In the red If No channel update the increment list and send the "sorry.." email.

    The email for the first 10 participants is shown below: 2-emailSuccess.png

    And the "sorry email" is:

    3-Email-NotSignedUp.png

    One of the advantages of this method is that even though it won't add anyone after the 10th person the the course, it still updates the increment list. So you now how many people wanted to attend if though only 10 could do so.

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

#1
VictorIvanidze Profile Picture

VictorIvanidze 2

Overall leaderboard

Featured topics

Restore a deleted flow