Announcements
Hello, I'm Trying to build this desk reservation app on Power apps, very simple, in order for people to reserve their space in the office but we have a limit that we can have per day in the office, can i restrict the number of entries done per day so that day gets greyed out or not available after it has surpass x amount of people registered.
Hi @miroones ,
If you use sharepoint list as your datasource, you could create a list. The list stores all the offices and the number of uses.
Another list is used to collect user registration history.
If(CountRows(Filter(Another_list,Office_Name = "***"&& Your_registration_date_column= Today()))=LookUp(Office_List,Office_Name="***").Total_Number,false,true)
Best Regards,
Wearsky
Yes, I use sharepoint as my datasource and these are the colums I have created. We want the app to enter the information in Sharepoint that is entered by the user but we want to limit x amount of people per day to be in the office.
Please try my formula. I think my formula works for you.
I would like to try your formula but your formula uses two lists, I only use one list in sharepoint, If you can help me adapt it to my list. I would use it definetely.
My list has these fields
Employee Name
Supervisor
Supervisor Email
Reservation Date
Office
If you only have one table, how to know the maximum number of times users can apply for a certain office?
Do you have a table to store the number of applications for all offices daily ?
My List in sharepoint stores whats entered in the app, which includes the information of the office and who reserved it and the date, I don't know, what I want is to limit the amount of reservations per day and office to 7. Whether they are going to office 1 or office 2 only 7 reservations can be made per office per day.
I did a test for you.
If(CountRows(Filter(LIST179,Title=TextInput1.Text,My_Date_Column=Today()))>=7,DisplayMode.Disabled,DisplayMode.Edit)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 394 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 324 Most Valuable Professional
