How to send an email when a choice in a sharepoint column reaches a certain number?

Question

Greetings!

I am working on a solution where a Microsoft form will be sent out as an invitation to an event. The choices will be

1. Attending
2. Not attending

This event will only be available to the first 48 people who mark that they will be attending. How can I have power automate monitor the list so that when 48 people mark that they will be attending the event, I can get an email and then start waitlisting the others that now mark attending?

Thank you in advance

Answer 1

You can check following article to monitor flows:

https://www.winon365.ch/blog/monitor-microsoft-power-automate-cloud-flows

Answer 2

Here is an example flow for you:

Form:

Flow:

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.