Home

Requesting assistance for a Flow using Forms response data

%3CLINGO-SUB%20id%3D%22lingo-sub-1294309%22%20slang%3D%22en-US%22%3ERequesting%20assistance%20for%20a%20Flow%20using%20Forms%20response%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294309%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20brand%20new%20to%20using%20Flow%20and%20i'm%20running%20into%20a%20bit%20of%20a%20road%20block.%20I'm%20attempting%20to%20create%20a%20Form%20for%20users%20to%20register%20to%20different%20time-slots%20for%20a%20webinar%20session%20and%20i'd%20like%20to%20utilize%20Flow%20to%20limit%20the%20amount%20of%20participants%2C%20as%20well%20as%20send%20the%20approval%20or%20full%20message%2C%20however%20I%20cant%20seem%20to%20get%20it%20to%20work%20limiting%20based%20off%20the%20response%20of%20the%20question%2C%20only%20total%20number%20of%20responses.%20Can%20anyone%20help%20me%20out%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuick%20Example%3A%3C%2FP%3E%3CP%3EWhat%20time%20slot%20would%20you%20like%20to%20attend%3F%3C%2FP%3E%3CP%3EOption%20A%3A%2010am-12pm%3C%2FP%3E%3CP%3EOption%20B%3A%2012%3A30pm-1%3A3pm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%2020%20people%20to%20select%20Option%20A%20get%20a%20%22Congrats!%20You've%20registered%22%20email%20containing%20the%20webinar%20info%20and%20calendar%20link%2C%20every%20response%20after%20that%20gets%20a%20%22We're%20sorry%20but%20registration%20for%20this%20time-slot%20is%20full%22%3C%2FP%3E%3CP%3ESame%20for%20Option%20B%2C%20first%2020%20get%20in%2C%20every%20after%20get%20denied%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1294309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1295215%22%20slang%3D%22en-US%22%3ERe%3A%20Requesting%20assistance%20for%20a%20Flow%20using%20Forms%20response%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295215%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615116%22%20target%3D%22_blank%22%3E%40Hookc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20there%20is%20no%20action%20in%20Power%20Automate%20to%20get%20the%20number%20of%20responses.%20Therefore%2C%20you%20should%20save%20the%20responses%20in%20a%20SharePoint%20list%2C%20for%20example%20(%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FFlow-to-record-info-from-Forms-in-SharePoint-list-including-the%2Ftd-p%2F93317%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FFlow-to-record-info-from-Forms-in-SharePoint-list-including-the%2Ftd-p%2F93317%3C%2FA%3E)%2C%20and%20then%2C%20when%20a%20new%20response%20is%20submited%2C%20coun%20the%20number%20of%20items%20in%20the%20SharePoint%20list%20(%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FUsing-Flows%2FCount-the-number-of-items-in-a-sharepoint-list%2Ftd-p%2F12117%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FUsing-Flows%2FCount-the-number-of-items-in-a-sharepoint-list%2Ftd-p%2F12117%3C%2FA%3E)%2C%20and%20depending%20on%20it%2C%20send%20an%20email%20or%20another.%3C%2FP%3E%3CP%3EYou%20can%20have%20a%20look%20at%20the%20Power%20Automate%3C%2FP%3E%3CP%3ECommunity%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Power-Automate%2Fct-p%2FMPACommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Power-Automate%2Fct-p%2FMPACommunity%3C%2FA%3E%3C%2FP%3E%3CP%3Ewhere%20you%20will%20find%20many%20solutions.%3C%2FP%3E%3CP%3EHope%20it%20helps.%3C%2FP%3E%3CP%3EFerran%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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