Flow to run and send an email when more than 5 SharePoint entries have the same date

[tommy250]

Hi

I have a Form being completed for booking appointments which allows for the the user to select a date for their appointment, submitting the form updates a Sharepoint list with the details from the Form.

Is it possible to create a flow so that once 5 users select the same date the 6+ user is sent an email to ask them to select a different date, I understand that they will have to resubmit another Form.

Any help on this would be greatly appreciated.

Thanks

Tommy

[annajhaveri]

You can use Get Items action to get the items of selected date, and see if returned items are 5, then you can send email

[tommy250]

Thanks for your reply @annajhaveri I will try this out.