Send an email on the basis of count in Sharepoint List

[rsinha]

Hi Folks,

I need to create a flow on the basis of no of records created in Sharepoint List in a particular day.

I have a Power App where user book their seats and their details store in SP List. Admin wants to receive an email as soon as seat limit is reached in a particular day. Lets suppose its 100, if 100 users book their seats for today, admin receive an email that seats for today are booked.

How can I build this flow?

Kindly suggest.

Thank you!

[grantjenkins]

I would create a flow that triggers when a new item is created. Then in the flow use Get items with whatever criteria you wish to add in the Filter Query. Then have a Condition to check the length of the items returned, and if equal to 100 then send the email.

1. Trigger on When a new item is created
2. Get items (with appropriate filter criteria such as only items created today)
3. Condition that gets the length of the Get items output
   1. If length is equal to 100 - Send an email

[annajhaveri]

@rsinha  you can create a scheduled flow and use Get Items action with filter query Created (date) is equals to today's date. Then check length of items returned by Get Items based on that use Send Email action to send the email.