Share via

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

Loya, Shelby K 0 Reputation points
2023-09-21T17:41:47.8166667+00:00

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

Microsoft 365 and Office | SharePoint | For business | Windows

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cloudoire Academy 23,595 Reputation points Volunteer Moderator
    2023-09-21T18:13:19.6933333+00:00

    You can check following article to monitor flows:

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

    0 comments
  2. Emily Du-MSFT 51,946 Reputation points Microsoft External Staff
    2023-09-22T06:05:01.2+00:00

    Here is an example flow for you:

    Form:

    User's image

    Flow:

    User's image

    Result:

    1

    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.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.