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.
Create a Microsoft Form:Create a form with the questions you need.
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.