Answered

Booking holidays

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What does your data source look like where you are saving this information?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I only got this colums, employee, initial date, final date, wich area the employee belongs.
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Did this solve your issue or can I assist more?