Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Suggested answer

Wait until 14 items had been added, then send an email

(0) ShareShare
ReportReport
Posted on by 20
Hello community!!
 
I was wondering if there is any way to wait until 14 times a form has been filled in because after that, I want to send an email with a report. After the email was sent I need to wait until another 14 items to be entered.
 
 
 
  • PM-13052142-0 Profile Picture
    20 on at
    Wait until 14 items had been added, then send an email
     
    Thanks for your replay. The main issue that I´m dealing with is to count those 14th responses.
  • lbendlin Profile Picture
    7,941 Super User 2025 Season 1 on at
    Wait until 14 items had been added, then send an email
    Having a flow wait is a design red flag. Instead, run a periodic flow that counts the responses and terminates if less than 14.
  • PM-13052142-0 Profile Picture
    20 on at
    Wait until 14 items had been added, then send an email
     
    Thanks for your prompt response!!! I managed to pull this out.
     
     
    Every time a response is sent "value" increases +1. I still can´t figure out how to re-use this info to know when 14 responses had been filled out
     
     
    Sorry but I´m a very basic user, the rest I think.
  • Suggested answer
    MS.Ragavendar Profile Picture
    2,215 on at
    Wait until 14 items had been added, then send an email
     
    This is the approach you need to try.
     
    1. Create a Microsoft Form: Create a form with the questions you need. 
       
    2. Set up a Power Automate flow:
      • Trigger: Set the trigger to "When a new response is submitted" for your form. 
         
      • Count Responses: Use an action like "Get responses" or "List responses" to fetch the current responses and count them. There might be limitations or specific workarounds depending on the version of Microsoft Forms you are using and the available flow actions. 
         
      • Conditional Check: Use a condition to check if the count is equal to or greater than 14. 
         
      • Wait (if needed): If the count is less than 14, consider adding a "Wait" action to pause the flow and check again later, or design the flow to continuously monitor the responses until the target is reached. 
         
      • Action when 14 Responses Reached: Once 14 responses are reached, add the action(s) you need. This could be anything from sending an email to a specific person or group, to updating a SharePoint list with the collected responses. 
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Restore a deleted flow