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
What does your data source look like where you are saving this information?
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.
User | Count |
---|---|
183 | |
105 | |
89 | |
44 | |
44 |
User | Count |
---|---|
226 | |
107 | |
106 | |
68 | |
67 |