Requesting assistance for a Flow using Forms response data

Copper Contributor

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...), 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/...), 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