Hard Stop on sing-up form

[NathanFra]

All,

I have a request from a user to create a sign-up sheet for employees. There are 2 dates the employees can select from, but only 250 spots per date. 

I need to have the dates become unavailable once a 250 limit it hit for each date. Not really sure how to accomplish this. 

The 'Game' column is the date picker for the dates they can select from.

[C-Papa · Accepted solution]

hi, you could use countrows() to do this. for example, lets say your SharePoint list is called BookedDays and the date is in a column called date. 

CountRows(Filter('BookedDays','Date' = DateValue("23/06/2021"))

this would return a count of rows where the date is 23/06/2021