Forum Discussion
Requesting assistance for a Flow using Forms response data
Hey everyone,
I'm brand new to using Flow and i'm running into a bit of a road block. I'm attempting to create a Form for users to register to different time-slots for a webinar session and i'd like to utilize Flow to limit the amount of participants, as well as send the approval or full message, however I cant seem to get it to work limiting based off the response of the question, only total number of responses. Can anyone help me out please?
Quick Example:
What time slot would you like to attend?
Option A: 10am-12pm
Option B: 12:30pm-1:3pm
The first 20 people to select Option A get a "Congrats! You've registered" email containing the webinar info and calendar link, every response after that gets a "We're sorry but registration for this time-slot is full"
Same for Option B, first 20 get in, every after get denied
1 Reply
Hello Hookc
Currently there is no action in Power Automate to get the number of responses. Therefore, you should save the responses in a SharePoint list, for example (https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-record-info-from-Forms-in-SharePoint-list-including-the/td-p/93317), and then, when a new response is submited, coun the number of items in the SharePoint list (https://powerusers.microsoft.com/t5/Using-Flows/Count-the-number-of-items-in-a-sharepoint-list/td-p/12117), and depending on it, send an email or another.
You can have a look at the Power Automate
Community: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
where you will find many solutions.
Hope it helps.
Ferran
