Booking holidays

[Cesarjblues]

Hi everyone, im new in this amazing world of powerapps, im trying to create a new app to reserve an specific date with a maximun limit per date. The first parte i made it with a sharepoint form with the dates and areas of my employees, but i dpnt know how to limit the spaces available per date. Example:

I have 10 spaces available from jan 1st to jan 15th, i want that when an employee select thks dates update automatically the quotes available. 

Thanks in advance for your help

[JR-BejeweledOne]

What does your data source look like where you are saving this information?

[Cesarjblues]

I only got this colums, employee, initial date, final date, wich area the employee belongs.

[JR-BejeweledOne]

What I would do, when an employee selects a date, create a filtered collection from the data source for that date, then use something like this:

If(

CountRows(Collection) >= 10, then do something

You could have a warning label saying that the date is filled and set the visible property to:

If(

  CountRows(Collection) >= 10, true, false)

)  And use the same to set the Submit button display mode to Disabled.

[JR-BejeweledOne · Accepted solution]

Did this solve your issue or can I assist more?